By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,176 Members | 984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,176 IT Pros & Developers. It's quick & easy.

Any equivalent of MSSQL Detach?

P: n/a
I am wondering if it is possible to pick up a database from one computer and
move it over to another and then just plug it back in.

It appears that a database is stored inside of a directory that is named
after the db's OID. The directory contains what I am guessing are
individual files that are also named after various OIDs.

Can such things be picked up the way you would pick up a Microsoft database?

--
Kenneth Downs
Use first initial plus last name at last name plus literal "fam.net" to
email me
Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Kenneth Downs <fi****************@lastnameplusfam.net> writes:
I am wondering if it is possible to pick up a database from one computer and
move it over to another and then just plug it back in.


No, unless you do the whole database cluster, and the two machines are
the same architecture and have the same version of PG, compiled the
same way. Basically there are a lot of interdependencies between
different parts of the database cluster, so you can't just grab a
single database and copy it over.

pg_dump is the way to go...

P.S. I'm replying to the list only because I can't be bothered to
demangle your address. If you don't get the reply, tough toenails.

-Doug

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.