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 n

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 Stuttg

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-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 attach

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

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

[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 (Postg