[ADMIN] Postgresql scheme standards tool

2011-12-14 Thread Robert Matthew Cook
Is anyone aware of tools which can be used to enforce or test schema standards on PostgreSQL 9.0? Examples being something like: 1) Fail/rollback DDL attempting to create a table in the public schema 2) Create a scheduled process which raises alerts for columns of datatype XML Thanks, Robert

[ADMIN] Resume Incomplete Pg-restore

2011-12-14 Thread P R
Is there any way to resume an incomplete Pg-restore from a custom Pgdump file?

Re: [ADMIN] Resume Incomplete Pg-restore

2011-12-14 Thread Craig Ringer
On 12/15/2011 02:52 AM, P R wrote: Is there any way to resume an incomplete Pg-restore from a custom Pgdump file? Not reliably. If you know it failed or stopped at a particular defined point, you might be able to selectively restore table-by-table from there, but that won't work if you have