From: H S <aras_h1988@yahoo.com>
To: admin <pgsql-admin@postgresql.org>
Subject: Fw: Re: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db
Date: Thu, 7 Apr 2011 10:31:18 -0700 (PDT)
Message-ID: <770688.61854.qm@web65902.mail.ac4.yahoo.com> (raw)
--- On Thu, 4/7/11, H S <aras_h1988@yahoo.com> wrote:
From: H S <aras_h1988@yahoo.com>
Subject: Re: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db
To: "raghu ram" <raghuchennuru@gmail.com>
Date: Thursday, April 7, 2011, 9:07 PM
CREATE USER statement to create and configure a database user,which is an account through which you can log into the database.--> I shoul issue : CREATE USER test; ?!
--> please let me know.
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
--- On Thu, 4/7/11, raghu ram <raghuchennuru@gmail.com> wrote:
From: raghu ram <raghuchennuru@gmail.com>
Subject: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db
To: "H S" <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:
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aras_h1988@yahoo.com
Subject: Re: Fw: Re: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db
In-Reply-To: <770688.61854.qm@web65902.mail.ac4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox