How to make testing environment about Postgres.

Ayumi

16 years ago

I often use postgres server,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.

# pg_dump -f filename.sql.gz -Z 1 -c database-name

1	# pg_dump -f filename.sql.gz -Z 1 -c database-name

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

Second Step

You get dump file from server.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.

Program FilesPostgresSQL8.3bin

1	Program FilesPostgresSQL8.3bin

And please open command prompt and write this command.

cd Program FilesPostgresSQL8.3bin
psql dbname 
That's all!!! 

And if you see these message.Please make user on for postgres.
psql: FATAL: role "&#65381;&#35695;&#65404;&#65381;&#65398;&#65420;&#65406;" does not exist&#65380;&#65416;&#65400;&#65408;&#65380;??&#65407;&#65380;&#39237;r

Or

please change user what this user is postgres user.
<pre>psql -u

cd Program FilesPostgresSQL8.3bin

psql dbname

That's all!!!

And if you see these message.Please make user on for postgres.

psql: FATAL: role "･譯ｼ･ｶﾌｾ" does not exist､ﾈｸﾀ､??ｿ､饅r

please change user what this user is postgres user.

<pre>psql -u