pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed ▌►connecting to OS user in the same db
3+ messages / 2 participants
[nested] [flat]
* ▌►connecting to OS user in the same db
@ 2011-04-07 03:12 H S <aras_h1988@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: H S @ 2011-04-07 03:12 UTC (permalink / raw)
To: pgsql-admin; +Cc: pesfandiar @ gmail.com <pesfandiar@gmail.com>
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?!
SARA
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [ADMIN] ▌►connecting to OS user in the same db
@ 2011-04-07 06:10 raghu ram <raghuchennuru@gmail.com>
parent: H S <aras_h1988@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: raghu ram @ 2011-04-07 06:10 UTC (permalink / raw)
To: H S <aras_h1988@yahoo.com>; +Cc: pgsql-admin; pesfandiar @ gmail.com <pesfandiar@gmail.com>
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
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Fw: Re: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db
@ 2011-04-07 17:31 H S <aras_h1988@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: H S @ 2011-04-07 17:31 UTC (permalink / raw)
To: pgsql-admin
--- 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-04-07 17:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-07 03:12 ▌►connecting to OS user in the same db H S <aras_h1988@yahoo.com>
2011-04-07 06:10 ` raghu ram <raghuchennuru@gmail.com>
2011-04-07 17:31 Fw: Re: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db H S <aras_h1988@yahoo.com>
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