Hi
I've already tried yesterday to switch the service from the postgres
acount to the local acount but the result was the same. I'll check
again also your solution and get back.
Lucian
On Fri, Apr 6, 2012 at 2:21 AM, iihero wrote:
> When you install PG as a service, the default service account
According to what I can see from this defect that it is not confirmed
whether the Postgre server is started or not properly.
You can try on confirming about the following 2 points:
1. How many postgres processes you are able to see in your task manager.
This can give hint whether appropriate postg
On Thu, Apr 5, 2012 at 8:14 AM, Terrance Chen wrote:
> system=fedora15
> software env=all software in DVD are completely installed(include pgsql
> psql) and some thing like pppoe
> postgresql are install with fedora by default option,
> /etc/passwd/:postgres PostgreSQL
> Server:/var
When you install PG as a service, the default service account is "postgres".
But when you run cmd line: pg_ctl status
It's running under your current user account other than "postgres".
Could you run:
runas /user:postgres cmd
Then in the new command window: pg_ctl status
--
--
You've used : su - root
Before this, you possibly need populate some environment variables from your
postgre user.
--
--
iihero(Xiong He) http://www.sql9.com
--
--
system=fedora15
software env=all software in DVD are completely installed(include pgsql psql)
and some thing like pppoe
postgresql are install with fedora by default option,
/etc/passwd/: postgres PostgreSQL Server:/var/lib/pgsql:/bin/bash
operations:
su - postgres
initdb -D /var
Dropping the BEGIN has cleared up the issue. Thank you.
On 4/3/2012 9:50 AM, John R Pierce wrote:
On 04/03/12 9:40 AM, Tom Lane wrote:
Alex Matzinger writes:
> The connection that is executing the SELECT 1 are generally open
for 1-5
> hours before they are killed. The specific connection
Hi
I have a Postgresql 9.1.2 installed on a Windows 7 machine and noticed
the following thing:
- I start the postgresql by windows service ( on default port )
- when I run pg_ctl -D on the same data directory the response is "no
server running" even the server is in fact running already
- if I tr
