Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres database file location - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: postgres database file location
Date
Msg-id 20051129093505.GC31026@webserv.wug-glas.de
Whole thread Raw
In response to postgres database file location  (Ramon Orticio <rporticio@yahoo.com>)
List pgsql-novice
Tree view 
am  29.11.2005, um  0:46:08 -0800 mailte Ramon Orticio folgendes:
> dear friends,
>
> i created a bedrock sample database and put an
> employee table in it. i just can't find the file for
> the database so that i can transfer it to another
> computer.  where is the file of bedrock located?

Don't use filesystem-copy, better use pg_dump to dump the whole database
and psql or pg_restore to create and restore the database on the other
machine.

HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

Previous
From: Ramon Orticio
Date:
Subject: postgres database file location
Next
From: Oliver Elphick
Date:
Subject: Re: postgres database file location