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.

-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.

And please open command prompt and write this command.

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

How to show array to character string.
$array is associative array.

Display

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

｣ﾉ joined Osaka ToastMaster club.｡｡｡｡｡｡｡｡
It is wonderful club. I got many good experience. Also the members are so kind and they have a humor and they are so nice people. I really appreciate that they are always welcome to me.｡｡If you want to learn speech in English. You should come here definitely.

Osaka ToastMaster club.

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

I’m looking for my job in Sydney. Because I will live in Sydney on this summer.
And my fiancee is Australian so we will live in Sydney.

I am the manager of systems.
At present, my job is managing our servers (about 20 servers in total).
And I make CMS & portal sites. I also make programming documents.
My IT skills:
｡ｦI can manage Linux and Unix servers.
｡ｦI can use PHP, Javascript, html, css.
｡ｦI can use Photoshop,Illustrater,.Flash,Premia.
｡ｦI can manage and design web sites & systems.

So I checked about my job’s keywords in SEEK.

Date Base

Oracle	1854
Mysql	348
DB2	191
SQLServer	21
Postgres	12

Programming

.NET	1467
Java	1331
PHP	965
Javascript	804
Ajax	430
Perl	279
Python	113
Ruby	67

Framework for PHP

PHP Zend Framework	94
PHP CakePHP	20
PHP symfony	5

OS

Linux	1065
Windows	2316

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

I installed Fedora 10 in my server.
This server is for my local programming so you should not use for server.

About Firewall

I stop｡｡Firewall

About SELinux

I don’t like SELinux so I often stop using SELinux.

For Japanese setting

[root@hoge ~]# yum -y install nkf

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

I took Eiken Grade 2 on 25th January.
And then I had an interview on 22th February.
It was not difficult for me but if I have not met Sally, I can not get Eiken Grade 2.
Thank you for supporting me.

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

I went to The STIRReRS Live on 28/2 in Rock Riders!!

I really enjoyed this live.
I think The STIRReRS is real rock musician in Osaka.
I live their music sounds and I like their style because Vocalist looks so happy!!
I think it is important because audience feels their mind. So I felt happy ,he made me happy.

I bought their CD.
Please check it.

I found their information.
Here is Home Page.
Here is The STIRReRS in My space.

Here is Youtube.

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0