Submitted by Snorkel (not verified) on Fri, 2008-02-15 06:08.
I have found that the dump restore for a major release is not that big of a deal as I generally have less databases with PGSQL vs MySQL, the reason being that PGSQL supports schemas. Now before you go off say that MySQL has schemas, they do sort of . In MySQL they implement schemas as seperate databases, on PGSQL a schema is a namespace in the same database,so it is like having multiple databases in one, so you end up with less physical databases.
I do wish however that the backup process was more server oriented instead of fat client oriented. It makes backing up from admin programs more difficult.
Ideally pg_dump should run on the server with a client API where you simply connect to the server and dump to your local PC if you want or just leave the backup on the server. The current implementation requires a separate pg_dump.exe for each version of the server you want to backup.
»
Reply
Search
Windows for Intel Macs
Todd Ogasawara's Windows for Intel Macs ($7.99USD published by O'Reilly Media) is for Intel Mac users running Bootcamp or Parallels who want to learn more about running Microsoft Windows XP on Mac. It also provides specific tips and hints for using Parallels Desktop for Mac.
I have found that the dump
I have found that the dump restore for a major release is not that big of a deal as I generally have less databases with PGSQL vs MySQL, the reason being that PGSQL supports schemas. Now before you go off say that MySQL has schemas, they do sort of . In MySQL they implement schemas as seperate databases, on PGSQL a schema is a namespace in the same database,so it is like having multiple databases in one, so you end up with less physical databases.
I do wish however that the backup process was more server oriented instead of fat client oriented. It makes backing up from admin programs more difficult.
Ideally pg_dump should run on the server with a client API where you simply connect to the server and dump to your local PC if you want or just leave the backup on the server. The current implementation requires a separate pg_dump.exe for each version of the server you want to backup.