Thread: RPM troubleshoot

RPM troubleshoot

From
Ned Lilly
Date:
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

Re: RPM troubleshoot

From
moebius@ip-solutions.net
Date:
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
>


Re: RPM troubleshoot

From
Thomas Good
Date:
> -------- 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
---------------------------------------------------------------------------



Re: RPM troubleshoot

From
Travis Bauer
Date:
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 .


Re: RPM troubleshoot

From
"Roderick A. Anderson"
Date:
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