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


--- 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--