Re: moving from MySQL to pgsql

On 10/10/2012 04:47 PM, Vineet Deodhar wrote:

> 2) I run MySQL from a USB stick.
> There is no installation required (on WinXP.). (not tried on Ubuntu)
> Is it the same for pgsql?

On Windows PostgreSQL is usually installed as a system service with its
own user account (pre-9.2) or running in the network service account
(9.2+). This isn't strictly required, though.

You can keep the .zip binary releases on a USB key and use pg_ctl to
start/stop them from your own scripts. If you're bundling Pg in your
application this may be the best choice. See:

http://www.enterprisedb.com/products-services-training/pgbindownload

You *really* shouldn't keep the database its self on a USB key.
Performance is likely to be terrible, and many USB keys have quite short
write lifetimes so a database on a USB key can wear some of them out in
a real hurry.

Think about your backup process too. With PostgreSQL you have a couple
of options, including log archiving, periodic dumps, and warm standby.
Please read the backup chapter of the manual in detail.

--
Craig Ringer