PostgreSQL

[Michalis Kabrianis]

On 18-Apr-2000 panoulis wrote:
> Pedia hello
> exw ena problimataki pou den mporw na to lyso monos mou kai 8elo
> oposdipote ka8e boi8eia apo sas
> 
> Exw to redhat 6.2 , kai exw den mporw na synde8w stin postegresql.
> Otan syndeome sto systima san postgres user, kai ektelo psql -l apo ton
> bash shell mou bgazei to ejis
> mesg :
>             datname |datdba|encoding|datpath
>             ---------+------+--------+---------
>             template1|   502|       0      |template1
>              (1 row)
> 
> otan omos leo apla , psql :        Connection to database 'postgres'
> failed.
>                                                 FATAL 1:  Database
> postgres does not exist in pg_database


Apla opws leei psaxnei na brei tin database postgres (opws eipe kai allos prin
apo mena).

Ayto pou theleis na kaneis einai:
(san postgres xristis)
$ createdb dbname
$ psql -d dbname
dbname=> 

meta arxizeis na dineis SQL commands.

Enallaktika mporeis apla na kaneis to eksis:

$ psql -d template1
template1=> create database dbname
CREATEDB
template1=> \conect dbname
dbname=>


Michalis Kabrianis

--
linux-greek-users mailing list -- http://lists.hellug.gr