Re: [GENERAL] Cloning database without dump/restore

2010-11-05 Thread Andreas Schmitz
snapshot might be the keyword you're looking for. regards andreas On 11/05/2010 09:06 AM, Andrus wrote: Only port 5432 is opened in server. Database can cloned using pg_dup / pg_restore If server is located in internet this requires huge amount of time and bandwidth. How to clone

Re: [GENERAL] Too much logging

2010-08-27 Thread Andreas Schmitz
http://www.postgresql.org/docs/8.4/interactive/runtime-config-logging.html#GUC-LOG-STATEMENT [...] Valid values are none, ddl, mod, and all. regards andreas On 08/27/2010 03:01 PM, Richard Harley wrote: Won't log state = all catch everything? Richard On 27/08/10 10:39, Mike

Re: [GENERAL] cleaning wal files from postgres

2010-05-21 Thread Andreas Schmitz
erobles wrote: which is the right procedure to clean wal files after a recovery ?? which kind of recovery ? PITR or just a crash ? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] cleaning wal files from postgres

2010-05-21 Thread Andreas Schmitz
erobles wrote: which is the right procedure to clean wal files after a recovery ?? what kind of recovery ? regards andreas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] cleaning wal files from postgres

2010-05-21 Thread Andreas Schmitz
maybe I don't understand the problem. there is no need to clean WAL files after recovery. where exactly is the problem ? regards andreas erobles wrote: PITR recovery On 05/21/2010 03:04 PM, Andreas Schmitz wrote: erobles wrote: which is the right procedure to clean wal files after