| Lists: | pgsql-novice |
|---|
| From: | Ramon Orticio <rporticio(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | postgres database file location |
| Date: | 2005-11-29 08:46:08 |
| Message-ID: | 20051129084609.25677.qmail@web54007.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
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
| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: postgres database file location |
| Date: | 2005-11-29 09:35:07 |
| Message-ID: | 20051129093505.GC31026@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
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 ===
| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | Ramon Orticio <rporticio(at)yahoo(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: postgres database file location |
| Date: | 2005-11-29 09:41:36 |
| Message-ID: | 1133257296.10517.25.camel@linda.lfix.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
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(at)lfix(dot)co(dot)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
| From: | <operationsengineer1(at)yahoo(dot)com> |
|---|---|
| To: | Ramon Orticio <rporticio(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: postgres database file location |
| Date: | 2005-11-29 18:19:06 |
| Message-ID: | 20051129181906.77743.qmail@web33303.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
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(at)yahoo(dot)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/