X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 89F55D1B53B for ; Fri, 7 May 2004 06:30:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 90428-02 for ; Fri, 7 May 2004 06:29:54 -0300 (ADT) Received: from mxc.pcnet.ro (unknown [82.137.14.2]) by svr1.postgresql.org (Postfix) with ESMTP id BC252D1B44F for ; Fri, 7 May 2004 06:29:50 -0300 (ADT) Received: from aldratech.com (aldratech.com.pcnet.ro [213.154.158.58] (may be forged)) by mxc.pcnet.ro (8.12.10/8.12.10) with ESMTP id i479P0eW006829 for ; Fri, 7 May 2004 12:25:00 +0300 Received: from aldratech.com ([192.168.0.6]) by aldratech.com for with eXtremail; Fri, 7 May 2004 12:29:51 +3GMT Message-ID: <409B570F.3010806@aldratech.com> Date: Fri, 07 May 2004 12:29:51 +0300 From: Radu-Adrian Popescu Reply-To: radu.popescu@aldratech.com Organization: Aldratech Ltd. User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.6) Gecko/20040124 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Neil.Thompson@shepway.gov.uk Cc: pgsql-admin@postgresql.org Subject: Re: problem trying to su - postgres References: <9D9DF263C303D411B419009027F65CC20206FFA8@SDC-MAIL> In-Reply-To: <9D9DF263C303D411B419009027F65CC20206FFA8@SDC-MAIL> X-Enigmail-Version: 0.83.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=2.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: ** X-Archive-Number: 200405/66 X-Sequence-Number: 13382 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Neil.Thompson@shepway.gov.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@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@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@rpopescu postgres]$ whoami postgres [root@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-----