Skip site navigation (1) Skip section navigation (2)

Re: upgrade from 6.4 to 7.02 problem

From: Thomas Swan <tswan(at)olemiss(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: upgrade from 6.4 to 7.02 problem
Date: 2000-07-27 20:19:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
>  $ rpm -i --force postgrerpm7.02

Not to sound rough, but if this is a new installation of RH6.0 you really 
wouldn't to be doing a --force option on the install.

Traditionally you would want to do

rpm -Uvh {the postgresql packages you want to install}

The data directory by default is /var/lib/pgsql.

Aside from that...

As root su to postgres
$ su - postgres
then run initdb

If initdb cannot find the database location it will ask you where the 
folders are.

If you change the default data directory you will need to inform postgres 
as to where the new location is by commandline or by editing the 
postmaster.opts file.

to connect to the db you can connect by doing
psql template1 postgres

where template1 is the first database created by initdb. and postgres is 
the user you are connecting as.

By default you cannot connect as root.

I hope this helps


- Thomas Swan
- Graduate Student  - Computer Science
- The University of Mississippi
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."

pgsql-novice by date

Next:From: Chris JonesDate: 2000-07-27 23:59:00
Subject: Re: 4 billion record limit?
Previous:From: Bruce MomjianDate: 2000-07-27 19:21:37
Subject: Re: 4 billion record limit?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group