pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem starting up PostgreSQL 8.0 database service in Windows 2003 server
3+ messages / 2 participants
[nested] [flat]
* Problem starting up PostgreSQL 8.0 database service in Windows 2003 server
@ 2006-12-07 16:55 ron <bragustin@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: ron @ 2006-12-07 16:55 UTC (permalink / raw)
To: pgsql-admin
Please kindly help me with this problem I am experiencing with starting up a
PostgreSQL 8.0 db service in a Windows 2003 server.
Whenever I attempt to restart the service I always get the message: "The
PostgreSQL Database Server 8.0 on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for example,
the Performance Logs and Alerts service."
I tried running postgres in command line with:
c:\...\PostgreSQL\8.0\bin\postgres - D:\Progra...\PostgreSQL\8.0\data
template1 gives me:
"Execution of PostgreSQL by a user with administrative permissions is not
permitted. The server must be started under an unprivileged user ID
to prevent possible system security compromises. ..."
Need badly your help in dealing with this one.
Many thanks in advance.
--
R. Agustin
- - - - - - - - - - - - - - - - - - - - - - - - - -
E-mail: bragustin@gmail.com
ICQ #: 146807041
_______________________________________
This email contains confidential information for the sole use of the
intended
recipient/s. If you are not the intended recipient, please contact
the sender, delete this email and maintain the confidentiality of what
you may have read.
"It is a capital mistake to theorize before one has data."
- Sherlock Holmes
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problem starting up PostgreSQL 8.0 database service in Windows 2003 server
@ 2006-12-07 17:14 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
parent: ron <bragustin@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Rajesh Kumar Mallah @ 2006-12-07 17:14 UTC (permalink / raw)
To: ron <bragustin@gmail.com>; +Cc: pgsql-admin
On 12/7/06, ron <bragustin@gmail.com> wrote:
> Please kindly help me with this problem I am experiencing with starting up a
> PostgreSQL 8.0 db service in a Windows 2003 server.
> Whenever I attempt to restart the service I always get the message: "The
> PostgreSQL Database Server 8.0 on Local Computer started and then stopped.
> Some services stop automatically if they have no work to do, for example,
> the Performance Logs and Alerts service."
>
> I tried running postgres in command line with:
> c:\...\PostgreSQL\8.0\bin\postgres -
> D:\Progra...\PostgreSQL\8.0\data template1 gives me:
> "Execution of PostgreSQL by a user with administrative permissions is not
> permitted. The server must be started under an unprivileged user ID
> to prevent possible system security compromises. ..."
Go to Control Panel --> users --> L ocate the user
you use to login. convert the account to a limited account.
OR
create a new user postgres and do not give administrative rights
while creating. Run postgres using that user.
I havent' run postgresql on windows yet so i cannot give very specific
instructions but i hope you got the point.
Regds
mallah
>
> Need badly your help in dealing with this one.
>
> Many thanks in advance.
>
>
>
> --
> R. Agustin
> - - - - - - - - - - - - - - - - - - - - - - - - - -
> E-mail: bragustin@gmail.com
> ICQ #: 146807041
> _______________________________________
> This email contains confidential information for the sole use of the
> intended
> recipient/s. If you are not the intended recipient, please contact
> the sender, delete this email and maintain the confidentiality of what
> you may have read.
>
> "It is a capital mistake to theorize before one has data."
> - Sherlock Holmes
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problem starting up PostgreSQL 8.0 database service in Windows 2003 server
@ 2006-12-08 07:36 ron <bragustin@gmail.com>
parent: ron <bragustin@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: ron @ 2006-12-08 07:36 UTC (permalink / raw)
To: pgsql-admin
Hi guys,
I appreciate much all your help on this one. The user account postgres which
I used to startup the PostgreSQL db service has been misgrouped in the
Administrators group. All things well now.
Many thanks!
ron
On 12/8/06, ron <bragustin@gmail.com> wrote:
>
> Please kindly help me with this problem I am experiencing with starting up
> a PostgreSQL 8.0 db service in a Windows 2003 server.
> Whenever I attempt to restart the service I always get the message: "The
> PostgreSQL Database Server 8.0 on Local Computer started and then
> stopped.
> Some services stop automatically if they have no work to do, for example,
> the Performance Logs and Alerts service."
>
> I tried running postgres in command line with:
> c:\...\PostgreSQL\8.0\bin\postgres - D:\Progra...\PostgreSQL\8.0\data
> template1 gives me:
> "Execution of PostgreSQL by a user with administrative permissions is not
> permitted. The server must be started under an unprivileged user ID
> to prevent possible system security compromises. ..."
>
> Need badly your help in dealing with this one.
>
> Many thanks in advance.
>
>
>
> --
> R. Agustin
> - - - - - - - - - - - - - - - - - - - - - - - - - -
> E-mail: bragustin@gmail.com
> ICQ #: 146807041
> _______________________________________
> This email contains confidential information for the sole use of the
> intended
> recipient/s. If you are not the intended recipient, please contact
> the sender, delete this email and maintain the confidentiality of what
> you may have read.
>
> "It is a capital mistake to theorize before one has data."
> - Sherlock Holmes
>
--
R. Agustin
- - - - - - - - - - - - - - - - - - - - - - - - - -
E-mail: bragustin@gmail.com
ICQ #: 146807041
_______________________________________
This email contains confidential information for the sole use of the
intended
recipient/s. If you are not the intended recipient, please contact
the sender, delete this email and maintain the confidentiality of what
you may have read.
"It is a capital mistake to theorize before one has data."
- Sherlock Holmes
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-12-08 07:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-07 16:55 Problem starting up PostgreSQL 8.0 database service in Windows 2003 server ron <bragustin@gmail.com>
2006-12-07 17:14 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2006-12-08 07:36 ` ron <bragustin@gmail.com>
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