am 06.06.2005, um 10:07:39 -0700 mailte operationsengineer1@yahoo.com folgendes:
> PGUSER=postgres
> PGPASSWORD=password
> export PGUSER PGPASSWORD
> pg_dump databasename | gzip > databasename.bak.gz
>
> my interfaces is cpanel and it only gives me one line
> to type this in... can i replace the returns with a
> space and will this still work?
>
> eg, PGUSER=postgres PGPASSWORD=password export...
>
> will databasename.bak.gz be stored in the same file as
> my database?
No, the database will be stored in 'databasename.bak.gz'.
>
> how can i store the file on my local computer?
Call pg_dump from your computer, but with -h - parameter.
> i finally have some data in my db and i scared of
> losing it. *real* scared!
?
I used today:
pg_dump -h 'old_server' -n 'schema' -U 'user' 'db' | psql -U 'user' 'new_deb'
(just as a brain-dump, no guarantee)
to transfer a Database from a old to a new Server.
Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
