Re: Linux Format Gambas Easy Database Access!

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.