Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 4AD081337BB7 for ; Thu, 7 Apr 2011 03:11:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 81103-03 for ; Thu, 7 Apr 2011 06:10:54 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f46.google.com (mail-ew0-f46.google.com [209.85.215.46]) by mail.postgresql.org (Postfix) with ESMTP id B58911337B47 for ; Thu, 7 Apr 2011 03:10:53 -0300 (ADT) Received: by ewy4 with SMTP id 4so681055ewy.19 for ; Wed, 06 Apr 2011 23:10:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=+pJBduXKARaQAKkt6YgbB1MMC1d3+z1Q5xqXUzTwv6E=; b=q/V3TOdlynaemt7ygZwsx+OhNgzz/Oe5dde0cNywdPlFA2+jLDdHI0aFDR/nHjP9Et xlCTSw/NIkKo0w1FLE0jiTwvYNJ17RZk6HMMnYEAeU2lefCkuM8avd0F90CwZaJqJvAX 9X/14HbA616c1r5yxHtG0yXpNa9u3+nweOCRc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=isyaVeP4HjTYErIBa+PQcjodw/tSRZ8IVEF8PqSrnN5JzLjivX5Mn8Pqtzr5Hxz1mz tjLdbc/5cfMFKQwj42y4/nDMPs9dFq5+PsT7QTfbBpMNexI/R4S4R4vGbV5ZMwz8voJ3 FuGA4ZkEGxEYpPsvoR4k7uG/0YiIwmxvXePwc= MIME-Version: 1.0 Received: by 10.213.98.201 with SMTP id r9mr159425ebn.42.1302156652123; Wed, 06 Apr 2011 23:10:52 -0700 (PDT) Received: by 10.213.98.65 with HTTP; Wed, 6 Apr 2011 23:10:52 -0700 (PDT) In-Reply-To: <908096.9504.qm@web65905.mail.ac4.yahoo.com> References: <908096.9504.qm@web65905.mail.ac4.yahoo.com> Date: Thu, 7 Apr 2011 11:40:52 +0530 Message-ID: Subject: =?UTF-8?B?UmU6IFtBRE1JTl0g4paM4pa6Y29ubmVjdGluZyB0byBPUyB1c2VyIGluIHRoZSBzYW1lIA==?= =?UTF-8?B?ZGI=?= From: raghu ram To: H S Cc: admin , "pesfandiar @ gmail.com" Content-Type: multipart/alternative; boundary=00504502d2e2b1170f04a04df8c7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201104/52 X-Sequence-Number: 37233 --00504502d2e2b1170f04a04df8c7 Content-Type: text/plain; charset=ISO-8859-1 On Thu, Apr 7, 2011 at 8:42 AM, H S wrote: > Hi Sirs, > > I would like more than one OS user can access the same DB in the same > cluster. > > For a user like postgres I had these commands: > > # adduser postgres > # mkdir /usr/local/pgsql/data > # chown postgres /usr/local/pgsql/data > # su -postgres > $ ./initdb -D /usr/*/data --> here login as an postgres in terminal > $ ./postgres -D /usr/*/data --> here login as an postgres in terminal, too. > > > So when I want to access or issue the command : > /usr/local/pgsql/bin/psql postgres as an another OS user, what should I > do?! > > > CREATE USER statement to create and configure a database user,which is an account through which you can log into the database. Create the respective OS users inside the database as follows:: psql=# create user test; and then connect the PostgreSQL database using "test" user as follows:: /usr/local/pgsql/bin/psql -p 5432 -U test -d postgres --Raghu Ram SARA > > > --00504502d2e2b1170f04a04df8c7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

On Thu, Apr 7, 2011 at 8:42 AM, H S <aras_h1988@yahoo.= com> wrote:
Hi Sirs,

I would like more than on= e OS user can access the same DB in the same cluster.

For a user li= ke postgres I had these commands:

# adduser postgres
# mkdir /usr/local/pgsql/data
# chown postgres= /usr/local/pgsql/data
# su -postgres
$ ./initdb -D /usr/*/data=A0 --= > here login as an postgres in terminal
$ ./postgres -D /usr/*/data -= -> here login as an postgres in terminal, too.

So when I want to access or issue the command :
/usr/local/pgsql/bin= /psql postgres=A0 as an another OS user, =A0 what should I do?!


CREATE USER statement to create and configure =A0a database user,whi= ch is an account through which you can log into the database.


Create the respective OS users inside the database as f= ollows::

psql=3D# create user test;
=A0<= /div>
and then connect the PostgreSQL database using "test" u= ser as follows::

/usr/local/pgsql/bin/psql -p 5432 -U test -d postgres

--Raghu Ram


--00504502d2e2b1170f04a04df8c7--
SARA