Skip site navigation (1) Skip section navigation (2)

Linux Format Gambas Easy Database Access!

From: John Hedge <john(at)hedge(dot)com(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: Linux Format Gambas Easy Database Access!
Date: 2005-11-24 00:22:39
Message-ID: 1132791759.14100.9.camel@localhost.localdomain (view raw or whole thread)
Lists: pgsql-novice

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?



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
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
postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/postmaster
-D /usr/local/pgsql/data/ >~/logfile 2>&1 &
[1] 14081
postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/createdb customers CREATE
[1]+  Exit 1                  /usr/lib/postgresql/bin/postmaster
-D /usr/local/pgsql/data/ >~/logfile 2>&1
postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/psql customers < data.sql
bash: data.sql: No such file or directory


pgsql-novice by date

Next:From: Sebastian ScaranoDate: 2005-11-24 01:34:50
Subject: Re: Linux DB designer tools
Previous:From: Andrej Ricnik-BayDate: 2005-11-23 20:41:20
Subject: Re: Linux DB designer tools

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group