OK. I am lost now.
Introduction:
* postgres 7.4.5, Gentoo
Background:
* Server and laptop have identical configurations in every regard
(excepting that all software is built for their respective processor
types).
* the database is named 'orfs'
* I want a copy of it on my laptop.
* This t
If you just need a working copy, not necessarily right up to date at any
> time, you can just dump and restore it:
>
> pg_dumpall -h source_server |psql -h dest_server
>
> add switches as necessary.
That would be great for the first time. But what I want to do is copy
~postgresql/data, stomping/
On Sat, 2004-10-23 at 16:57, Curtis Zinzilieta wrote:
> rsync, or .tar.gz, or scp or use pg_dump.
>
> any of the copies run assuming you've shut down the DB first, and that
> you're using the same binaries on both boxen.
Aha! Shutdown first.
I knew it was something dumb.
Thanks for the help.
\<
On Sat, 2004-10-23 at 22:22, Karim Nassar wrote:
> If you just need a working copy, not necessarily right up to date at any
> > time, you can just dump and restore it:
> >
> > pg_dumpall -h source_server |psql -h dest_server
> >
> > add switches as necessary.
>
> That would be great for the firs
On Thu, 2004-10-21 at 02:39, Karim Nassar wrote:
> I need to have an exact copy of a postgres install on a testing
> computer. I don't want to do slony. Is it feasible/reasonable to think
> that I could just rsync to the devel boxen from the pg server? Or is
> slony "The Way to Do It"(tm)?
If you
On Thu, Oct 21, 2004 at 01:39:26 -0700,
Karim Nassar <[EMAIL PROTECTED]> wrote:
> I need to have an exact copy of a postgres install on a testing
> computer. I don't want to do slony. Is it feasible/reasonable to think
> that I could just rsync to the devel boxen from the pg server? Or is
> slony
I need to have an exact copy of a postgres install on a testing
computer. I don't want to do slony. Is it feasible/reasonable to think
that I could just rsync to the devel boxen from the pg server? Or is
slony "The Way to Do It"(tm)?
\<.
---(end of broadcast)-
