Thread: postgres database file location
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? thanks for any help raport __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
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 ===
On Tue, 2005-11-29 at 00:46 -0800, Ramon Orticio wrote: > 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? You cannot transfer the file or database directory alone and expect to be able to recover data from it; there are global files involved as well. To transfer data to another computer you should use pg_dump to dump the database or table and then you should import the dump file on the other machine. -- Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== Do you want to know God? http://www.lfix.co.uk/knowing_god.html
the file doesn't exist because you haven't created it yet! Oliver is right, use pgdump - it is pretty straight forward and well documented on the pgsql website. pgadmin3 adds a gui to this process and makes it a point and click proposition. --- Ramon Orticio <rporticio@yahoo.com> wrote: > 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? > > thanks for any help > > raport > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > __________________________________ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/