[ADMIN] Cleaning up directory pgsql_tmp ?

2007-03-05 Thread David Levy
Hi, I have a 7Go pgsql_tmp directory in my main tablespace which remains even after a cluster restart. Does anyone know how to clean up properly ? Can i just delete the directory in the filesystem (with the cluster up or down ?) ? The documentation says it should be handled automatically by the

[ADMIN] pg_restore index/trigger restoration issue

2006-04-27 Thread David Levy
or pg_restore to handle this ?RegardsThanks in advance David LEVY

[ADMIN] pg_restore index/trigger restoration issue

2006-04-27 Thread David Levy
or pg_restore to handle this ?RegardsThanks in advance David LEVY

Re: [ADMIN] pg_restore index/trigger restoration issue

2006-04-27 Thread David Levy
] wrote: David Levy [EMAIL PROTECTED] writes: So I am trying to restore a pg_dump (version8.1 ) sql dump file from a remote 8.0.3 DB into a local 8.1 DB using pg_restore (version 8.1). Is there something incompatible The dump file seems to be correct regarding index creation statements I really don't