How to install PostgreSQL Database Server on Fedora

Posted On February 10, 2010

Filed under 1

Comments Dropped leave a response


Install Django

Download the python:

http://www.python.org/ or add/remove software

Download the Django:
http://www.djangoproject.com/download/
tar xzvf Django-1.1.tar.gz
cd Django-1.1.1
sudo python setup.py install

Install postgresql and postgresql-server packages:

$ yum install postgresql postgresql-server python-psycopg2

Configure PostgresSQL:

edit: /var/lib/pgsql/data/postgresql.conf

Uncomment this two line:

listen_addressses = ‘ ‘

port = 5432

or

listen_addresses=’localhost’

Start  PostgreSQL Server:

service postgresql start  OR /etc/init.d/postgresql start

Configuring Postgresql

Setting up Postgres Users

Changing the postgres users database password:

su postgres

psql template1

template1=# ALTER USER postgres WITH PASSWORD ‘password’;

template1=\q

Where “password” is the new password.

Changing the postgres user OS password:

sudo passwd -d postgres

sudo su postgres -c passwd

Setting up Postgres Users

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s