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

Re: problem trying to su - postgres

From: Radu-Adrian Popescu <radu(dot)popescu(at)aldratech(dot)com>
To: Neil(dot)Thompson(at)shepway(dot)gov(dot)uk
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: problem trying to su - postgres
Date: 2004-05-07 09:29:51
Message-ID: 409B570F.3010806@aldratech.com (view raw or flat)
Thread:
Lists: pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Neil(dot)Thompson(at)shepway(dot)gov(dot)uk wrote:
| I'm a newbie to all things linux and have the following problem
|
| running red hat linux 9 i log into my pc, change to su - and type the
| password, all is ok and i get root(at)localhost <mailto:root(at)localhost>
|
| I'm trying now to configure postgresql, which i installed with linux and
| it says to su - postgres, i do this but instead of getting
| postgres(at)localhost <mailto:postgres(at)localhost> i get -bash-2.05b$ , is
| this right? or do i need to reinstall something / update something?
|

It is correct. You can also do a "whoami":
[postgres(at)rpopescu postgres]$ whoami
postgres
[root(at)rpopescu root]# whoami
root
The prompt setting may be different on you machine.

| Using the graphical interface i've tried to add postgres as a user as it
| doesnt show, but it says user postgres already exists.
|

You don't specify how you've installed postgresql. On redhats you can get it
from the installation disks. It's an older version that the current, obviously,
but it looks like you're trying to get started with it, and therefore it should
do. So your best bet is to try to install it from the RPMs, since it's easier
than compiling it from source (not that that would be a killer or anything, but
not something a newbie should be doing from day one imho).
So step back, take a deep breath, run as root
rpm -qa | grep postgres
and if that comes up with 3-5 packages, you're almost done. If not, mount the
cdroms and install postgresql from there (rpm -i postgresql-*.rpm).
Have you checked the docs on the main website yet ?

| An help would be greatfully received.
|
| Thanks
|
| *Neil Thompson
| Analyst/Programmer*
|

Regards and best of luck,
- --
Radu-Adrian Popescu
CSA, DBA, Developer
Aldratech Ltd.
+40213212243
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFAm1cOVZmwYru5w6ERArMqAKCRSvTWz6XeGANKO8qvPZZa4inUqQCghymQ
r17GzWFa/dmtpRjtzfn80r4=
=uibD
-----END PGP SIGNATURE-----


In response to

pgsql-admin by date

Next:From: Karel ZakDate: 2004-05-07 10:09:15
Subject: Re: problem trying to su - postgres
Previous:From: Neil.ThompsonDate: 2004-05-07 08:54:42
Subject: problem trying to su - postgres

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