From: | Doug McNaught <doug(at)wireboard(dot)com> |
---|---|
To: | "Dan" <dan(at)bluecap(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: copy/backup database |
Date: | 2001-06-13 14:25:56 |
Message-ID: | m366e0pibv.fsf@belphigor.mcnaught.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Dan" <dan(at)NOSPAMbluecap(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Bartlett | 2001-06-13 14:27:55 | Re: Oracle news article |
Previous Message | Michael Meskes | 2001-06-13 14:16:28 | Re: Re: Does PostgreSQL support EXISTS? |