Fw: Re: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





--- On Thu, 4/7/11, H S <aras_h1988@xxxxxxxxx> wrote:

From: H S <aras_h1988@xxxxxxxxx>
Subject: Re: Re: [ADMIN] ââconnecting to OS user in the same db
To: "raghu ram" <raghuchennuru@xxxxxxxxx>
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@xxxxxxxxx> wrote:

From: raghu ram <raghuchennuru@xxxxxxxxx>
Subject: Re: [ADMIN] ââconnecting to OS user in the same db
To: "H S" <aras_h1988@xxxxxxxxx>
Cc: "admin" <pgsql-admin@xxxxxxxxxxxxxx>, "pesfandiar @ gmail.com" <pesfandiar@xxxxxxxxx>
Date: Thursday, April 7, 2011, 10:40 AM



On Thu, Apr 7, 2011 at 8:42 AM, H S <aras_h1988@xxxxxxxxx> 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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux