Re: [postgis-users] PostGIS Installation error using Stackbuilder
Regina, I wanted to put put there the solution that I found to my problem: I changed my the password for the postgres user in pgadmin III to one that did not have any special characters in it, specifically, no % sign. After this, I ran the PostGIS installer again, and it completed with no problems at all. You may want to add this to your todo list as well. Thanks for at least pointing me in the right direction regarding special characters. Russell On Fri, Jun 15, 2012 at 3:03 AM, Paragon Corporation l...@pcorp.us wrote: ** Does your password have apostrophes in it? I think there is an issue with ' and possibly spaces as well in passwords that is on our todo to fix. One work around is change your pg_hba.conf temporarily to trust for localhost, reload or restart the service and then change it back to md5 when you are done installing. Aside from that only thing I can think of is you are not installing on the one you think you are. This happens if you have multiple installations of PostgreSQL on different ports with different postgres super user passwords. Hope that helps, Regina http://www.postgis.us -- *From:* postgis-users-boun...@postgis.refractions.net [mailto: postgis-users-boun...@postgis.refractions.net] *On Behalf Of *Russell Mercer *Sent:* Thursday, June 14, 2012 10:20 PM *To:* postgis-users@postgis.refractions.net *Subject:* [postgis-users] PostGIS Installation error using Stackbuilder I am trying to install PostGIS on Postgresql 9.1 using the Stackbuilder program. Postgresql 9.1 was installed using the 1 click installer from EnterpriseDB. Postgres installed completely, so I initiated the install for PostGIS. I selected PostGIS 2.0, entered my password for the postgres user at the prompt and started the install. The install made it almost to the end, and failed with the following error: createdb: could not connect to database postgres: FATAL: password authentication failed for user postgres I was concerned that I entered the wrong password at the prompt, so I opened up pgAdmin III to test. I was able to log in using the postgres user name and the password with no issues. I then tried to install PostGIS 1.5.3, with the same password fail result. Can anyone give me some insight into what I am doing wrong? I am installing onto a server with Windows Server 2008 Service Pack 2. Thanks, Russell ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Installation error using Stackbuilder
Does your password have apostrophes in it? I think there is an issue with ' and possibly spaces as well in passwords that is on our todo to fix. One work around is change your pg_hba.conf temporarily to trust for localhost, reload or restart the service and then change it back to md5 when you are done installing. Aside from that only thing I can think of is you are not installing on the one you think you are. This happens if you have multiple installations of PostgreSQL on different ports with different postgres super user passwords. Hope that helps, Regina http://www.postgis.us _ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Russell Mercer Sent: Thursday, June 14, 2012 10:20 PM To: postgis-users@postgis.refractions.net Subject: [postgis-users] PostGIS Installation error using Stackbuilder I am trying to install PostGIS on Postgresql 9.1 using the Stackbuilder program. Postgresql 9.1 was installed using the 1 click installer from EnterpriseDB. Postgres installed completely, so I initiated the install for PostGIS. I selected PostGIS 2.0, entered my password for the postgres user at the prompt and started the install. The install made it almost to the end, and failed with the following error: createdb: could not connect to database postgres: FATAL: password authentication failed for user postgres I was concerned that I entered the wrong password at the prompt, so I opened up pgAdmin III to test. I was able to log in using the postgres user name and the password with no issues. I then tried to install PostGIS 1.5.3, with the same password fail result. Can anyone give me some insight into what I am doing wrong? I am installing onto a server with Windows Server 2008 Service Pack 2. Thanks, Russell ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Installation error using Stackbuilder
Regina, Thanks for the response. Having just installed PostgreSQL at the same time, I know that there are not multiple installations, so I don't think that is the culprit. I think it may be a password issue. I don't have either of the characters you mentioned, however, have you done any testing with a password containing the percent (%) symbol? I am not in the office today to test it, but on Monday I will try the workaround. Thanks again! Russell On Fri, Jun 15, 2012 at 3:03 AM, Paragon Corporation l...@pcorp.us wrote: ** Does your password have apostrophes in it? I think there is an issue with ' and possibly spaces as well in passwords that is on our todo to fix. One work around is change your pg_hba.conf temporarily to trust for localhost, reload or restart the service and then change it back to md5 when you are done installing. Aside from that only thing I can think of is you are not installing on the one you think you are. This happens if you have multiple installations of PostgreSQL on different ports with different postgres super user passwords. Hope that helps, Regina http://www.postgis.us -- *From:* postgis-users-boun...@postgis.refractions.net [mailto: postgis-users-boun...@postgis.refractions.net] *On Behalf Of *Russell Mercer *Sent:* Thursday, June 14, 2012 10:20 PM *To:* postgis-users@postgis.refractions.net *Subject:* [postgis-users] PostGIS Installation error using Stackbuilder I am trying to install PostGIS on Postgresql 9.1 using the Stackbuilder program. Postgresql 9.1 was installed using the 1 click installer from EnterpriseDB. Postgres installed completely, so I initiated the install for PostGIS. I selected PostGIS 2.0, entered my password for the postgres user at the prompt and started the install. The install made it almost to the end, and failed with the following error: createdb: could not connect to database postgres: FATAL: password authentication failed for user postgres I was concerned that I entered the wrong password at the prompt, so I opened up pgAdmin III to test. I was able to log in using the postgres user name and the password with no issues. I then tried to install PostGIS 1.5.3, with the same password fail result. Can anyone give me some insight into what I am doing wrong? I am installing onto a server with Windows Server 2008 Service Pack 2. Thanks, Russell ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Installation error using Stackbuilder
Good morning Russell: I've had several password authentication problems on Windows (XP though, not Server 08) specifically when connecting via command line. I worked around it by creating a Windows user account with the same name and password as my role on the Robert E. Clift 850.245. ext 2471 From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Russell Mercer Sent: Thursday, June 14, 2012 10:20 PM To: postgis-users@postgis.refractions.net Subject: [postgis-users] PostGIS Installation error using Stackbuilder I am trying to install PostGIS on Postgresql 9.1 using the Stackbuilder program. Postgresql 9.1 was installed using the 1 click installer from EnterpriseDB. Postgres installed completely, so I initiated the install for PostGIS. I selected PostGIS 2.0, entered my password for the postgres user at the prompt and started the install. The install made it almost to the end, and failed with the following error: createdb: could not connect to database postgres: FATAL: password authentication failed for user postgres I was concerned that I entered the wrong password at the prompt, so I opened up pgAdmin III to test. I was able to log in using the postgres user name and the password with no issues. I then tried to install PostGIS 1.5.3, with the same password fail result. Can anyone give me some insight into what I am doing wrong? I am installing onto a server with Windows Server 2008 Service Pack 2. Thanks, Russell ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Installation error using Stackbuilder
(NOTE: apparently Ctrl + Enter sends an outlook message -- woops) Good morning Russell: I've had several password authentication problems on Windows (XP though, not Server 08) specifically when connecting via command line. I worked around it by creating a Windows user account with the same name and password as my role on the DB. As a disclaimer, I'm in a sandbox so I've never considered potentially negative unintended consequences. -Rob From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Russell Mercer Sent: Thursday, June 14, 2012 10:20 PM To: postgis-users@postgis.refractions.net Subject: [postgis-users] PostGIS Installation error using Stackbuilder I am trying to install PostGIS on Postgresql 9.1 using the Stackbuilder program. Postgresql 9.1 was installed using the 1 click installer from EnterpriseDB. Postgres installed completely, so I initiated the install for PostGIS. I selected PostGIS 2.0, entered my password for the postgres user at the prompt and started the install. The install made it almost to the end, and failed with the following error: createdb: could not connect to database postgres: FATAL: password authentication failed for user postgres I was concerned that I entered the wrong password at the prompt, so I opened up pgAdmin III to test. I was able to log in using the postgres user name and the password with no issues. I then tried to install PostGIS 1.5.3, with the same password fail result. Can anyone give me some insight into what I am doing wrong? I am installing onto a server with Windows Server 2008 Service Pack 2. Thanks, Russell ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users