--- On Thu, 4/7/11, H S <[email protected]> wrote:
From: H S <[email protected]> Subject: Re: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db To: "raghu ram" <[email protected]> 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 <[email protected]> wrote: From: raghu ram <[email protected]> Subject: [ADMIN] Re: [ADMIN] ▌►connecting to OS user in the same db To: "H S" <[email protected]> Cc: "admin" <[email protected]>, "pesfandiar @ gmail.com" <[email protected]> Date: Thursday, April 7, 2011, 10:40 AM On Thu, Apr 7, 2011 at 8:42 AM, H S <[email protected]> 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
