Problem on PostgreSQL - creating database
Jarkko Elfving
jarelf at ebaana.net
Wed Aug 18 05:16:25 UTC 2004
ti, 2004-08-17 kello 13:49, Marius Andreiana kirjoitti:
> On Tue, 2004-08-17 at 12:28 +0300, Jarkko Elfving wrote:
> > I've created a database cluster with initdb and it was succesfully
> > created. After that I tried to create a database with createdb -command,
> > but it replys like this:
> >
> > jarelf]$ createdb -D /home/jarelf/dbCluster/mydb -O jarelf
> >
> > createdb: could not connect to database template1: FATAL: user "jarelf"
> > does not exist
> >
> > What am I doing wrong?
> Error message is clear: user "jarelf" does not exist
>
> detail:
> [marius at marte tables]$ createdb --help
> createdb creates a PostgreSQL database.
>
> Usage:
> createdb [OPTION]... [DBNAME] [DESCRIPTION]
>
> Options:
> -O, --owner=OWNER database user to own the new database
>
> solution:
> as root:
> su - postgres
> createuser jarelf
>
>
> --
> Marius Andreiana
> Galuna - Solutii Linux in Romania
> http://www.galuna.ro
Thanks a lot! It works!
But... now when I'm building up that database, does it locate in to my
spicified location or somewhere else?
And what I mean at specified location? .../dbCluster/
Which command I can find it where it did go? And if I should move it to
somewhere else (or if I do a SQL-based program exp. with Java) can I use
that database without PostgreSQL services?
Lot's of stupid questions but I'm now so exciting of this :D
--
Jarkko Elfving
Suomi - Finland
===---------===
[FIN] Tämä viesti on digitaalisesti allekirjoitettu, julkisen avaimen
voit hakea seuraavilta palvelimilta:
[UK/US] This mail has been digitally signed and you can download the
public-key from these servers from the list:
http://subkeys.pgp.net
pgp-public-keys at keys.pgp.net
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digitaalisesti allekirjoitettu viestin osa
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20040818/88cb7022/attachment-0001.sig>
More information about the fedora-list
mailing list