Portable PostgreSQL for development off a usb drive

postgresql portability usb-drive portable-database
Simurr picture Simurr · Jul 8, 2009 · Viewed 25.1k times · Source

In order to take some development work home I have to be able to run a PostgreSQL database.

I don't want to install anything on the machine at home. Everything should run off the usb drive.

What development tools do you carry on your USB drive?

That question covers pretty much everything else, but I have yet to find a guide to getting postgresql portable. It doesn't seem easy if it's even possible.

So how do I get PostgreSQL portable? Is it even possible?

EDIT:

PostgreSQL Portable works. It's very slow on the usb-drive I have, but it works. I can't recommend doing constant development with it but for what I need it's great.

Perhaps if I pick up a full speed external drive I'll try out virtualization. Given the poor performance of just running the database off this drive, a full virtual OS running off of it would be unusable.

Answer

Je Monly picture Je Monly · Nov 25, 2011

Here's how you can do this on your own: http://www.postgresonline.com/journal/archives/172-Starting-PostgreSQL-in-windows-without-install.html

Related questions

PostgreSQL: Show tables in PostgreSQL

What's the equivalent to show tables (from MySQL) in PostgreSQL?

Read More
PostgreSQL: How to change PostgreSQL user password?

How do I change the password for PostgreSQL user?

Read More
PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More