R: [ADMIN] Out of memory...

rotation_size";"0" "log_statement";"none" "log_truncate_on_rotation";"off" "logging_collector";"on" "maintenance_work_mem";"300MB" "max_connections";"250" "max_stack_depth";&quo

[ADMIN] Out of memory...

Hi all, This morning my db experienced 10 minutes of "out of memory" condition with the log filled up of messages like : TopMemoryContext: 90856 total in 13 blocks; 7936 free (6 chunks); 82920 used   TopTransactionContext: 24576 total in 2 blocks; 21360 free (15 chunks); 3216 used   TOAST to m

R: [ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

iginale----- Da: Bruce Momjian [mailto:br...@momjian.us] Inviato: martedì 22 giugno 2010 18:48 A: Cassiano, Marco Cc: pgsql-admin@postgresql.org Oggetto: Re: [ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ? Cassiano, Marco wrote: > Hi all, > > > > it'

[ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

Hi all, it's my very first trial with pg_upgrade so I'm surely missing something I'm trying to launch pg_upgrade passing my super user name but pg_dumpall fails with a permission denied error I don't see the username in the pgdumpall callcould it be this the problem ? Thank you (

[ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

Hi all, it's my first trial with pg_upgrade so I'm surely missing something I'm trying to launch pg_upgrade passing my super user name but pg_dumpall fails with a permission denied error I don't see the username in the pgdumpall callcould it be this the problem ? Thank you (I hop

[ADMIN] Database in recovery mode forever

Hi all, this afternoon I had a database crash on a test system (The first Postgres crash in more than three years). I wasn't able to identify the reason.the log doesn't say anything interesting. Is there way the exactly identify the reason of the crash ? After having detected the crash, P

[ADMIN] PgAdmin : table backup problem

Hello everybody, I have a problem when I try to backup a table from inside PgAdmin. If I select a table and choose to backup it, I get the following result : C:\Programmi\pgAdmin III\1.6\pg_dump.exe -i -h pgsvil.manord.com -p 5432 -U user -F c -v -f "C:\collezioni.backup" -t collezioni -n anam

[ADMIN] Logfile permission

 Hi All,   By default Postgres creates its logfiles with rw user permission only (600). I would like to have rw permission also on the group to share via samba the log with the development team. Is there a way to modify the UMASK used by postmaster to create the logfiles ? Th