[ADMIN] rename database

Hi : I am working on the procedure to restore a database from dump file ( pg_dump ). I am thinking to create a new database, then restore the dump file, drop the old database and rename the old database to new database. Do postgres has command to rename the database? ---

Re: [ADMIN] Vaccum

Szabo [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:40 AM To: bangh Cc: Leong, Fushan; [EMAIL PROTECTED] Subject: Re: [ADMIN] Vaccum On Thu, 29 Nov 2001, bangh wrote: > HI, > > This is not necessary true, but you might feel understandable. > > To delete records, just

Re: [ADMIN] Vaccum

: Thursday, November 29, 2001 10:01 AM To: Leong, Fushan Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Vaccum Hello, You can use vacuum at different levels. As a command you can use vacuumdb database_name. In psql, you can use psql> vacuum table_name; I don't think it is going to delete

[ADMIN] Vaccum

Hi : Want to get your opinion. I am thinking to schedule to run Vaccum everynight. 1) As I understand, Vaccum is the command to delete old data, right? 1) Do I have to stop the postmaster before run the Vaccum command? 2) Should I run it everynight? How often should I run it? thanks Fushan -

[ADMIN] how often should I run Vacuum

Hi : Want to get some idea about Vaccum function... How often would you suggest to run Vaccum command? Should I schedule to run in non-busy time like midnight? Vaccum all or Vacuum for each individual table Any tips for Vaccum? thanks Fushan ---(end of broadcast)---

Re: [ADMIN] backup file system

Francisco : Would you tell me what problem did you face when you try to restore the database from backup filesystem? Fushan -Original Message- From: Francisco Solari [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 5:41 AM To: Leong, Fushan Cc: '[EMAIL PROTECTED]