dbTalk Databases Forums  

[BUGS] pg_autovacuum fails to run as a windows service (beta4)

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] pg_autovacuum fails to run as a windows service (beta4) in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve McWilliams
 
Posts: n/a

Default [BUGS] pg_autovacuum fails to run as a windows service (beta4) - 12-10-2004 , 03:40 PM






I am unable to run pg_autovacuum as a windows service. I am using
8.0.0beta4 on Windows XP Pro. When I execute the following to try to
install it as a service:

pg_autovacuum.exe -I -N os_user -W os_pword -U db_user -p 15432 -L my_log

It fails to show up in the services list. The log file shows:

ERROR: The account name is invalid or does not exist, or the password is
invalid for the account name specified.

The OS account name and password ARE correct however. In fact they are
the same OS account name and password that Postgres is already running
under successfully as a windows service on the same machine.

Note that if I instead run pg_autovacuum from the command line, not as a
service, then it works fine:

pg_autovacuum.exe -U db_user -p 15432 -L my_log

Any ideas? Thanks in advance.

Steve McWilliams




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

Reply With Quote
  #2  
Old   
Steve McWilliams
 
Posts: n/a

Default Re: [BUGS] pg_autovacuum fails to run as a windows service (beta4) - 12-10-2004 , 05:47 PM






Yes, when I register pg_autovacuum.exe I am logged in with admin
privileges. The account I am specifying pg_autovacuum.exe to run under
however is a non-admin account with "logon as service" privileges on
windows xp pro.

Quote:
Just a quick guess, the user account that you are logged in as while
attempting to install the service, is it an admin account that has the
required privileges?

Steve McWilliams wrote:

I am unable to run pg_autovacuum as a windows service. I am using
8.0.0beta4 on Windows XP Pro. When I execute the following to try to
install it as a service:

pg_autovacuum.exe -I -N os_user -W os_pword -U db_user -p 15432 -L
my_log

It fails to show up in the services list. The log file shows:

ERROR: The account name is invalid or does not exist, or the password
is invalid for the account name specified.

The OS account name and password ARE correct however. In fact they are
the same OS account name and password that Postgres is already running
under successfully as a windows service on the same machine.

Note that if I instead run pg_autovacuum from the command line, not as
a service, then it works fine:

pg_autovacuum.exe -U db_user -p 15432 -L my_log

Any ideas? Thanks in advance.

Steve McWilliams




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




--
Matthew O'Connor
V.P. of Operations
Terrie O'Connor Realtors
201-934-4900 x27

Steve McWilliams
Software Engineer
Emprisa Networks
703-691-0433x21
smcwilliams (AT) emprisanetworks (DOT) com

The information contained in this communication is intended only for the
use of the recipient named above, and may be legally privileged,
confidential and exempt from disclosure under applicable law. If the
reader of this communication is not the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication, or any of its contents, is strictly prohibited. If you have
received this communication in error, please resend this communication to
the sender and delete the original communication and any copy of it from
your computer system. Thank you.



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Reply With Quote
  #3  
Old   
Matthew T. O'Connor
 
Posts: n/a

Default Re: [BUGS] pg_autovacuum fails to run as a windows service (beta4) - 12-10-2004 , 06:06 PM



Just a quick guess, the user account that you are logged in as while
attempting to install the service, is it an admin account that has the
required privileges?


Steve McWilliams wrote:

Quote:
I am unable to run pg_autovacuum as a windows service. I am using
8.0.0beta4 on Windows XP Pro. When I execute the following to try to
install it as a service:

pg_autovacuum.exe -I -N os_user -W os_pword -U db_user -p 15432 -L my_log

It fails to show up in the services list. The log file shows:

ERROR: The account name is invalid or does not exist, or the password is
invalid for the account name specified.

The OS account name and password ARE correct however. In fact they are
the same OS account name and password that Postgres is already running
under successfully as a windows service on the same machine.

Note that if I instead run pg_autovacuum from the command line, not as a
service, then it works fine:

pg_autovacuum.exe -U db_user -p 15432 -L my_log

Any ideas? Thanks in advance.

Steve McWilliams




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



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


Reply With Quote
  #4  
Old   
Matthew T. O'Connor
 
Posts: n/a

Default Re: [BUGS] pg_autovacuum fails to run as a windows service (beta4) - 12-11-2004 , 11:56 AM



Just a quick guess, the user account that you are logged in as while
attempting to install the service, is it an admin account that has the
required privileges?

Steve McWilliams wrote:

Quote:
I am unable to run pg_autovacuum as a windows service. I am using
8.0.0beta4 on Windows XP Pro. When I execute the following to try to
install it as a service:

pg_autovacuum.exe -I -N os_user -W os_pword -U db_user -p 15432 -L my_log

It fails to show up in the services list. The log file shows:

ERROR: The account name is invalid or does not exist, or the password is
invalid for the account name specified.

The OS account name and password ARE correct however. In fact they are
the same OS account name and password that Postgres is already running
under successfully as a windows service on the same machine.

Note that if I instead run pg_autovacuum from the command line, not as a
service, then it works fine:

pg_autovacuum.exe -U db_user -p 15432 -L my_log

Any ideas? Thanks in advance.

Steve McWilliams




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



--
Matthew O'Connor
V.P. of Operations
Terrie O'Connor Realtors
201-934-4900 x27


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

http://archives.postgresql.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.