Re: Is that it ?

Is this it ?

Output of cygwin....

Administrator@ABC-NQ0MBUYZ4EH ~
$ pwd
/home/Administrator

Administrator@ABC-NQ0MBUYZ4EH ~
$ cd ..

Administrator@ABC-NQ0MBUYZ4EH /home
$ cd ..

Administrator@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@ABC-NQ0MBUYZ4EH /
$ ipc-daemon &
[1] 768

Administrator@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@ABC-NQ0MBUYZ4EH /
$ pg_ctl -D /usr/share/postgresql/data -l logfile start
postmaster successfully started

Administrator@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
LOCKCHECKPOINT                DELETE                    MOVE CLOSE                     DROP AGGREGATE            NOTIFY
CLUSTER                  DROP CAST                 PREPARE COMMENT                   DROP CONVERSION           REINDEX
COMMIT                   DROP DATABASE             RESET COPY                      DROP DOMAIN               REVOKE
CREATEAGGREGATE          DROP FUNCTION             ROLLBACK CREATE CAST               DROP GROUP                SELECT
CREATECONSTRAINT TRIGGER DROP INDEX                SELECT INTO CREATE CONVERSION         DROP LANGUAGE             SET
CREATEDATABASE           DROP OPERATOR CLASS       SET CONSTRAINTS CREATE DOMAIN             DROP OPERATOR
SETSESSION
 
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@fbab.net] 
Sent: 16 December 2002 17:01
To: zahid rahman
Cc: pgsql-general@postgresql.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@btconnect.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