RPM troubleshoot

Hey Ned,
One quick way to check if postgres is installed via rpm is from the
prompt type " rpm -qil postgres"
HTH,

Harry Hoffman
Product Systems Specialist
Restaurants Unlimited Inc.
206.634.3082 x. 270

On Sat, 20 May 2000, Ned Lilly wrote:

-------- Original Message --------
Date: Fri, 19 May 2000 23:19:25 PDT
From: "santosh behera" <santosh_behera@hotmail.com>
To: ned@greatbridge.com

Hi everybody,
Can any body help me is troubleshooting my PostgreSQL installation
!.when
giving rpms ---- postgr*.rpm it replies postgreSQL already installed.
No
daemon of postmaster is running.
Please help me how i can be sure if at all this is installed and start
a
session .

Hi. You might want to initialise the database. Prior to launching a
database server you'll need to initialise.

1) cd to /etc/rc.d/init.d
2) # ./postgresql start

This will su to postgres (the DBA account) and run initdb. After your
db is created (template1) you will want to su to root, then su - postgres
and run createuser. Create yourself as a user who can create other users
and dbs. Then create a new db for your use.

BTW, I cp'd /etc/rc.d/init.d/postgresql to /usr/local/bin and then I call
it from /etc/rc.d/rc.local so the db server fires up on boot.

Oh yeah, the redhatters saw fit to put a muzzle on the postmaster's logging
abilities. Edit the postgresql script. Where you see the call to the
postmaster, rm the -S (as in silent) and *make sure* you add an ampersand
to the call else it will run in the foreground (a boo boo if you call it
via rc.local).

For clarity's sake (not my strong point) here is my hack:

su -l postgres -c '/usr/bin/postmaster -i -D/var/lib/pgsql >>
/var/lib/pgsql/postlog 2>&1 &'

Mind you, I word wrapped here for legibility, but the above is all one
line.

Cheers,
T

---------------------------------------------------------------------------
North Richmond Community Mental Health Center
---------------------------------------------------------------------------
Thomas Good, MIS Coordinator tomg@ { admin | q8 } .nrnet.org
Phone: 718-354-5528
Fax: 718-354-5056
---------------------------------------------------------------------------
North Richmond Systems PostgreSQL s l a c k w a r e
Are Powered By: RDBMS |---------- linux
---------------------------------------------------------------------------

If you are trying to install the most recent version, you could try

rpm -Uvh ....

Depending on what distribution you are using and how it is configured,
Postgresql may be installed. However, on earlier version of RedHat (can't
quite remember which), although postgresql was installed, it took a bit of
tweaking the system startup scripts, environment variables, create the
user postgres, and run initdb to get it working. Some people found it
confusing. I talked to guy in town who said he was in a discussion on the
internet where the concluded the earlier RPMS were broken for
RedHat. They weren't, but the initialization process was confusing
people.

Conclusion: Even if postgresql is installed on your system from a
previous version, re-install it with the new rpms. It's easier to get
running, and works much better.

----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

On Sun, 21 May 2000, Travis Bauer wrote:

If you are trying to install the most recent version, you could try

rpm -Uvh ....

Conclusion: Even if postgresql is installed on your system from a
previous version, re-install it with the new rpms. It's easier to get
running, and works much better.

Re-install verse update (-U) I'm guessing. 'rpm -e postgres' then 'rpm
-Uvh postgres-xxxxx'. I got bit by the old RedHat postgres install once.
I haven't followed the PG7.0 RPM discussion too closely so didn't hear
if it was distribution specific or not. ???

Rod
--
Roderick A. Anderson
raanders@altoplanos.net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814