PGSQL 7.4.3 Compatible with 7.4.2?

I finally got the basic cygwin pgsql 7.4.3 install running by following the postgresql readme in the cygwin folder (using wordpad) and googling the error I received b/c the readme left out one step.

However, my webhost service only offers 7.4.2. Should I try and find a pgsql 7.4.2 cygwin install or should I be alright developing on 7.4.3 and then transferring the database to my webhost running 7.4.2?

TIA.

George Weaver <gweaver(at)shaw(dot)ca> wrote:
cygipc is no longer necessary. If I understand your situation, you have PostgreSQL installed and have successfully run initdb and can start the postmaster with pg_ctl. If you're not interested in running postmaster as a service while you undertake development, you're ready to start using the database (via psql, pgAdmin III or another client).

If you want to run postmaster as a service, I believe that you have everything installed properly. The problems starting the service are most likely related to file permissions. Also make sure that user postgres has logon as service rights. You should be able to find the answers you need to start postmaster as a service in the Cywin mailing list archives.

George

----- Original Message -----
From: operationsengineer1(at)yahoo(dot)com
To: pgsql-novice(at)postgresql(dot)org
Sent: Sunday, August 15, 2004 3:10 PM
Subject: Re: [NOVICE] PGSQL 8-beta For WinXP Home Edition Instructions

George,

Thanks for the links. The documentation says I need to install cygipc. I thought cygserver had replaced cygipc. Should I follow the documentation andinstall cygipc instead of cygserver as in Carlo's tutorial?

TIA.

For any Unix/Linux newbies out there, like myself, use cd <directory name> to navigate down through your file structure starting in the cygwin directory. you can type in ls (think of as list) in order to see all the folders and files in the current directory.

You can navigate back up your directory structure by typing in ../ to move up one directory structure. You can type in ../../ to move up two directories and so on.

you can type in less <filename> to read a file such as documentation or faqs.

George Weaver <gweaver(at)shaw(dot)ca> wrote:
I think you would find it very helpful to use the official (and extensive) on-line documentation provided with PostgreSQL (http://www.postgresql.org/docs/current/static/index.html). Most of the challenges you're facing and the questions you have are addressed in the documentation. You might find the FAQ site particularly useful (http://www.postgresql.org/docs/faqs/FAQ.html) as well.

For example, to start and stop PostgreSQL manually use pg_ctl (http://www.postgresql.org/docs/7.4/static/app-pg-ctl.html). You seem to indicate that you used pg_ctl, but also refer to trying to start the postmaster as a service. If you start postmaster with pg_ctl, the postmaster is running and you don't need to start it as a service.

If you're interested in how to start it as a service for future reference, I would strongly suggest reading the installation guide prepared by Jason Tishler (see http://www.tishler.net/jason/software/postgresql/?M=A for the guide applicable to your situation).

To access postgreSQL once it has been started you can use "psql" (no "g") in a console (DOS) window as an interactive terminal. You must be in a DOS window to start it (see http://www.postgresql.org/docs/7.4/static/app-psql.html for starting instructions and command line options).

Or you can use the graphical administration program PgAdmin III (see http://www.pgadmin.org/pgadmin3/index.php).

For a complete list of PostgreSQL documentation see http://www.postgresql.org/docs/.

HTH,
George
----- Original Message -----
From: operationsengineer1(at)yahoo(dot)com
To: pgsql-novice(at)postgresql(dot)org
Sent: Sunday, August 15, 2004 12:51 AM
Subject: Re: [NOVICE] PGSQL 8-beta For WinXP Home Edition Instructions

Andreas,

You've been very helpful. Carlo inadvertently typed "pg-ctl" instead of "pg_ctl". The latter worked flawlessly once you explained the structure of cygdrive so that I could get to the correct file. I don't think his cygdrive folder callout was right since he left out "/cygwin/var" in the callout.

Carlo also seems to think that postmaster is in /usr/bin (empty) when it is really in /bin. I will ask him if he set up his tutorial so that I should move the file to /usr/bin or if I should adjust the code to reflect just /bin.

When I type in

Owner$ cygrunsrv --start postmaster

I get Win32 error: 1069: The service did not start due to logon failure (using Owner)

When I type in

postgre$ cygrunsrv --start postmaster

I get Win32 error 5: Access is denied.

Does anyone have any ideas?

TIA...

PS - I don't really want to run PGSQL as a service, but that is how Carlo's tutorial is set up and I don't know enough to modify it. My first step is just to get something running. If you can let me know how to set it up so that it isn't a service and let me know how to start and stop the appropriate programs, I'd be happy to learn something new.

PSS - I installed PGSQL on WinXP just fine, too, but I had no clue how to run it since it didn't start when I tried to start it the WinXP way. In addition, the Wrox book I'm using is out of date and all the examples will be based on a Cygwin installation (out of date, no less!) so it will make my life a little easier when I follow the book. Hopefully it will help when I get set to move the db to a Linux platform.

PSSS - Thanks for the note on running just on a LAN. I think a "-i" will enable LAN access and there is also a .conf file I can update so that it willl accept certain IPs that I specify. However, this is strictly for development purposes right now and I have a ways to go before I will actually set this thing up so other machines will need to access it.

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

---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.

---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.