Can anybody help get me started here? I've downloaded the 8-beta .msi file and ran set up on my XP Home laptop. Now I have no clue what to do.

I followed Carlo's web tutorial and got almost all the way through the Cygwin install for 7.4.3 (many, many times), but, alas, I ended here...

------------------------

When I type in the three lines of code - cygrunsrv --install postmaster ... --shutdown, I get the following error:

cygrunsrv: Error installing a service: OpenService: win32 error 1073: The specified service exists already.

When I type in cygrunsrv: --start postmaster, I get the following error:

cygrunsrv: Error starting a service: StartService: Win32 error 1069: The service did not start due to logon failure.

------------------------

That's when I quite that route and went with the version 8-beta. The only problem is, I haven't seen any instructions that make a lick of sense to me.

Any guidance would be appreciated. I really want to standardize on PGSQL rather than MySQL, but this whole painful process has left my head ringing.

Any help would be greatly appreciated. I will post a tutorial of what I did to get PGSQL up and running if I'm able to do it. If not, I guess I have to go with MySQL even though I would prefer not to go that route.

TIA...



---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!

The 8.beta is a native Win32 port. You don't need Cygwin. Just click
on it and install it as a normal app.

---------------------------------------------------------------------------

operationsengineer1 (AT) yahoo (DOT) com wrote:
--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Hello,

If you are installing postgres using the msi file you shouldn't follow
the cygwin instructions at all. The msi file is for a native windows
installation not the cygwin emulation.

I don't believe anyone has created an installation instructions yet for
the native windows version but if the installation program works
correctly you don't really need them.

Mike

On Thu, 2004-08-12 at 22:17, operationsengineer1 (AT) yahoo (DOT) com wrote:
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

В Птн, 13.08.2004, в 05:17, operationsengineer1 (AT) yahoo (DOT) com пишет:
I guess you have a service now that you can start. Then use psql from
the command line or pgAdmin or another app to access the database.

--
Markus Bertheau <twanger (AT) bluetwanger (DOT) de>


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Markus,

I didn't want to install it as a service since I do lots of things on my laptop besides database development. I want to manually start and stop the program.

I will try some things later this afternoon and post my level of success.

Thanks,

Jeff

Markus Bertheau <twanger (AT) bluetwanger (DOT) de> wrote:
В Птн, 13.08.2004, в 05:17, operationsengineer1 (AT) yahoo (DOT) com пишет:
I guess you have a service now that you can start. Then use psql from
the command line or pgAdmin or another app to access the database.

--
Markus Bertheau


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

operationsengineer1 (AT) yahoo (DOT) com schrieb:


I know only the cygwin way, yet, but this doesn't matter.
Even a service can be manually started, if you define it as "manual"
instead of "automatic" in the service-dialoge of Windows.

Set postmaster to "manual" and start it afterwards in a cmd-window with
NET START postmaster
use
NET STOP postmaster
to ... well ... stop it

I guess postmaster wouldn't be peed off even if you let it run into
system shutdown since Windows will stop running services automatically.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Andreas and all,

Thanks to all the people who have tried to help. I think my biggest mistake wasn't signing up here as soon as I started this project.

I'm going back to try and install and run PGSQL 7.4.3 on WinXP Home using CYGWIN. First, I want to learn a little more about the UNIX syntax since I will ultimately be putting my database on a Linux based server. Second, my guess is there is a much larger knowledge base here given that method has been around for quite some time.

I used Carlo's tutorial as my base source of knowledge...

http://www.geocities.com/cfflorendo/...ql-cygwin.html

initdb faltered until Carlo suggested I do the following in addition to his online tutorial:

chmod 755 /usr/bin/postgreschmod 755 /usr/bin/postmaster


chown postgres /usr/bin/postgres
chown postgres /usr/bin/postmaster

I enter this at the same time I enter

chown postgres /var/postgresql/data

in Carlo's tutorial.

