[GENERAL] Error: [Custom Archiver]: Out of memory

2012-08-02 Thread Edison So
Hello all, Can someone please help me how to resolve the error "[Custom Archiver]: Out of memory" during a restore in a Windows server 2008 running Postgresql 9.0? Thanks in advance. -- Edison

Re: [GENERAL] PGbouncer for Windows 2008

2012-01-22 Thread Edison So
have a SDE environment to rebuild the ,exe file. Any other idea? Cheers, On Sat, Jan 21, 2012 at 8:40 AM, tuanhoanganh wrote: > http://winpg.jp/~saito/pgbouncer/ > > > On Fri, Jan 20, 2012 at 11:01 PM, Edison So wrote: > >> Hello, >> >> Can anyone please tell me wh

[GENERAL] PGbouncer for Windows 2008

2012-01-20 Thread Edison So
Hello, Can anyone please tell me where I can find the PGbouncer executable and tutorial for Windows 2008? I found one but need to recompile on Windows. I also need intuitive instructions to configure it too. Thanks in advance. -- Edison

Re: [GENERAL] max_connections proposal

2011-05-29 Thread Edison So
Thank Graig for the links. You have been very helpful. When I get time, I will definitely read over the materials to get familar with Postgres. Have a wonderful night. Edison On Sun, May 29, 2011 at 7:27 PM, Craig Ringer wrote: > On 05/30/2011 03:26 AM, Edison So wrote: > >> Than

Re: [GENERAL] max_connections proposal

2011-05-29 Thread Edison So
. Can you tell where I can get one. I just want a Postgres 9.x administration course which also talks about built-in replication and Slony. I do not mind traveling to USA for it. Thanks, On Sun, May 29, 2011 at 4:39 AM, Craig Ringer wrote: > On 29/05/2011 10:44 AM, Edison So wrote: > >>

Re: [GENERAL] max_connections proposal

2011-05-28 Thread Edison So
Can anyone tell me that if the max_connections is above 100, the server will use pooling instead? For all participants in this particular dsicuss, what is the reasonable value for max_connections without causing any harm to the Postgres 9.0 server. I am a nonvice Postgres user so any advice is al

Re: [GENERAL] New feature: selectivity - new attribute in function

2011-04-16 Thread Edison So
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: &

Re: [GENERAL] New feature: selectivity - new attribute in function

2011-04-16 Thread Edison So
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

Re: [GENERAL] New feature: selectivity - new attribute in function

2011-04-16 Thread Edison So
2011 at 5:17 PM, Raymond O'Donnell wrote: > 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 > >

Re: [GENERAL] New feature: selectivity - new attribute in function

2011-04-16 Thread Edison So
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. :) > > Than

Re: [GENERAL] New feature: selectivity - new attribute in function

2011-04-16 Thread Edison So
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 agai

Re: [GENERAL] New feature: selectivity - new attribute in function

2011-04-16 Thread Edison So
, 2011/4/16 Adrian Klaver > 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 &g

Re: [GENERAL] New feature: selectivity - new attribute in function

2011-04-16 Thread Edison So
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 p

Re: [GENERAL] New feature: selectivity - new attribute in function

2011-04-16 Thread Edison So
tion returns true. > > 2011/4/15, Edison So : > > I have a DELL server running Windows server 2003 and Postgres 8.1. > > > > I used pg_dump to back up a database test: > > > > pg_dump -v -h localhost -p 5432 -U postgres -F c -b -f > > "D:/db_dump/ba

Re: [GENERAL] Help: pg_restore failure

2011-04-15 Thread Edison So
e "exclude" option like "-T" in 8.4. Some tables in my database are of 1G in size. I need to isolate them so as to keep the backup less than 2G in size. Thanks, On Fri, Apr 15, 2011 at 6:58 PM, Adrian Klaver wrote: > On 04/15/2011 01:15 PM, Edison So wrote: > >> I have

[GENERAL] Help: pg_restore failure

2011-04-15 Thread Edison So
I have a DELL server running Windows server 2003 and Postgres 8.1. I used pg_dump to back up a database test: pg_dump -v -h localhost -p 5432 -U postgres -F c -b -f "D:/db_dump/backup.bak" test The backup was showing the following error. . pg_dump: dumping contents of table history pg_dump: [cu