X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A0EF653351 for ; Mon, 18 Apr 2005 16:02:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39276-10 for ; Mon, 18 Apr 2005 19:02:06 +0000 (GMT) Received: from web50904.mail.yahoo.com (web50904.mail.yahoo.com [206.190.38.124]) by svr1.postgresql.org (Postfix) with SMTP id DF78D5334B for ; Mon, 18 Apr 2005 16:02:04 -0300 (ADT) Received: (qmail 44346 invoked by uid 60001); 18 Apr 2005 19:02:05 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=wYtUCyzY3hI2LEwT75rg3JAQPispEN4U/Kg514ZijBeE9FyllSFtS1xq8dN3lyP6aJ7MhzBIW3KFJgeD/2kAB9hoeViQSLknQQP/D5H685+MKkhC+K21eloh+aw2Ur+0KpBnTAJdkFc5eJC4dHPqmpi3+dVDD5Ru43IS/21O6+c= ; Message-ID: <20050418190205.44344.qmail@web50904.mail.yahoo.com> Received: from [139.141.101.131] by web50904.mail.yahoo.com via HTTP; Mon, 18 Apr 2005 20:02:05 BST Date: Mon, 18 Apr 2005 20:02:05 +0100 (BST) From: Al-Amin Ali Subject: Missing commands To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.251 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS, FROM_HAS_ULINE_NUMS X-Spam-Level: * X-Archive-Number: 200504/251 X-Sequence-Number: 17264 Hi I am new to Postgres I have installed it so that I can use agent academy software. anyway when I try to run agent academy it gives us some errors or complains one of these complains is Password in file is not proper scrambled now the only place where we use a password is in Postgres for the user. agent academy and postgres reside on the same machine. which is Mandrake 9.2. I use Postgres 7.3.4 which comes prepackaged in Mandrake installation Cds. After installation I used the following steps to create a user and database: 1. [vsbabu@toshiba vsbabu]$ su – root 2. password: 3. [root@toshiba root]# /etc/rc.d/init.d/postgresql restart 4. [ OK ] 5. Starting postgresql service: [ OK ] 6. [root@toshiba root]# su - postgres 7. -bash-2.05b$ createuser vsbabu 8. Shall the new user be allowed to create databases? (y/n)y 9. Shall the new user be allowed to create more new users? (y/n)y 10. CREATE USER 11. -bash-2.05b$ createdb vsbabu 12. CREATE DATABASE 13. -bash-2.05b$ exit 14. [root@toshiba root]# exit Now up to this point every thing was working fine. But it seems that there is some commands that are not there. every time I try to use: pg_passwd or alter user I get the following message: command not found I tried to use these commands at command prompt as a "root" and as "su - postgres" in both cases command not found. I searched Mandrake prepackaged software for any missed libraries there is none. I do not know if Postgres comes in a limited version you know with mandrake installation Cds. Any idea help please thank you Send instant messages to your online friends http://uk.messenger.yahoo.com