When I do all the above (including everyithing in Carlo's tutorial):

initdb -D /var/postgresql/data


works just fine.

However, when I type in the three lines of code

cygrunsrv --install postmaster ... --shutdown

in his tutorial I get the following error:

cygrunsrv: Error installing a service: OpenService: win32 error 1073: The specified service exists already.

When I type in

cygrunsrv: --start postmaster

I get the following error:

cygrunsrv: Error starting a service: StartService: Win32 error 1069: The service did not start due to logon failure


Carlo suggested I try

pg-ctl start -D /cygdrive/c/postgresql/data -l logfile

and I will do so shortly and let everyone know the results.

Also, if I'm using cygserver, do i need to install cygipc, too?

Thanks.


Andreas <maps.on (AT) gmx (DOT) net> wrote:
operationsengineer1 (AT) yahoo (DOT) com schrieb:


I know only the cygwin way, yet, but this doesn't matter.
Even a service can be manually started, if you define it as "manual"
instead of "automatic" in the service-dialoge of Windows.

Set postmaster to "manual" and start it afterwards in a cmd-window with
NET START postmaster
use
NET STOP postmaster
to ... well ... stop it

I guess postmaster wouldn't be peed off even if you let it run into
system shutdown since Windows will stop running services automatically.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

After I successfully ran initdb, I typed in

pg-ctl start -D /cygdrive/c/postgresql/data

and received the following error:

bash: pg-ctl command not found.

Also, can someone explain the "cygdrive" directory nomenclature?

Does /cygdrive/c/postgresql/data - C:cygwin/var/postgresql/data?

Thanks.

operationsengineer1 (AT) yahoo (DOT) com wrote:
Andreas and all,

Thanks to all the people who have tried to help. I think my biggest mistake wasn't signing up here as soon as I started this project.

I'm going back to try and install and run PGSQL 7.4.3 on WinXP Home using CYGWIN. First, I want to learn a little more about the UNIX syntax since I will ultimately be putting my database on a Linux based server. Second, my guess is there is a much larger knowledge base here given that method has been around for quite some time.

I used Carlo's tutorial as my base source of knowledge...

http://www.geocities.com/cfflorendo/...ql-cygwin.html

initdb faltered until Carlo suggested I do the following in addition to his online tutorial:

chmod 755 /usr/bin/postgres chmod 755 /usr/bin/postmaster


chown postgres /usr/bin/postgres
chown postgres /usr/bin/postmaster

I enter this at the same time I enter

chown postgres /var/postgresql/data

in Carlo's tutorial.

When I do all the above (including everyithing in Carlo's tutorial):

initdb -D /var/postgresql/data


works just fine.

However, when I type in the three lines of code

cygrunsrv --install postmaster ... --shutdown

in his tutorial I get the following error:

cygrunsrv: Error installing a service: OpenService: win32 error 1073: The specified service exists already.

When I type in

cygrunsrv: --start postmaster

I get the following error:

cygrunsrv: Error starting a service: StartService: Win32 error 1069: The service did not start due to logon failure


Carlo suggested I try

pg-ctl start -D /cygdrive/c/postgresql/data -l logfile

and I will do so shortly and let everyone know the results.

Also, if I'm using cygserver, do i need to install cygipc, too?

Thanks.


Andreas <maps.on (AT) gmx (DOT) net> wrote:
operationsengineer1 (AT) yahoo (DOT) com schrieb:


I know only the cygwin way, yet, but this doesn't matter.
Even a service can be manually started, if you define it as "manual"
instead of "automatic" in the service-dialoge of Windows.

Set postmaster to "manual" and start it afterwards in a cmd-window with
NET START postmaster
use
NET STOP postmaster
to ... well ... stop it

I guess postmaster wouldn't be peed off even if you let it run into
system shutdown since Windows will stop running services automatically.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space ma p settings

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


---------------------------------
Do you Yahoo!?
Y! Messenger - Communicate in real time. Download now.

operationsengineer1 (AT) yahoo (DOT) com schrieb:


I'd try pg_ctl maybe it works as everyone says ?

And this didn't light things up a bit ?

CygWin mimics the UNIX way to represent devices. There are no drive
letters like C: .
Under UNIX you'll have an abstract root directory named /
This / is usually located at the base of a real partition. Every other
partition, drive, mouse, printer, net-share, .... finds a place below /.
Compare / to the "my computer" folder wherin you'll find the drives.

CygWin uses internally the UNIX method.
Say your CygWin system sits in E:\programs\cygwin
Then this is / when you are on a CygWin command line.
Your own home-directory would then be /home/jeff.
Windows would see it as E:\programs\cygwin\home\jeff.

If you feel like reaching into the rest of the computer from within
CygWin, you'd have to go below / which in UNIX is not possible.
Now /cygdrive puts a new base below both worlds.
Windows: E:\programs\cygwin\home\jeff
CygWin: /home/jeff
CygWin: /cygdrive/e/programs/cygwin/home/jeff
are all the same.



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

operationsengineer1 (AT) yahoo (DOT) com schrieb:

Do as youi please but you are adding a whole lot of complexity with cygwin.
I tried the version 8 beta's msi-instaler and it worked faultlessly.

[...]

Fine. Your server is installed and ready to be started as local database.
It will reject connects from LAN clients.

Those 3 lines are actually just one! The \ at the end of line 1+2
glues them together.

You tried more than once and threrfore there exist a service entry in
windows already.
Though I wonder why you install a service at all, since you said in an
earlier mail you'd don't wan't that.

This seems to be a Windows error.
Maybe the user postgres isn't allowed to start services, yet ?
There is some windows management thingy that does that. You can't do it
from within CygWin.
There is a readme coming with cygwin
----> /usr/share/doc/Cygwin/postgres...

While using postgresql on windows you'll run into a number of
opportunities where you want to bang you head against the wall because
the stupid thing won't come up. Usually it's some kind of access right
issue. Some process wants to do something to a file where it isn't
allowed to go or ast least can't write.
Make sure there is no stale files left from earlier sessions when your
computer crashed.
/var/log/postmaster*
most importantly:
/var/postgresql/data/postmaster.pid or however the name of the
pid-file there is.

The lastest CygWin has it's own IPC magic and AFAIK you'll run into
interferences if you have the cygipc service running.
I still got a rather old version of CygWin and PostgreSQL so I can't say
for sure.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match