Re: copy/backup database

"Dan" <dan@NOSPAMbluecap.co.uk> writes:

> Hello,
>
> I have a pgsql database I want to make a copy of to do some test work on it.
> In /var/lib/psql/data/base I have made a copy of this directory with correct
> file permission etc but when I try to access the database it says it's not
> in the catalogue.  I guess there's obviously a procudure for this or a pgsql
> command but I dont know what.

Don't do it that way.

$ pg_dump original_db > dump.out
$ createdb test_db
$ psql -f dump.out test_db

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan