pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
run postgres.exe as a Windows Administrative account
3+ messages / 2 participants
[nested] [flat]

* run postgres.exe as a Windows Administrative account
@ 2007-08-24 00:34  Yingqi Tang <anakintang@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Yingqi Tang @ 2007-08-24 00:34 UTC (permalink / raw)
  To: pgsql-admin

All,

I am new to postgreSQL and the first time I tried to execute
postgres.exe I got an error saying the services must be started as a
non-administrative windows user. But I checked the doc and it says
after 8.2 it is possible to run postgres.exe as a windows
administrator. So a little bit confused, is it possible, if so, how?

Thanks a lot for help!



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* run postgres.exe as a Windows Administrative account
@ 2007-08-24 00:38  Yingqi Tang <anakintang@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Yingqi Tang @ 2007-08-24 00:38 UTC (permalink / raw)
  To: pgsql-admin

All,

I am new to postgreSQL and the first time I tried to execute
postgres.exe I got an error saying the services must be started as a
non-administrative windows user. But I checked the doc and it says
after 8.2 it is possible to run postgres.exe as a windows
administrator. So a little bit confused, is it possible, if so, how?

Thanks a lot for help!



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: run postgres.exe as a Windows Administrative account
@ 2007-08-24 01:45  Andreas <maps.on@gmx.net>
  parent: Yingqi Tang <anakintang@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Andreas @ 2007-08-24 01:45 UTC (permalink / raw)
  To: Yingqi Tang <anakintang@gmail.com>; +Cc: pgsql-admin

Hi,
don't confuse the user who initiates the starting process of the DB 
(double click on the icon) with the one the DB runs under.

As far as I know, there should be an unprivileged user e.g. "postgres".
"administrator" starts postmaster in the unprivileged context of 
"postgres" when you start it manually while being logged in as 
"administrator" or when the service gets automatically started at boot time.

At least this is how an PG 8.2.4 runs here.


Yingqi Tang schrieb:
> I am new to postgreSQL and the first time I tried to execute
> postgres.exe I got an error saying the services must be started as a
> non-administrative windows user. But I checked the doc and it says
> after 8.2 it is possible to run postgres.exe as a windows
> administrator.
>   




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-08-24 01:45 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-24 00:34 run postgres.exe as a Windows Administrative account Yingqi Tang <anakintang@gmail.com>
2007-08-24 00:38 run postgres.exe as a Windows Administrative account Yingqi Tang <anakintang@gmail.com>
2007-08-24 01:45 ` Andreas <maps.on@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox