Обсуждение: database copy and move

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

PostgresSQL
status:PGRES_FATAL_ERR
OR

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.

tjt:

-- 
===========================================
Todd Turner - tjturner@chpc.utah.edu
(801 - 585-1266)
Center for High Performance Computing
University of Utah
===========================================

pg_dump old_db_name > old.dump

Then send old.dump to the machine you want, and use commands on that machine:
createDB new_db_name
cat old.dump | psql new_db_name

Note: new_db_name can be the same as old_db_name here.

--
Banghe

Todd Turner wrote:

Hello;

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

PostgresSQL
status:PGRES_FATAL_ERR
OR

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.

tjt:

-- 
===========================================
Todd Turner - tjturner@chpc.utah.edu
(801 - 585-1266)
Center for High Performance Computing
University of Utah
===========================================

 

Thanks much for the quick info that's what I needed.

tjt:

====================================================
Todd Turner
tjturner@chpc.utah.edu
801-585-1266
Center for High Performance Computing
University of Utah
====================================================

On Wed, 3 May 2000, bangh wrote:

> 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
> machine:
> createDB new_db_name
> cat old.dump | psql new_db_name
>
> Note: new_db_name can be the same as old_db_name here.
>
> --
> Banghe
>
> Todd Turner wrote:
>
> > Hello;
> >
> > 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
> >
> > PostgresSQL
> > status:PGRES_FATAL_ERR
> > OR
> >
> > 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.
> >
> > tjt:
> >
> > --
> > ===========================================
> > Todd Turner - tjturner@chpc.utah.edu
> > (801 - 585-1266)
> > Center for High Performance Computing
> > University of Utah
> > ===========================================
> >
> >
>