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 7D9DAD1D091 for ; Fri, 7 May 2004 09:30:43 -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 49307-04 for ; Fri, 7 May 2004 09:30:24 -0300 (ADT) Received: from mxc.pcnet.ro (unknown [82.137.14.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6DE30D1E8C7 for ; Fri, 7 May 2004 09:30:20 -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 i47CPTTs015170 for ; Fri, 7 May 2004 15:25:29 +0300 Received: from aldratech.com ([192.168.0.6]) by aldratech.com for with eXtremail; Fri, 7 May 2004 15:30:21 +3GMT Message-ID: <409B815C.6010408@aldratech.com> Date: Fri, 07 May 2004 15:30:20 +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: Postgres-Admin list Subject: Re: problem trying to su - postgres References: <9D9DF263C303D411B419009027F65CC20206FFAA@SDC-MAIL> In-Reply-To: <9D9DF263C303D411B419009027F65CC20206FFAA@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/68 X-Sequence-Number: 13384 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Neil.Thompson@shepway.gov.uk wrote: | many thanks | | For info I've installed it all from cd. | | I tried the whoami, and although the command prompt thing says -bash-2.05b$ | it did return postgres as the user, THANKS! | | also tried the rpm -qa | grep postgres, this returned: | postgresql-libs-7.3.4-3.rhl9 | postgresql-7.3.4-3.rhl9 | postgresql-server-7.3.4-3.rhl9 | | so I guess I'm worrying over nothing, sorry. When you are learning you hope | to see exactly whats written in the install docs. At least I now know how to | check. | Yes, you were :-) but hey that's how it goes. Although I think you were reading the install from source docs. Better off checking the RPM part and the docs from the RPM distribution (postgresql-doc I think). Also you may whish to install postgresql-devel and/or other devel packages to be able to use it with python/php/perl/etc. | Thank You | Cheers | Neil Thompson | | -----Original Message----- | From: Radu-Adrian Popescu [mailto:radu.popescu@aldratech.com] | Sent: 07 May 2004 10:30 | To: Neil.Thompson@shepway.gov.uk | Cc: pgsql-admin@postgresql.org | Subject: Re: [ADMIN] problem trying to su - postgres | | | 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 - -- 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 iD8DBQFAm4FcVZmwYru5w6ERAhUoAJ94w4ZmFmJUhcSJydSUxdn/VfJwjQCdEE/4 EW9lcGQ0CpQmfr3SE0+hOXE= =l1AO -----END PGP SIGNATURE-----