Re: Updated Cygwin Package: postgresql-7.4.2-1

When installing as service, do you install it with postgres account? Or do you let it run with SYSTEM account?

--Tim

-----Original Message-----
From: pgsql-cygwin-owner(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org]On Behalf Of David P. Lurie
Sent: zondag 13 juni 2004 23:37
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] Updated Cygwin Package: postgresql-7.4.2-1

Jason -

> 3. Cygwin PostgreSQL can fail to start or not function properly if
> certain files and directories have incorrect permissions. The
> following usually solves these kinds of problems:
>
> $ chmod a+rwx /tmp
> $ chmod a+rx /usr/bin /usr/bin/*
> $ chmod a+rw /var/log # could adversely affect other daemons
>
> In particular, note the third chmod above.
>

I tried all three, without any success.

There was another problem with postgresql configuration that I hadn't
mentioned. initdb failed when run as the user "postgres", but completed
successfully under my usual login.

These permission changes now allow initdb to run from the "postgres"
account. postmaster still successfully installs as a service, but fails to
run, whether installed to run under my usual login or "postgres" (after
initdb has been run under the appropriate account).

David

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Hi,

I am having the same problems on XP Pro. I get a signal 12 selecting default max conections.

I looked at the postmaster.conf file created by initdb and noticed that the default connection max is set a 10. On my 7.4.1-3 config file it is set at 100.

I have seen 10 mentioned before, maybe in running postgres regression tests after compiling. Perhaps it needs to be changed back.

Mike

On Mon, Jun 14, 2004 at 12:15:43PM +0200, Leeuw van der, Tim wrote:
> When installing as service, do you install it with postgres account? Or do you let it run with SYSTEM account?
>
> --Tim
>
> -----Original Message-----
> From: pgsql-cygwin-owner(at)postgresql(dot)org
> [mailto:pgsql-cygwin-owner(at)postgresql(dot)org]On Behalf Of David P. Lurie
> Sent: zondag 13 juni 2004 23:37
> To: pgsql-cygwin(at)postgresql(dot)org
> Subject: Re: [CYGWIN] Updated Cygwin Package: postgresql-7.4.2-1
>
>
> Jason -
>
> > 3. Cygwin PostgreSQL can fail to start or not function properly if
> > certain files and directories have incorrect permissions. The
> > following usually solves these kinds of problems:
> >
> > $ chmod a+rwx /tmp
> > $ chmod a+rx /usr/bin /usr/bin/*
> > $ chmod a+rw /var/log # could adversely affect other daemons
> >
> > In particular, note the third chmod above.
> >
>
> I tried all three, without any success.
>
> There was another problem with postgresql configuration that I hadn't
> mentioned. initdb failed when run as the user "postgres", but completed
> successfully under my usual login.
>
> These permission changes now allow initdb to run from the "postgres"
> account. postmaster still successfully installs as a service, but fails to
> run, whether installed to run under my usual login or "postgres" (after
> initdb has been run under the appropriate account).
>
> David
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Mike,

On Mon, Jun 14, 2004 at 03:27:32PM -0500, Mike G wrote:
> I am having the same problems on XP Pro. I get a signal 12 selecting
> default max conections.

Are you running cygserver as per the README?

Regardless of the installation type, the first step is to add
"server" to your CYGWIN environment variable setting and start
cygserver. See the cygserver README:

/usr/share/doc/cygwin/cygserver.README

for more details. If the CYGWIN variable is not set correctly
and/or cygserver is not running then initdb and postmaster will fail
to run properly.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

grrrrrr was but not with the environment set correctly.

Started over but now initd complains about not finding /usr/bin/postgres when initializing pg_shadow.

I will try all the chmod again....

On Mon, Jun 14, 2004 at 10:04:15PM -0400, Jason Tishler wrote:
> Mike,
>
> On Mon, Jun 14, 2004 at 03:27:32PM -0500, Mike G wrote:
> > I am having the same problems on XP Pro. I get a signal 12 selecting
> > default max conections.
>
> Are you running cygserver as per the README?
>
> Regardless of the installation type, the first step is to add
> "server" to your CYGWIN environment variable setting and start
> cygserver. See the cygserver README:
>
> /usr/share/doc/cygwin/cygserver.README
>
> for more details. If the CYGWIN variable is not set correctly
> and/or cygserver is not running then initdb and postmaster will fail
> to run properly.
>
> Jason
>
> --
> PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
> Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

Miracles never cease!!!! Running under postgres account.

I created the postgres account using control panel->users->advanced instead of what is in the readme. If I follow the readme the postgres account is never truly created for me in windows(can't actually log in under that name using the pc name / local domain). Perhaps that only works if you can create domain accounts and not just local system accounts?

Thanks for the help as usual Jason.

On Mon, Jun 14, 2004 at 11:06:05PM -0500, Mike G wrote:
> grrrrrr was but not with the environment set correctly.
>
> Started over but now initd complains about not finding /usr/bin/postgres when initializing pg_shadow.
>
> I will try all the chmod again....
>
> On Mon, Jun 14, 2004 at 10:04:15PM -0400, Jason Tishler wrote:
> > Mike,
> >
> > On Mon, Jun 14, 2004 at 03:27:32PM -0500, Mike G wrote:
> > > I am having the same problems on XP Pro. I get a signal 12 selecting
> > > default max conections.
> >
> > Are you running cygserver as per the README?
> >
> > Regardless of the installation type, the first step is to add
> > "server" to your CYGWIN environment variable setting and start
> > cygserver. See the cygserver README:
> >
> > /usr/share/doc/cygwin/cygserver.README
> >
> > for more details. If the CYGWIN variable is not set correctly
> > and/or cygserver is not running then initdb and postmaster will fail
> > to run properly.
> >
> > Jason
> >
> > --
> > PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
> > Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

Mike,

On Mon, Jun 14, 2004 at 11:15:49PM -0500, Mike G wrote:
> I created the postgres account using control panel->users->advanced
> instead of what is in the readme.

The two methods should be equivalent with the later just being easier to
document.

> If I follow the readme the postgres account is never truly created for
> me in windows(can't actually log in under that name using the pc name
> / local domain).

Hmm...

> Perhaps that only works if you can create domain accounts and not just
> local system accounts?

No.

> Thanks for the help as usual Jason.

You are quite welcome.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

"Jason Tishler" <jason(at)tishler(dot)net> wrote in message
news:20040615110304(dot)GA2432(at)tishler(dot)net(dot)(dot)(dot)
> On Mon, Jun 14, 2004 at 11:15:49PM -0500, Mike G wrote:
> > I created the postgres account using control panel->users->advanced
> > instead of what is in the readme.
>
> The two methods should be equivalent with the later just being easier to
> document.
>
> > If I follow the readme the postgres account is never truly created for
> > me in windows(can't actually log in under that name using the pc name
> > / local domain).
>

I had to tweak the README instructions, primarily adding quotes when needed.
Some of my changes may have been redundant:

Original:

net user postgres $password /add /fullname:postgres /comment:'PostgreSQL
user account' /homedir:"$(cygpath -w /home/postgres)"

Where $password is your new password and $(cygpath ...) is the path to
/home/postgres on your system as output in Windows format by the cygpath
utility.

New:

mkdir -p /home/postgres

chown postgres /home/postgres

net user postgres $password /add /fullname:"postgres "
/homedir:"C:\cygwin\home\postgres"

David

David,

On Wed, Jun 16, 2004 at 11:29:03AM -0400, David P. Lurie wrote:
> "Jason Tishler" <jason(at)tishler(dot)net> wrote in message
> > The two methods should be equivalent with the later just being
> > easier to document.
>
> I had to tweak the README instructions, primarily adding quotes when
> needed. Some of my changes may have been redundant:
>
> Original:
>
> net user postgres $password /add /fullname:postgres /comment:'PostgreSQL
> user account' /homedir:"$(cygpath -w /home/postgres)"

The above will only work under a Unix shell (e.g., bash) -- not under
cmd. I guess that I should update the README to be clear...

> New:
>
> mkdir -p /home/postgres
>
> chown postgres /home/postgres

The above should not be necessary, albeit convenient if one logs in as
postgres frequently.

> net user postgres $password /add /fullname:"postgres "
> /homedir:"C:\cygwin\home\postgres"

See above.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

> >
> > net user postgres $password /add /fullname:postgres /comment:'PostgreSQL
> > user account' /homedir:"$(cygpath -w /home/postgres)"
>
> The above will only work under a Unix shell (e.g., bash) -- not under
> cmd. I guess that I should update the README to be clear...
>
Oh, that would explain my difficulties with it.

Mike
> Jason
>
> --
> PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
> Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match