From aras_h1988@yahoo.com Thu Apr 7 03:12:41 2011 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 1FAB71337B9C for ; Thu, 7 Apr 2011 00:12:41 -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 90786-02 for ; Thu, 7 Apr 2011 03:12:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web65905.mail.ac4.yahoo.com (web65905.mail.ac4.yahoo.com [98.136.86.196]) by mail.postgresql.org (Postfix) with SMTP id D0AEB1337B2F for ; Thu, 7 Apr 2011 00:12:18 -0300 (ADT) Received: (qmail 16628 invoked by uid 60001); 7 Apr 2011 03:12:16 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1302145936; bh=b+XHll0cXqqYNH8dZFtTuBJS4U8K21PPIRqcpFoy0+A=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=DyrEcIocuX0OCGOlKm2zWYATlnCOI2zQfMRu+njxixUM/cK5nHwqS82HzHay4wHADiRjdYjiWHNcpmEnzwwgtLFoBxDLkvN/4YGMt/UWdc84DJYCbRDGC6EzK5X8LBP0bswMdNz9G8TTWZvqidovxncBFWCwyPBEU8T5fhgiYQE= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=pTkyb8tz/62GThR6ZagYLI08OHxlufHVBYgk0E032mEGrBoOTxIt2eCrgVFtBEiOUBkTphzwzUyqvyVk5PaaHwCAtgW/xtTSATLezbUMtJcadbjkg2ywFrv0uZDEJENE6tYC2hFpjkowX5QSHt/tGuyE56bbuKqEorMKbnJpDHQ=; Message-ID: <908096.9504.qm@web65905.mail.ac4.yahoo.com> X-YMail-OSG: MUzJ_DUVM1kcB4Q5bdgtP130Lyjp1MGIBQuOUIV.Or3nSze wEDTjBIybkbkGQw8A3PMWI99jacYIZhKChV0USRrL9fjqmTkBV5gmDFNkCxm ADjNxxUuVwnb1AYApOsNEeZylexjtc.LLU4UrB3mGLO1dEKHmhMCwG9YHb8k Hfosv6a12w5PaxZQJZtMTbQM00g5MIwiHlhw.V4jzkPU8Kq18v3h20uwIyuM VxM_NHhjUye9NhUpt3hWsD5vyyJP5Cn9xBnuDNmr41TsX4j7rPIR_nMUDbrw 7tOTE3Cv0uFGjDQoidtnoGCOxiJinNzAaNi.8lNaVI0VFhj3IrjBiMimDWwI LO1xGXmTPl1mElt5PLCc3XQCtrRmYiy8P6WLwj2InIokiMkRXJftyF7G4Zoe ZZ67eYKBEzS1JmQ-- Received: from [2.176.127.211] by web65905.mail.ac4.yahoo.com via HTTP; Wed, 06 Apr 2011 20:12:16 PDT X-Mailer: YahooMailClassic/12.0.2 YahooMailWebService/0.8.109.295617 Date: Wed, 6 Apr 2011 20:12:16 -0700 (PDT) From: H S Subject: =?utf-8?B?4paM4pa6Y29ubmVjdGluZyB0byBPUyB1c2VyIGluIHRoZSBzYW1lIGRiIA==?= To: admin Cc: "pesfandiar @ gmail.com" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-541149247-1302145936=:9504" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.354 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/51 X-Sequence-Number: 37232 --0-541149247-1302145936=:9504 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Sirs, I would like more than one OS user can access the same DB in the same clust= er.=20 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=C2=A0 --> here login as an postgres in terminal $ ./postgres -D /usr/*/data --> here login as an postgres in terminal, too.= =20 So when I want to access or issue the command : /usr/local/pgsql/bin/psql postgres=C2=A0 as an another OS user, =C2=A0 what= should I do?!=20 SARA --0-541149247-1302145936=:9504 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi Sirs,

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

For a user like p= ostgres I had these commands:

