You need to use pg_dump.
pg_dump old_db_name > old.dump
Then send old.dump to the machine you want, and use commands on that
cat old.dump | psql new_db_name
Note: new_db_name can be the same as old_db_name here.
Todd Turner wrote:
> http://www.postgresql.org/doxlist.html noticed there isn't any info in
> copy the postgres data - database directory and files and setting up
> the same database on another machine. I've tried using createdb then
> pgaccess to import tables. Using psql the tables are found but the
> data isn't.
> When importing a table I'm getting the error Error executing query.
> Copy subreservation From "subreservation1'
> PostgresSQL error message:
> Error: CopyFrom: Fail to add null value in not null attribute username
> Also ERROR: Bad int8 external representation for another copy and
> somtimes I'm getting you can not copy a duplicate value into a
> duplicate key message.
> I'd appreciate if someone could turn me on to why I'm getting these
> messages and possibly how you can move a database to another machine.
> Todd Turner - tjturner(at)chpc(dot)utah(dot)edu
> (801 - 585-1266)
> Center for High Performance Computing
> University of Utah
In response to
pgsql-admin by date
|Next:||From: Todd J. Turner||Date: 2000-05-03 17:26:58|
|Subject: Re: database copy and move|
|Previous:||From: Todd Turner||Date: 2000-05-03 16:32:57|
|Subject: database copy and move|