Wednesday, August 24, 2005

Getting started with Postgresql 8.0.3

from http://robinbowes.com/article.php/20050628195431479

Install postgresql using yum:

# yum install postgresql postgresql-server postgresql-devel php-pgsql

Modify /etc/init.d/postgresql to use /home/postgres for the databases and to log to /var/log/postgres

# vi /etc/init.d/postgresql

#PGDATA=/var/lib/pgsql
#if [ -f "$PGDATA/PG_VERSION" ] && [ -d "$PGDATA/base/template1" ]
#then
# echo "Using old-style directory structure"
#else
# PGDATA=/var/lib/pgsql/data
#fi
#PGLOG=${PGDATA}/pgstartup.log
PGDATA=/home/postgres/data
PGLOG=/var/log/postgres/pgstartup.log

Create the data and log dir and set ownership:

# mkdir /home/postgres /var/log/postgres
# chown postgres:postgres /home/postgres /var/log/postgres

Start up postgresql

# service postgresql start

Change the superuser password:

# su - postgres

# psql -d template1 -U postgres -c "alter user postgres with password 'newpassword'"

Now modify pg_hba.conf (/var/lib/pgsql/data/pg_hba.conf):

# "local" is for Unix domain socket connections only
local all all md5
# IPv4 TCP/IP connections
host all all 127.0.0.1/32 md5

This allows access using the local unix socket or local tcp/ip connection but only for postgresql users.

Restart postgresql: service postgresql restart

8 Comments:

At 1:04 PM, Blogger shawnmorgan26863833 said...

i thought your blog was cool and i think you may like this cool Website. now just Click Here

 
At 9:34 PM, Blogger Orendon said...

WOW! What a great site you have here, LJ Regalado. I found is from my search for lead generation. In my opinion., is a cut above the others. Even though my research regarding Getting started with Postgresql 8.0.3 lead me here but match is not exact for Getting started with Postgresql 8.0.3, the content is very beneficial and rewarding. Thank you for reading my comment here.

 
At 3:39 PM, Blogger Orendon said...

WOW! What a great site you have here, LJ Regalado. I found is from my search for leads. In my opinion., is a cut above the others. Even though my research regarding Getting started with Postgresql 8.0.3 lead me here but match is not exact for Getting started with Postgresql 8.0.3, the content is very beneficial and rewarding. Thank you for reading my comment here.

 
At 1:29 PM, Blogger Cell Phone Princess said...

Hi LJ Regalado

Getting started with Postgresql 8.0.3 ? mmmm....

Later,

streaming video help

 
At 7:42 PM, Blogger mikeericks87239345 said...

Do you want free porn? Contact my AIM SN 'abunnyinpink' just say 'give me some pics now!'.

No age verification required, totally free! Just send an instant message to AIM screen name "abunnyinpink".

Any message you send is fine!

AIM abuse can be reported here.

 
At 9:33 PM, Blogger louisflynn8968077427 said...

Get any Desired College Degree, In less then 2 weeks.

Call this number now 24 hours a day 7 days a week (413) 208-3069

Get these Degrees NOW!!!

"BA", "BSc", "MA", "MSc", "MBA", "PHD",

Get everything within 2 weeks.
100% verifiable, this is a real deal

Act now you owe it to your future.

(413) 208-3069 call now 24 hours a day, 7 days a week.

 
At 5:16 AM, Blogger barb michelen said...

Hello I just entered before I have to leave to the airport, it's been very nice to meet you, if you want here is the site I told you about where I type some stuff and make good money (I work from home): here it is

 
At 8:40 AM, Blogger barb michelen said...

Hello I just entered before I have to leave to the airport, it's been very nice to meet you, if you want here is the site I told you about where I type some stuff and make good money (I work from home): here it is

 

Post a Comment

<< Home