Re: [GENERAL] PostgreSQL (file based) database restore

2006-04-08 Thread Joshua D. Drake
Bit Byter wrote: I just did a file based database backup (stopped postmaster and zipped/copied all files under /usr/local/pgsql/data/* to a differnt location) How can I 'restore' the database and start using it? Assuming you are using linux/unix you can use pg_ctl (read the docs) to start the

Re: [GENERAL] PostgreSQL (file based) database restore

2006-04-08 Thread Leonel Nunez
Bit Byter wrote: I just did a file based database backup (stopped postmaster and zipped/copied all files under /usr/local/pgsql/data/* to a differnt location) How can I 'restore' the database and start using it? ---(end of broadcast)--- TIP 3: Ha

[GENERAL] PostgreSQL (file based) database restore

2006-04-08 Thread Bit Byter
I just did a file based database backup (stopped postmaster and zipped/copied all files under /usr/local/pgsql/data/* to a differnt location) How can I 'restore' the database and start using it? ---(end of broadcast)--- TIP 3: Have you checked our