Re: Need some help getting started

PostgreSQL-Cygwin Installation Steps


On Windows 9x/Me, you can only install postgresql as
an app:

1. Start the cygipc ipc-daemon2:

    $ ipc-daemon2 &

2. Initialize PostgreSQL:

    $ initdb -D /usr/share/postgresql/data

3. Start the PostgreSQL postmaster:

    $ postmaster -D /usr/share/postgresql/data &

4. Connect to PostgreSQL:

    $ psql template1


For Windows XP Home, Windows XP Pro, Windows NT 4.0,
Windows 2000, it's better to install it as a service:

In the following steps, replace the following
placeholders with appropriate values:
[USER_1] : Any Windows Admin user. Example: joeuser.
[POSTGRES_USER_DIR]: directory to the postgres user's
home directory.  Example: /home/postgres
[POSTGRES_PASSWORD]: password for postgres user
account.  Must be non-blank.  Example: anonblankpwd

1. Make sure Cygwin's bin directory (e.g.,
C:\Cygwin\bin) is added to the
    Windows NT/2000's system PATH and the machine
rebooted for the SCM
    to find cygwin1.dll.

2. Log in as [USER_1]

3. Install the cygipc ipc-daemon2 as a NT service:

    $ ipc-daemon2 --install-as-service

4. Create the "postgres" user account:

    $ net user postgres [POSTGRES_PASSWORD] /add
/fullname:postgres /comment:'PostgreSQL user account'
/homedir:"[POSTGRES_DIR]"
    $ mkpasswd -l -u postgres >>/etc/passwd

5. Grant the "postgres" user the "Log on as a service"
user right.  (See
http://support.microsoft.com/default.aspx?scid=KB;en-us;q259733
for
    a Microsoft KB article explaining how to configure
user rights.):

    # If on Windows XP Home:
    #   I think you have to download and install the
ntrights utility for setting nt permissions
    #   from here
http://www.dynawell.com/reskit/microsoft/win2000/ntrights.zip

    $ editrights -u postgres -a SeServiceLogonRight
    # else if on Windows NT 4.0:
    #   start User Manager, select Policies, and then
select User Rights...
    # else if on Windows 2000 or XP Pro:
        $ cmd /c secpol.msc

6. Install postmaster as a NT service (Clean
postmaster shutdown will only work with a post Cygwin
1.3.2
    snapshot from 2001-Jul-28 or later.):

    $ cygrunsrv --install postmaster --path
/usr/bin/postmaster --args "-D
/usr/share/postgresql/data -i" --dep ipc-daemon2
--termsig INT --user postgres --shutdown

7. Create the PostgreSQL data directory:

    $ mkdir /usr/share/postgresql/data

8. Change ownership of the PostgreSQL data directory
(Assumes that ntsec is set via the CYGWIN environment
variable):

    $ chown postgres /usr/share/postgresql/data

9. Start the cygipc ipc-daemon2
       If ipc-daemon2 is not running or a version
previous to
       2.01-1 is running, then initdb and postmaster
can fail with the error
       message:
           IpcSemaphoreCreate: semget(...) failed:
Function not implemented
       and
           IpcMemoryCreate: shmget(...) failed:
Function not implemented
       respectively.

    $ cygrunsrv -S ipc-daemon2

10. Switch from [USER_1] to "postgres":

11. Initialize PostgreSQL:

    $ initdb -D /usr/share/postgresql/data

12. Switch from "postgres" to [USER_1]:

13. Start postmaster:

    $ cygrunsrv -S postmaster

14. Verify postmaster is running (If postmaster fails
to start, then examine /var/log/postmaster.log
     and/or the NT Event Log):

    $ cygrunsrv -Q postmaster

15. Connect to PostgreSQL (This can be run as any
user.  One can use PostgreSQL's createuser command or
set PGUSER to obviate
    the need to specify "-U postgres" on the psql
command line):

    $ psql -U postgres template1


__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/