Thread: RPM troubleshoot
Santosh, I'm forwarding your message to the PostgreSQL-GENERAL list.. -------- 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 . santosh behera India ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
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: > Santosh, I'm forwarding your message to the PostgreSQL-GENERAL list.. > > > -------- 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 . > > santosh behera > India > > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com >
> -------- 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 ---------------------------------------------------------------- > -------- 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 .
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