Hi.
It is sometimes hard to tune complicated queries. Maybe add new
attribute to functions returning boolean - selectivity, defining how
big is percent of rows for which the function returns true.
2011/4/15, Edison So :
> I have a DELL server running Windows server 2003 and Postgres 8.1.
>
> I use
Thank you for the reply.
It has nothing to do with programming. I was trying to back up the 8.1
database (using pg_dump) which had exceeded 2Gig limit according to a
response. When I tried to restore it using pg_restore to a 9.0 database, it
complained about custom archiver error and corruption an
On 16 Apr 2011, at 22:10, Edison So wrote:
> One response told me to try backing up 8.1 database using 9.0 pg_dump and
> restore it to 9.0 database using 9.0 pg_restore.
You shouldn't try to restore into a newer database version with a dump made
with an older pg_dump. Pg_dump isn't (and can't b
Hello Alban,
Thank you for the suggestion.
May I ask you and others another advice as to taking a Postgres course?
I am not a DBA and have never taken a database course. However, I am using
Postgres for a system I am supporting. Any suggestion? I need to set up a
primary-standby or load-balancin
On Saturday, April 16, 2011 1:10:39 pm Edison So wrote:
> Thank you for the reply.
>
> It has nothing to do with programming. I was trying to back up the 8.1
> database (using pg_dump) which had exceeded 2Gig limit according to a
> response. When I tried to restore it using pg_restore to a 9.0 dat
On Saturday, April 16, 2011 1:10:39 pm Edison So wrote:
> Thank you for the reply.
>
> It has nothing to do with programming. I was trying to back up the 8.1
> database (using pg_dump) which had exceeded 2Gig limit according to a
> response. When I tried to restore it using pg_restore to a 9.0 dat
Hello Adrian,
Thank you for your reply again.
I will try to use your previous suggestion that I will backup 8.1 database
using 9.0 pg_dump and restore it to 9.0 database. Hopefully, 9.0 pg_dump
will work on 8.1 database. I have never taken a DB course and very very new
to Postgres.
Thanks again,
On Saturday, April 16, 2011 1:59:48 pm Edison So wrote:
> Hello Adrian,
>
> Thank you for your reply again.
>
> I will try to use your previous suggestion that I will backup 8.1 database
> using 9.0 pg_dump and restore it to 9.0 database. Hopefully, 9.0 pg_dump
> will work on 8.1 database. I have
Haha. Having a QA background for many years, I do not believe in anything
until it is tested. :)
Thanks.
On Sat, Apr 16, 2011 at 5:02 PM, Adrian Klaver wrote:
> On Saturday, April 16, 2011 1:59:48 pm Edison So wrote:
> > Hello Adrian,
> >
> > Thank you for your reply again.
> >
> > I will try to
Oh yeah.
Forgot to mention that Postgres 9.0 does not have an option to restore text
based back up file. Do you know how?
On Sat, Apr 16, 2011 at 5:06 PM, Edison So wrote:
> Haha. Having a QA background for many years, I do not believe in anything
> until it is tested. :)
>
> Thanks.
>
> On S
On Saturday, April 16, 2011 2:06:44 pm Edison So wrote:
> Haha. Having a QA background for many years, I do not believe in anything
> until it is tested. :)
I have done it enough times to know it works. The issue that might arise are
not
related to the pg_dump program but version changes in beha
On Saturday, April 16, 2011 2:07:48 pm Edison So wrote:
> Oh yeah.
>
> Forgot to mention that Postgres 9.0 does not have an option to restore text
> based back up file. Do you know how?
>
It is the same for all versions.
psql (options) -f text_dump.sql
--
Adrian Klaver
adrian.kla...@gmail.co
On 16/04/2011 22:07, Edison So wrote:
Oh yeah.
Forgot to mention that Postgres 9.0 does not have an option to restore
text based back up file. Do you know how?
Surely:
psql -f
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-genera
On Saturday, April 16, 2011 2:07:48 pm Edison So wrote:
> Oh yeah.
>
> Forgot to mention that Postgres 9.0 does not have an option to restore text
> based back up file. Do you know how?
>
Just realized, if you are using the 9.0 version of pg_dump you can do a binary(-
Fc) dump against the 8.1 se
Hello gang,
I'm using pokertracker3. I want to buy a new computer and my priority is that
it runs as fast as possible. I have a question about SSD. If i buy a 300 Go
SSD, will it gains performance compared to a 1rpm velociraptor??? And is
the durability of the SSD will be ok since I know
Hi,
I'm trying to implement tenant view filter with postgres. The docs says
"Rewrite rules don't have a separate owner. The owner of a relation (table
or view) is automatically the owner of the rewrite rules that are defined
for it. The PostgreSQL rule system changes the behavior of the default
a
I did that with Postgres 8.1 backup file on 9.0 database. I got continuous
error messages like "Can not execute the command...". Well, I do not need
worry about it for I am going to back up 8.1 database using 9.0 pg_dump
command.
Let's see how it goes.
Thanks,
On Sat, Apr 16, 2011 at 5:17 PM, Ra
On Saturday, April 16, 2011 4:05:52 pm Edison So wrote:
> I did that with Postgres 8.1 backup file on 9.0 database. I got continuous
> error messages like "Can not execute the command...". Well, I do not need
> worry about it for I am going to back up 8.1 database using 9.0 pg_dump
> command.
>
>
Yes, I was.
The backup successfully created the schema followed by continuous error
messages. It would be nice to have informative error message.
Thanks,
On Sat, Apr 16, 2011 at 7:10 PM, Adrian Klaver wrote:
> On Saturday, April 16, 2011 4:05:52 pm Edison So wrote:
> > I did that with Postgres
On Saturday, April 16, 2011 4:24:38 pm Edison So wrote:
> Yes, I was.
>
> The backup successfully created the schema followed by continuous error
> messages. It would be nice to have informative error message.
What exactly where the error messages? Also the degree of verbosity and level
of
deta
On 04/16/11 10:46 AM, Sébastien Beaulieu wrote:
Hello gang,
I'm using pokertracker3. I want to buy a new computer and my priority
is that it runs as fast as possible. I have a question about SSD. If i
buy a 300 Go SSD, will it gains performance compared to a 1rpm
velociraptor??? And is th
I used the option "-v" with the pg_restore command in the 9.0 database
machine. If you want the exact error message, I will have to give it to you
on Monday.
Thanks,
On Sat, Apr 16, 2011 at 8:17 PM, Adrian Klaver wrote:
> On Saturday, April 16, 2011 4:24:38 pm Edison So wrote:
> > Yes, I was.
>
Hi,
We installed postgresql contrib package to make use of tablefunc library
However when we try to use it, it gives following error:
[pgadmins@dbserver ~]$ psql -U postgres someDBname
psql (9.1alpha1)
Type "help" for help.
halflines=# \i /usr/pgsql-9.1/share/contrib/tablefunc.sql
SET
psql
23 matches
Mail list logo
