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