How to make testing environment about Postgres.

Mar 31, 2009

I often use postgres ,so sometimes I have to make testing environment for postgres in my windows pc.
So I want to write how to make testing environment about Postgres for my memo.


First Step

Please login postgres server, and then you have to change user what this user is postgres user.
And I use pg_dump.

-f to write file about output.
-Z。。Number this is level of compression.
-c is cleaning for schema.

Second Step

You get dump file from .And then you decompress file.

Third Step

You install postgres in your windows PC. Please check Postgres sites.

Fourth Step

Please copy dump file to there.

And please open prompt and write this command.

Related posts


No Comments, Comment or Ping

Reply to “How to make testing environment about Postgres.”

You must be logged in to post a comment.

Search Keyword


face Ayumi Mizoshiri
WEB developer


Popular Posts

Sorry. No data so far.