The pg_dump command does not work properly on my data because I have \'s
in it.
Therefore, to back up my database, I was thinking of doing the
following:
mv $PGDATA/base/ /
Would it work if I then move back to $PGDATA/base ? Or are
there dependencies that could affect this?
-
If you can access postgres on the second machine from the first (ie on
machine a you can type "psql -h b database" and properly issue queries)
you can just do the following from machine a
pg_dump database | psql -h b database
Chris
On Fri, 10 Jul 1998, Maarten Boekhold wrote:
> On Thu, 9 Jul 1
On Thu, 9 Jul 1998, Jeffrey Napolitano wrote:
> I have two Postgresql databases - one on machine a, one on machine b.
> Both are currently running. I want to put a copy of the database on a
> onto machine b. I know I have to stop the postmaster (obviously) on
> database b, but what else is the
