From: | Nikola Milutinovic <Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Linux Format Gambas Easy Database Access! |
Date: | 2005-11-28 11:28:49 |
Message-ID: | 438AE9F1.1010809@ev.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
John Hedge wrote:
>Hi,
>
>As you'll realise I'm new to all things Postgresql (& Gambas).
>
>I'm following Dr Bain's article in LXF71.
>
>Everything has gone ok (now) up until the introduction of "< data.sql"
>as per below.
>
>Can someone explain what we're trying to do here, and more importantly
>why it's not working and what I've done wrong, please?
>
>TIA
>
>John
>
>postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/initdb
>-D /usr/local/pgsql/data/
>The files belonging to this database system will be owned by user
>"postgres".
>This user must also own the server process.
>
>The database cluster will be initialized with locale C.
>
>initdb: directory "/usr/local/pgsql/data/" exists but is not empty
>If you want to create a new database system, either remove or empty
>the directory "/usr/local/pgsql/data/" or run initdb with an argument
>other than
>"/usr/local/pgsql/data/".
>postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/postmaster
>-D /usr/local/pgsql/data/ >~/logfile 2>&1 &
>[1] 14081
>
>
Up to this point nothing bad.
>postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/createdb customers CREATE
>DATABASE
>[1]+ Exit 1 /usr/lib/postgresql/bin/postmaster
>-D /usr/local/pgsql/data/ >~/logfile 2>&1
>
>
This could mean that postmaster has died and is no longer running. So,
there is a problem with your setup, I'd say.
>postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/psql customers < data.sql
>bash: data.sql: No such file or directory
>
>
"data.sql" is apparently not in your current dir.
Nix.
From | Date | Subject | |
---|---|---|---|
Next Message | me | 2005-11-28 12:01:28 | Re: How does PG Inheritance work? |
Previous Message | Neil Saunders | 2005-11-28 08:58:26 | Re: PostgreSQL 8.0.1-2 WinXP Services |