(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


Tue, 17 Dec 2002 02:00:47 +0100
"Magnus Naeslund(f)" <mag@fbab.net>
Re: [HACKERS] following instructions GCC

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                   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@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


Tue, 17 Dec 2002 02:31:48 -0800
"zahid rahman" <zahidr@btconnect.com>
Re:  Is that it ?