Re: PGSQL 8-beta For WinXP Home Edition Instructions - Mailing list pgsql-novice
| From | George Weaver |
|---|---|
| Subject | Re: PGSQL 8-beta For WinXP Home Edition Instructions |
| Date | |
| Msg-id | 001101c482c1$09a00ec0$6400a8c0@Dell4500 Whole thread Raw |
| In response to | Re: PGSQL 8-beta For WinXP Home Edition Instructions (<operationsengineer1@yahoo.com>) |
| Responses |
Re: PGSQL 8-beta For WinXP Home Edition Instructions
|
| List | pgsql-novice |
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 -----Sent: Sunday, August 15, 2004 12:51 AMSubject: Re: [NOVICE] PGSQL 8-beta For WinXP Home Edition InstructionsAndreas,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 inOwner$ cygrunsrv --start postmasterI get Win32 error: 1069: The service did not start due to logon failure (using Owner)When I type inpostgre$ cygrunsrv --start postmasterI 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
pgsql-novice by date: