Обсуждение: Updated Cygwin Package: postgresql-7.4.2-1
New News:
=== ====
I have updated the version of PostgreSQL to 7.4.2-1. The tarballs should
be available on a Cygwin mirror near you shortly.
The following are the notable changes since the previous release:
o build against cygserver instead of cygipc
o upgrade to PostgreSQL 7.4.2
Old News:
=== ====
PostgreSQL is an open-source, Object-Relational DBMS. If interested,
see the PostgreSQL web site for more details:
http://www.postgresql.org/
Please read the README file:
/usr/share/doc/Cygwin/postgresql-7.4.2.README
since it covers requirements, installation, known issues, etc.
To update your installation, click on the "Install Cygwin now" link on
the http://cygwin.com/ web page. This downloads setup.exe to your
system. Then, run setup and answer all of the questions.
Note that we have recently stopped downloads from sources.redhat.com
(aka cygwin.com) due to bandwidth limitations. This means that you will
need to find a mirror which has this update.
In the US,
ftp://mirrors.rcn.net/mirrors/sources.redhat.com/cygwin/
is a reliable high bandwidth connection.
In Germany,
ftp://ftp.uni-erlangen.de/pub/pc/gnuwin32/cygwin/mirrors/cygnus/
is usually pretty good.
In the UK,
http://programming.ccp14.ac.uk/ftp-mirror/programming/cygwin/pub/cygwin/
is usually up-to-date within 48 hours.
If one of the above doesn't have the latest version of this package
then you can either wait for the site to be updated or find another
mirror.
The setup.exe program will figure out what needs to be updated on your
system and will install newer packages automatically.
If you have questions or comments, please send them to the Cygwin
mailing list at: cygwin@cygwin.com . I would appreciate if you would
use this mailing list rather than emailing me directly. This includes
ideas and comments about the setup utility or Cygwin in general.
If you want to make a point or ask a question, the Cygwin mailing list
is the appropriate place.
*** CYGWIN-ANNOUNCE UNSUBSCRIBE INFO ***
If you want to unsubscribe from the cygwin-announce mailing list, look
at the "List-Unsubscribe: " tag in the email header of this message.
Send email to the address specified there. It will be in the format:
cygwin-announce-unsubscribe-you=yourdomain.com@cygwin.com
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
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@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of David P. Lurie
Sent: zondag 13 juni 2004 23:37
To: pgsql-cygwin@postgresql.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@postgresql.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-3config 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 changedback. 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@postgresql.org > [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of David P. Lurie > Sent: zondag 13 juni 2004 23:37 > To: pgsql-cygwin@postgresql.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@postgresql.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 readmethe 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@tishler.net> wrote in message news:20040615110304.GA2432@tishler.net... > 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@tishler.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