Re: [HACKERS] documentation udpates to pgupgrade.html

2010-09-29 Thread Colin 't Hart
Bruce, To query for Postgresql services on Windows use: sc query type= service | find postgresql On my machine this yields: SERVICE_NAME: postgresql-9.0 DISPLAY_NAME: postgresql-9.0 - PostgreSQL Server 9.0 NB the space after type= is very important, don't ask me why... I prefer to use

Re: [HACKERS] documentation udpates to pgupgrade.html

2010-09-29 Thread Massa, Harald Armin
Colin, To query for Postgresql services on Windows use: sc query type= service | find postgresql sad news is that (at least on my computer) it only finds running services. Harald -- GHUM GmbH Harald Armin Massa Spielberger Stra├če 49 70435 Stuttgart 0173/9409607 Amtsgericht Stuttgart,

Re: [HACKERS] documentation udpates to pgupgrade.html

2010-09-29 Thread Colin 't Hart
Oops. Apparently type= service is the default, so we can remove that bit. Then we should add state= all. The default = active, a third option = inactive. So: sc query state= all should list all services, in all states. And then we pipe to find which is the Windows equivalent of grep, but it

Re: [HACKERS] documentation udpates to pgupgrade.html

2010-09-28 Thread Bruce Momjian
Massa, Harald Armin wrote: Hello, just doing an upgrade form PostgreSQL 8.4.4 on Windows 2007 64bit to PostgreSQL 9.0 64bit on the same system. I am working along http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html There is written: NET STOP postgresql-8.4 NET STOP

Re: [HACKERS] documentation udpates to pgupgrade.html

2010-09-28 Thread Massa, Harald Armin
Bruce, NET STOP postgresql-8.4 NET STOP postgresql-9.0 which should be extended by net stop postgresql-x64-9.0 for Windows 64 bit. Interesting. What I have added to HEAD and 9.0 docs is the attached patch that explains the proper service name should be used. I don't

Re: [HACKERS] documentation udpates to pgupgrade.html

2010-09-28 Thread Bruce Momjian
Massa, Harald Armin wrote: Bruce, NET STOP postgresql-8.4 NET STOP postgresql-9.0 which should be extended by net stop postgresql-x64-9.0 for Windows 64 bit. Interesting. What I have added to HEAD and 9.0 docs is the attached patch that explains the proper

[HACKERS] documentation udpates to pgupgrade.html

2010-09-26 Thread Massa, Harald Armin
Hello, just doing an upgrade form PostgreSQL 8.4.4 on Windows 2007 64bit to PostgreSQL 9.0 64bit on the same system. I am working along http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html There is written: NET STOP postgresql-8.4 NET STOP postgresql-9.0 or NET STOP pgsql-8.3