Re: postgres database file location

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
Thread:
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 ===

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2005-11-29 09:41:36 Re: postgres database file location
Previous Message Ramon Orticio 2005-11-29 08:46:08 postgres database file location