# adduser postgres
# mkdir /usr/loc= al/pgsql/data
# chown postgres /usr/local/pgsql/data
# su -postgres$ ./initdb -D /usr/*/data  --> here login as an postgres in termi= nal
$ ./postgres -D /usr/*/data --> here login as an postgres in term= inal, too.

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


SARA


--0-541149247-1302145936=:9504-- From raghuchennuru@gmail.com Thu Apr 7 06:11:15 2011 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-- From aras_h1988@yahoo.com Thu Apr 7 17:31:31 2011 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3DF14133798E for ; Thu, 7 Apr 2011 14:31:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 18301-01 for ; Thu, 7 Apr 2011 17:31:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web65902.mail.ac4.yahoo.com (web65902.mail.ac4.yahoo.com [98.136.86.193]) by mail.postgresql.org (Postfix) with SMTP id 6A4AA13364DE for ; Thu, 7 Apr 2011 14:31:20 -0300 (ADT) Received: (qmail 68443 invoked by uid 60001); 7 Apr 2011 17:31:18 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1302197478; bh=M+IZr2wHWID5oCosmiyy6BlOJ9Ol0tmbGnaahgDwk38=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=zUsYLwgYjOJtydaqDNo6SkvnuLX1SRBNnuckWrGp0yKa25ibWusSCZ2RR7MPzqGX1Q3wTF4JtnBsmRS/J78p+u1rpidNPoMOWXujAr7KL8PFNV+vZu4+U600qD1lUyFCmaWvjqTl22SaI5AufuPIS0nIXn1Fx12bHciLGeOwacY= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=yaQ+fuW+Dt8GsRvbog+LaPY6TpJ1OI2oex+qPDomk0vf1Q9jdSgdWULZBl50pczlL8y3c9dy1FkTDboXIDt5kK0R5UaaaNB+7FGKwjV737tfkVhqtVGJsPl1H2C5jfoIlHY+W3ejtc3kyVsMmVlNh/HilTM+hZN4kvzKm5gx+VM=; Message-ID: <770688.61854.qm@web65902.mail.ac4.yahoo.com> X-YMail-OSG: BsVFY80VM1ntWEieAj1FQ.T281GkIXP8yYvRYIfAZpil1vS f3xt8PrFuW6dfL2UxffkugQ2zNmvcPU3DPnOV02GB4rBmWt1cz7NtV.HcU6o MZNDzNu1qIc6PPnrys1LYYWQSm6VXm8Tf6ilI9inZdka.7U5gjKulcsa8OOx Wg406vtDjMXjbCvaZuInCEj01A2zusCnexdh6sdKSLOYdFxl4yIYoDT1SG96 Z_c.tIDz_aLLhndf.fYGGAtP1ftZSc5bpYTj4tokQ9_g_tsQXyo6dfhD8cKY LrxEt5VYdi9v8bpeJFs6QR6Ce5eIe89JyM4fJKLxRbHLvTb.FJQehNsbiT9X V3ooOtKy4L2bsvSCEqe94tg6AH4tei_pU80olsdRpc8CaTPNSSTlamAm_Ch8 XqgeFl9ofXsQwd4IXc.uWTWY- Received: from [2.176.85.183] by web65902.mail.ac4.yahoo.com via HTTP; Thu, 07 Apr 2011 10:31:18 PDT X-Mailer: YahooMailClassic/12.0.2 YahooMailWebService/0.8.109.295617 Date: Thu, 7 Apr 2011 10:31:18 -0700 (PDT) From: H S Subject: =?utf-8?B?Rnc6IFJlOiBbQURNSU5dIFJlOiBbQURNSU5dIOKWjOKWumNvbm5lY3Rpbmcg?= =?utf-8?B?dG8gT1MgdXNlciBpbiB0aGUgc2FtZSBkYg==?= To: admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1214367379-1302197478=:61854" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.355 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/59 X-Sequence-Number: 37240 --0-1214367379-1302197478=:61854 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable --- On Thu, 4/7/11, H S wrote: From: H S Subject: Re: [ADMIN] Re: [ADMIN] =E2=96=8C=E2=96=BAconnecting to OS user in= the same db To: "raghu ram" Date: Thursday, April 7, 2011, 9:07 PM =0ACREATE USER statement to create and configure =C2=A0a database user,whic= h is an account through which you can log into the database.--> I shoul iss= ue : CREATE USER test;=C2=A0 ?!=20 --> please let me know.=20 =0A Create the respective OS users inside the database as follows:: psql=3D# create user test;=C2=A0and then connect the PostgreSQL database us= ing "test" user as follows::=0A /usr/local/pgsql/bin/psql -p 5432 -U test -d postgres --- On Thu, 4/7/11, raghu ram wrote: From: raghu ram Subject: [ADMIN] Re: [ADMIN] =E2=96=8C=E2=96=BAconnecting to OS user in the= same db To: "H S" Cc: "admin" , "pesfandiar @ gmail.com" Date: Thursday, April 7, 2011, 10:40 AM On Thu, Apr 7, 2011 at 8:42 AM, H S wrote: =0AHi Sirs, I would like more than one OS user can access the same DB in the same clust= er.=20 For a user like postgres I had these commands: =0A # adduser postgres # mkdir /usr/local/pgsql/data # chown postgres /usr/local/pgsql/data # su -postgres $ ./initdb -D /usr/*/data=C2=A0 --> here login as an postgres in terminal $ ./postgres -D /usr/*/data --> here login as an postgres in terminal, too.= =20 =0A So when I want to access or issue the command : /usr/local/pgsql/bin/psql postgres=C2=A0 as an another OS user, =C2=A0 what= should I do?!=20 =0ACREATE USER statement to create and configure =C2=A0a database user,whic= h is an account through which you can log into the database.=0A Create the respective OS users inside the database as follows:: psql=3D# create user test;=C2=A0and then connect the PostgreSQL database us= ing "test" user as follows::=0A /usr/local/pgsql/bin/psql -p 5432 -U test -d postgres --Raghu Ram =0ASARA =0A --0-1214367379-1302197478=:61854 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
SARA




--- On Thu, 4/7/11, H S <ara= s_h1988@yahoo.com> wrote:

From: = H S <aras_h1988@yahoo.com>
Subject: Re: [ADMIN] Re: [ADMIN] =E2=96= =8C=E2=96=BAconnecting to OS user in the same db
To: "raghu ram" <rag= huchennuru@gmail.com>
Date: Thursday, April 7, 2011, 9:07 PM

<= div id=3D"yiv1077849940">=

=0ACREATE USER s= tatement to create and configure  a database user,which is an account = through which you can log into the database.

--> I shoul issue : CREAT= E USER test;  ?!

--> please let me know.

=0A

Create the respective OS users inside the database= as follows::

psql=3D# create user test;
 
and then connect the PostgreSQL database using "test" use= r as follows::
=0A

/usr/local/pgsql/bin/psql -p 543= 2 -U test -d postgres


--- On Thu, 4/7/11, raghu ram <= raghuchennuru@gmail.com> wrote:

= From: raghu ram <raghuchennuru@gmail.com>
Subject: [ADMIN] Re: [AD= MIN] =E2=96=8C=E2=96=BAconnecting to OS user in the same db
To: "H S" &l= t;aras_h1988@yahoo.com>
Cc: "admin" <pgsql-admin@postgresql.org>= ;, "pesfandiar @ gmail.com" <pesfandiar@gmail.com>
Date: Thursday,= April 7, 2011, 10:40 AM



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

I would like more t= han one OS user can access the same DB in the same cluster.

For a u= ser like postgres I had these commands:
=0A
# adduser postgres
# m= kdir /usr/local/pgsql/data
# chown postgres /usr/local/pgsql/data
# s= u -postgres
$ ./initdb -D /usr/*/data  --> here login as an post= gres in terminal
$ ./postgres -D /usr/*/data --> here login as an pos= tgres in terminal, too.
=0A
So when I want to access or issue the co= mmand :
/usr/local/pgsql/bin/psql postgres  as an another OS user, =   what should I do?!



=0ACREATE USER statement to create and configure  a data= base user,which is an account through which you can log into the database.<= /span>

=0A

Create the respective OS users insid= e the database as follows::

psql=3D# create user t= est;
 
and then connect the PostgreSQL database us= ing "test" user as follows::
=0A

/usr/local/pgsql/b= in/psql -p 5432 -U test -d postgres

--Raghu Ram

=0A<= /tr>
SARA



=0A
--0-1214367379-1302197478=:61854--