Re: Is that it ?

Is this it ?

Output of cygwin....

Administrator(at)ABC-NQ0MBUYZ4EH ~
$ pwd
/home/Administrator

Administrator(at)ABC-NQ0MBUYZ4EH ~
$ cd ..

Administrator(at)ABC-NQ0MBUYZ4EH /home
$ cd ..

Administrator(at)ABC-NQ0MBUYZ4EH /
$ ls -l
total 890
drwxrwxrwx+ 3 Administ None 200704 Dec 17 01:44 bin
-rwx------+ 1 Administ None 79657 Dec 17 01:21
cygipc-1.13-2-src.tar.bz
2
-rwx------+ 1 Administ None 386405 Dec 17 01:21
cygipc-1.13-2.tar.bz2
-rwxrwxrwx 1 Administ None 88 Dec 17 02:04 cygwin.bat
-rwxrwxrwx 1 Administ None 766 Dec 17 01:43 cygwin.ico
drwxrwxrwx+ 17 Administ None 8192 Dec 17 01:44 etc
drwxrwxrwx+ 3 Administ None 0 Dec 17 00:22
ftp%3a%2f%2fftp.mirror.a
c.uk%2fsites%2fsources.redhat.com%2fpub%2fcygwin
drwxrwxrwx+ 3 Administ None 0 Dec 17 01:45 home
drwxrwxrwx+ 22 Administ None 53248 Dec 17 01:44 lib
drwxrwxrwx+ 2 Administ None 0 Dec 17 01:37 sbin
-rwx------+ 1 Administ None 176128 Dec 17 00:20 setup.exe
drwxrwxrwx+ 2 Administ None 0 Dec 17 01:44 tmp
drwxrwxrwx+ 21 Administ None 4096 Dec 17 01:43 usr
drwxrwxrwx+ 8 Administ None 0 Dec 17 01:43 var

Administrator(at)ABC-NQ0MBUYZ4EH /
$ ipc-daemon &
[1] 768

Administrator(at)ABC-NQ0MBUYZ4EH /
$ initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user
"Administrator
".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/share/postgresql/data... ok
creating directory /usr/share/postgresql/data/base... ok
creating directory /usr/share/postgresql/data/global... ok
creating directory /usr/share/postgresql/data/pg_xlog... ok
creating directory /usr/share/postgresql/data/pg_clog... ok
creating template1 database in /usr/share/postgresql/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

/usr/bin/postmaster -D /usr/share/postgresql/data
or
/usr/bin/pg_ctl -D /usr/share/postgresql/data -l logfile start

Administrator(at)ABC-NQ0MBUYZ4EH /
$ pg_ctl -D /usr/share/postgresql/data -l logfile start
postmaster successfully started

Administrator(at)ABC-NQ0MBUYZ4EH /
$ psql template1
Welcome to psql 7.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

template1=# \h
Available help:
ABORT CREATE TABLE EXECUTE
ALTER DATABASE CREATE TABLE AS EXPLAIN
ALTER GROUP CREATE TRIGGER FETCH
ALTER TABLE CREATE TYPE GRANT
ALTER TRIGGER CREATE USER INSERT
ALTER USER CREATE VIEW LISTEN
ANALYZE DEALLOCATE LOAD
BEGIN DECLARE LOCK
CHECKPOINT DELETE MOVE
CLOSE DROP AGGREGATE NOTIFY
CLUSTER DROP CAST PREPARE
COMMENT DROP CONVERSION REINDEX
COMMIT DROP DATABASE RESET
COPY DROP DOMAIN REVOKE
CREATE AGGREGATE DROP FUNCTION ROLLBACK
CREATE CAST DROP GROUP SELECT
CREATE CONSTRAINT TRIGGER DROP INDEX SELECT INTO
CREATE CONVERSION DROP LANGUAGE SET
CREATE DATABASE DROP OPERATOR CLASS SET CONSTRAINTS
CREATE DOMAIN DROP OPERATOR SET SESSION
AUTHORIZATION
CREATE FUNCTION DROP RULE SET TRANSACTION
CREATE GROUP DROP SCHEMA SHOW
CREATE INDEX DROP SEQUENCE START TRANSACTION
CREATE LANGUAGE DROP TABLE TRUNCATE
:

-----Original Message-----
From: Magnus Naeslund(f) [mailto:mag(at)fbab(dot)net]
Sent: 16 December 2002 17:01
To: zahid rahman
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] following instructions GCC

(I forwarded the mail to the general list so that we keep onlist, next
time use 'reply to all' or similar...)

zahid rahman <zahidr(at)btconnect(dot)com> wrote:
> Hi,
>
> Excellent!
>
> I have just downloaded postgresql.
> I am in the process of downloading cygwin as per install file.
> I follow instructions. I am a good boy!
> I am a windows 2000 user. Ok ! I am not so good.
>
> My next instruction is that I will require a GCC compiler.
> Where can I get so that I go to the sql prompt and run sql create
> command
> to create that elusive table without any hiccups.
>

I'm sorry to say that i don't know anything about using postgresql in
cygwin.
But i think the safest bet is to use the cygwin install program to
install postgresql.
After that you just start postgresql as you normally would do i think.

For more info, see: http://www.se.postgresql.org/docs/faq-mswin.html

Magnus