2009 March

How to make testing environment about Postgres.

Mar 31, 2009

AD:

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.

postgres

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

1

2

3

4

5

6

7

8

9

10

11

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

Or

please change user what this user is postgres user.

<pre>psql -u

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.

Mar 31, 2009

AD:

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

 $array = array(
	1
	,2
	,3
	,4 =&gt; array(
		5
		,6
	)
);
$result = print_r($array, true);
echo $result;

1

2

3

4

5

6

7

8

9

10

11

$array = array(

1

,2

,3

,4 => array(

5

,6

)

);

$result = print_r($array, true);

echo $result;

Display

Array ( [0] =&gt; 1 [1] =&gt; 2 [2] =&gt; 3 [4] =&gt; Array ( [0] =&gt; 5 [1] =&gt; 6 ) )

1	Array ( [0] => 1 [1] => 2 [2] => 3 [4] => Array ( [0] => 5 [1] => 6 ) )

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.

Mar 20, 2009

AD:

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

Area 42 speech contests. 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.

Mar 10, 2009

AD:

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 install Fedora 10 in my server.

Mar 4, 2009

AD:

fedora10

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

[root@hoge ~]# /etc/rc.d/init.d/iptables stop 
<span>It stop auto run ipdatble.</span>
[root@hoge ~]# chkconfig iptables off
<span>It checks stopping auto run ipdatble.</span>
[root@hoge ~]# chkconfig --list iptables
iptables        0:off   1:off   2:off   3:off   4:off   5:off   6:off

1

2

3

4

5

6

[root@hoge ~]# /etc/rc.d/init.d/iptables stop

It stop auto run ipdatble.

[root@hoge ~]# chkconfig iptables off

It checks stopping auto run ipdatble.

[root@hoge ~]# chkconfig --list iptables

iptables 0:off 1:off 2:off 3:off 4:off 5:off 6:off

About SELinux

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

[root@hoge ~]# getenforce
<span>It means running SELinux.</span>
Enforcing
<span>Stops SELinux.</span>
[root@hoge ~]# setenforce 0
[root@hoge ~]# getenforce
<span>It means not running SELinux.</span>
Permissive

1

2

3

4

5

6

7

8

[root@hoge ~]# getenforce

It means running SELinux.

Enforcing

Stops SELinux.

[root@hoge ~]# setenforce 0

[root@hoge ~]# getenforce

It means not running SELinux.

Permissive

[root@hoge ~]# vi /etc/sysconfig/selinux
SELINUX=enforcing
SELINUX=disabled

1

2

3

[root@hoge ~]# vi /etc/sysconfig/selinux

SELINUX=enforcing

SELINUX=disabled

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 got Eiken Grade 2 !!

Mar 3, 2009

AD:

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.

I went to The STIRReRS Live!!

Mar 1, 2009

AD:

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

How to make testing environment about Postgres.

First Step

Second Step

Third Step

Fourth Step

How to show array to character string.

｣ﾉ joined Osaka ToastMaster club.

I’m looking for my job in Sydney.

Date Base

Programming

Framework for PHP

OS

I install Fedora 10 in my server.

About Firewall

About SELinux

For Japanese setting

I got Eiken Grade 2 !!

I went to The STIRReRS Live!!

Search Keyword

Meta

FacebookPage

Popular Posts

My Tags

Status

Links

ARCHIVES