copying a database

Dev Shed Forums Sponsor:

July 18th, 2003, 02:24 PM

spydrrr

Junior Member

Join Date: Jun 2003

Posts: 3

Time spent in forums: < 1 sec
Reputation Power: 0

copying a database

Is it possible to copy an entire PostgreSQL database from one computer to another? I don't want to sync them. I just want to make a different database with the info that's in the existing one.

I don't have access to the postgres user, I'm not the user who created the database, but I think I my PostgreSQLusername has superuser privileges.

July 21st, 2003, 12:07 PM

bcyde

Me likey breadsticks...

Join Date: Jan 2003

Location: Los Angeles

Posts: 1,189

Time spent in forums: 3 Days 1 h 12 m 58 sec
Reputation Power: 17

You can just dump the database using the pg_dump utility. Try searching google for that. Also if you use phppgadmin you should be able to dump the db structure and info from there.

If you have specific rules/triggers/constraints make sure those get exported as well.

HTH
-b

__________________
PostgreSQL, it's what's for dinner...

Viewing: Dev Shed Forums > Databases > PostgreSQL Help > copying a database

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump