469,903 Members | 2,329 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

Exporting/moving Postgress Instance

Hi,

I'm relatively new to postgres but I've managed to get an instance up and
running and built a web site based on it. But I want to move the complete
site to another host not in the same network. If I want to set the schema up
on a new machine is it sufficient to simply copy the data folder (and sub
folders) and then start the instance by pointing to that data folder?
Otherwise is there an recognised dump file in the same way that Oracle has
and if so how do I create it?

Thanks

Nick
Nov 23 '05 #1
3 1371
Nick schrieb:
Otherwise is there an recognised dump file in the same way that Oracle has
and if so how do I create it?


Hi Nick,

you should look at

pg_dump or pg_dumpall in the docs.

(or pg_dump --help)

restore the dumped database with psql.

Daniel
Nov 23 '05 #2

Hi Nick,

you should look at

pg_dump or pg_dumpall in the docs.

(or pg_dump --help)

restore the dumped database with psql.

Daniel


Thanks, it worked to export the data. I'll have to see how it goes with the
import.

Nick
Nov 23 '05 #3
>

Thanks, it worked to export the data. I'll have to see how it goes with the
import.

Nick

Above two samples. Notice that I use commandline param1 (%1) to specify
the host and param2 (%2) to specify the database name. I also never
export with blobs because i want to have a dumpfile for each table. I
export as INSERTS WITH COLUMN NAMES because my databases could have
different version with different column orders.

sample for export :

Table - export

pg_dump -i -h %1 -a -D -U syncro -S syncro -t fieldalias -f
"E:\Setup\P32\PSql\binary\ZZ_13 fielalias.sql" %2

BLOB - export

psql -h %1 -U syncro -c "SELECT lo_export(mm_picture,
'../mainmenu.mm_id.'|| CAST(mm_id AS VARCHAR) || '.blob') FROM mainmenu
WHERE mm_picture IS NOT NULL" %2
sample for import :

Table - import

psql -h %1 -f "%P32PATH%\PSql\binary\ZZ_12 sondfunc.sql" %2 syncro

BLOB - import

psql -h %1 -c "UPDATE mainmenu SET
mm_picture=lo_import('../mainmenu.mm_id.'|| CAST(mm_id AS VARCHAR) ||
'.blob') WHERE mm_picture IS NOT NULL" %2 syncro
Daniel
Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Liza | last post: by
6 posts views Thread by Hemant Shah | last post: by
67 posts views Thread by Bob Powell | last post: by
1 post views Thread by Praveen | last post: by
224 posts views Thread by Jon Slaughter | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.