Re: lug-bg: PostgreSQL

[gf@xxxxxx (Georgi Chorbadzhiyski)]

Pavlin Petkov wrote:
> Zdrawejte
> 
>  Instalirah si postgresql sledwajki instrukciite w
> readme file-tata ... imam syzdaden i user 'pgsql'
> kojto za shell ima /sbin/nologin (taka pisheshe da se
> naprawi). Sega obache kogato iskam da si syzdam baza
> s:
> 
> calavera:71$ db_manage.sh create users_db
> 
> sled wywevdane imeto na bazata, username i password za
> dostyp do bazata mi izpljuwa slednite greshki ...
> 
> psql: FATAL 1:  SetUserId: user 'calavera' is not in
> 'pg_shadow'
> psql: FATAL 1:  SetUserId: user 'calavera' is not in
> 'pg_shadow'
> createdb: database creation failed
> psql: FATAL 1:  Database "users_db" does not exist in
> the system catalog.
> psql: FATAL 1:  Database "users_db" does not exist in
> the system catalog.
> 
> kyde se namira tozi pg_shadow i kak se dobawqt user-i
> w nego? Izobshto kak da ukava ns PstgreSQL-a koi useri
> ot OS-a mogat da dostypwat bazite i kak ot komandniq
> red se ukazwa s koj user (weche na bazata, a ne ne
> OS-a) se swyrzwam kym bazata?

lognat si kato root
   passwd pgsql (za da mozhesh posle ot calavera da pravish su)
   chsh pgsql (slozhi mu /bin/bash)

logni se kato calavera
   su - pgsql
   bin/createuser (dobavi si user calavera sas pylni prava)
   exit

(sega pak si si calavera)
   /usr/local/pgsql/bin/createdb users_db

psql users_db
pgsql=>

ili kato user calavera
/usr/local/pgsql/bin/createdb -U pgsql users_db
/usr/local/pgsql/bin/createuser -U pgsql calavera

P.S. Neznam zashto v dokumentaciata preporachvat da se slaga na pgsql
      /bin/nologin za shell, po-tozi nachin dosta poveche rabota e da
      setupnesh bazata danni v nachaloto

===========================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers)
http://www.linux-bulgaria.org/ Hosted by Internet Group Ltd. - Stara Zagora