Re: [PERFORM] Problems with PostGreSQL and Windows 2003

I'm already using a cursor via ODBC. > On Nov 24, 2007 10:57 PM, <[EMAIL PROTECTED]> wrote: >> Hello, >> >>I forgot to say that I changed work_mem to 16 MB but I didn't have >> sucess. >> I received the same >> error message. > > The error message you're getting is from your client bec

Re: [PERFORM] Problems with PostGreSQL and Windows 2003

Are you then trying to process the whole data set at once? I'm pretty certain the issue is your app, not pgsql, running out of memory. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PERFORM] Problems with PostGreSQL and Windows 2003

Hi, I'm using a cursor. Here is the a piece of log file (psqlodbc): [0.000]conn=02DE3A70, PGAPI_DriverConnect( in)='DSN=BI;UID=biuser;PWD=x;', fDriverCompletion=0 [0.000]DSN info: DSN='BI',server='localhost',port='5432',dbase='BI',user='biuser',passwd='x' [0.000] onlyread='0

[PERFORM] doubt with pg_dump and high concurrent used databases

Hi all, I read that pg_dump can run while the database is being used and makes "consistent backups". I have a huge and *heavy* selected, inserted and updated database. Currently I have a cron task that disconnect the database users, make a backup using pg_dump and put the database online again.

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

Pablo Alcaraz wrote: I read that pg_dump can run while the database is being used and makes "consistent backups". I have a huge and *heavy* selected, inserted and updated database. Currently I have a cron task that disconnect the database users, make a backup using pg_dump and put the database o

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

On Nov 25, 2007, at 10:46 AM, Pablo Alcaraz wrote: Hi all, I read that pg_dump can run while the database is being used and makes "consistent backups". I have a huge and *heavy* selected, inserted and updated database. Currently I have a cron task that disconnect the database users, make a b

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

On 25/11/2007, Erik Jones <[EMAIL PROTECTED]> wrote: > > On Nov 25, 2007, at 10:46 AM, Pablo Alcaraz wrote: > > > Hi all, > > > > I read that pg_dump can run while the database is being used and makes > > "consistent backups". > > > > I have a huge and *heavy* selected, inserted and updated databas

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

"Peter Childs" <[EMAIL PROTECTED]> writes: > On 25/11/2007, Erik Jones <[EMAIL PROTECTED]> wrote: >>> Does the pg_dump create this kind of "consistent backups"? Or do I >>> need to do the backups using another program? >> >> Yes, that is exactly what pg_dump does. >> > Yes so long as you are usin

Re: [PERFORM] doubt with pg_dump and high concurrent used databases

Tom Lane wrote: "Peter Childs" <[EMAIL PROTECTED]> writes: On 25/11/2007, Erik Jones <[EMAIL PROTECTED]> wrote: Does the pg_dump create this kind of "consistent backups"? Or do I need to do the backups using another program? Yes, that is exactly what pg_dump does. Yes