[ADMIN] archive_command

2009-09-01 Thread samana srikanth
can i change the archive_command from the postgres sql prompt ot sql command? Thanks Srikanth

Re: [ADMIN] archive_command

2009-09-01 Thread Abbas
On Tue, Sep 1, 2009 at 4:47 PM, samana srikanth samanasrika...@gmail.comwrote: can i change the archive_command from the postgres sql prompt ot sql command? Thanks Srikanth Nope, You can't change archive_command from psql prompt. Abbas

[ADMIN] purging debugger functions?

2009-09-01 Thread Jan-Peter Seifert
Hello, is there a proper way to remove the PostgreSQL debugger functions etc. from a database? It seems that the pgInstaller for Windows does/did install them by default. So during restore they cause error messages in servers without the debugging dll. It seems that the script pldbgapi.sql

[ADMIN] Snapshot and pg_hotbackup

2009-09-01 Thread Arnold, Sandra
Does anyone use OS snapshot as the file system backup solution in the pg_hotbackup instead of tar? Using tar for a small database is not a problem is when you have a database that will be close to a Terrabyte in size it can be a problem. I was wondering if changing the file system backup

Re: [ADMIN] Snapshot and pg_hotbackup

2009-09-01 Thread Kevin Grittner
Arnold, Sandra arno...@osti.gov wrote: Using tar for a small database is not a problem is when you have a database that will be close to a Terrabyte in size it can be a problem. I was wondering if changing the file system backup solution to a snapshot instead has been done. If snapshots