Re: [GENERAL] PosgreSQL Service does not Start In Vista
Inigo Barandiaran, 03.09.2009 14:47: Finally, I installed posgre database out of "program Files" as Thomas suggested and I gave full privileges to posgre user to data folder and everything works correctly :) Do you know how can I install posgre in "program Files" in Vista?. I might some users of my application would like to install it in "porgram Files" folder :(. How can I Solve this problem? You _can_ install it into "Program Files", just don't put the *data directory* there. I don't remember the individual steps of the installer wizard, but I'm sure there was a point where you could choose to run initdb and specify a location for the datadir. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PosgreSQL Service does not Start In Vista
Hi. I've tried to install postgree in Vista in program files and the service does not start. I gave manually full privileges to the posgre user to data folder, and still the service does not start. Finally, I installed posgre database out of "program Files" as Thomas suggested and I gave full privileges to posgre user to data folder and everything works correctly :) Do you know how can I install posgre in "program Files" in Vista?. I might some users of my application would like to install it in "porgram Files" folder :(. How can I Solve this problem? Thanks in advance!!! Thomas Kellerer wrote: > > Inigo Barandiaran, 02.09.2009 14:53: >> Thanks Thomas!. >> That sounds very interesting. How can I set privileges for writing in >> data >> directory for the postgres user account?. > Right click on the directory and choose "Security". Anything after that is > off-topic in this list ;) > > >> Or is it very to directly install >> posgreSQL out of "Program Files" Directory? > > Putting application data into "Program Files" is a very bad idea in > general, not only for Postgres. > I'm not sure if the current installer still suggests this, but this was a > major flaw in the installers I have used before. The installer does offer > the possibility to change this, but how many people really take the time > to read the wizard pages? > > Thomas > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/PosgreSQL-Service-does-not-Start-In-Vista-tp25255182p25275277.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PosgreSQL Service does not Start In Vista
Thanks Thomas! Your help is very appreciated :) I'm going to test what you suggest. Thanks again! Thomas Kellerer wrote: > > Inigo Barandiaran, 02.09.2009 14:53: >> Thanks Thomas!. >> That sounds very interesting. How can I set privileges for writing in >> data >> directory for the postgres user account?. > Right click on the directory and choose "Security". Anything after that is > off-topic in this list ;) > > >> Or is it very to directly install >> posgreSQL out of "Program Files" Directory? > > Putting application data into "Program Files" is a very bad idea in > general, not only for Postgres. > I'm not sure if the current installer still suggests this, but this was a > major flaw in the installers I have used before. The installer does offer > the possibility to change this, but how many people really take the time > to read the wizard pages? > > Thomas > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/PosgreSQL-Service-does-not-Start-In-Vista-tp25255182p25260223.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PosgreSQL Service does not Start In Vista
Inigo Barandiaran, 02.09.2009 14:53: Thanks Thomas!. That sounds very interesting. How can I set privileges for writing in data directory for the postgres user account?. Right click on the directory and choose "Security". Anything after that is off-topic in this list ;) Or is it very to directly install posgreSQL out of "Program Files" Directory? Putting application data into "Program Files" is a very bad idea in general, not only for Postgres. I'm not sure if the current installer still suggests this, but this was a major flaw in the installers I have used before. The installer does offer the possibility to change this, but how many people really take the time to read the wizard pages? Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PosgreSQL Service does not Start In Vista
Thanks Thomas!. That sounds very interesting. How can I set privileges for writing in data directory for the postgres user account?. Or is it very to directly install posgreSQL out of "Program Files" Directory? Thanks in advance! I've check Thomas Kellerer wrote: > > Inigo Barandiaran, 02.09.2009 12:39: >> We have included PostgreSQL 8.3(exe) installation in the installation >> process of our software, and we are experimenting some errors, mainly >> related with Windows Vista. The problem is that the installation of >> PosgreSQL seems to be correct, but the service is not started afterwards. >> I >> tried to start it manually but takes a lot of time and finally a windows >> error appears telling that "the PostgreSQL Database server 8.3 service on >> Local Computer Started and then stopped. Some services stop automatically >> if >> they have no work to do" > > Most probably it is a problem with the access privileges for the data > directory. Make sure the postgres service account has full write > privileges on the data directory. > > If your data directory is located in "Program Files" this is not a > surprise because that directory is write protected for regular users (for > a good reason) > > Thomas > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/PosgreSQL-Service-does-not-Start-In-Vista-tp25255182p25256915.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PosgreSQL Service does not Start In Vista
Inigo Barandiaran, 02.09.2009 12:39: We have included PostgreSQL 8.3(exe) installation in the installation process of our software, and we are experimenting some errors, mainly related with Windows Vista. The problem is that the installation of PosgreSQL seems to be correct, but the service is not started afterwards. I tried to start it manually but takes a lot of time and finally a windows error appears telling that "the PostgreSQL Database server 8.3 service on Local Computer Started and then stopped. Some services stop automatically if they have no work to do" Most probably it is a problem with the access privileges for the data directory. Make sure the postgres service account has full write privileges on the data directory. If your data directory is located in "Program Files" this is not a surprise because that directory is write protected for regular users (for a good reason) Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PosgreSQL Service does not Start In Vista
Thanks Raymond. Where can I find that log? I took a look in the bin folder where the service, and there is no log there. Thanks in advance! On 02/09/2009 11:39, Inigo Barandiaran wrote: PosgreSQL seems to be correct, but the service is not started afterwards. I tried to start it manually but takes a lot of time and finally a windows error appears telling that "the PostgreSQL Database server 8.3 service on Local Computer Started and then stopped. Some services stop automatically if they have no work to do" There should be more detail in the Postgres logs - have a look there and see what it says. Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals --
Re: [GENERAL] PosgreSQL Service does not Start In Vista
Sorry, I've just found it in: data\pg_log I'm going to take a look. Thanks again :) Inigo Barandiaran wrote: > > Thanks Raymond. > > Where can I find that log? > I took a look in the bin folder where the service, and there is no log > there. > > Thanks in advance! > > > Raymond O'Donnell wrote: >> >> On 02/09/2009 11:39, Inigo Barandiaran wrote: >>> PosgreSQL seems to be correct, but the service is not started >>> afterwards. I >>> tried to start it manually but takes a lot of time and finally a windows >>> error appears telling that "the PostgreSQL Database server 8.3 service >>> on >>> Local Computer Started and then stopped. Some services stop >>> automatically if >>> they have no work to do" >> >> There should be more detail in the Postgres logs - have a look there and >> see what it says. >> >> Ray. >> >> -- >> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland >> r...@iol.ie >> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals >> -- >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> >> > > -- View this message in context: http://www.nabble.com/PosgreSQL-Service-does-not-Start-In-Vista-tp25255182p25255321.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PosgreSQL Service does not Start In Vista
Thanks Raymond. Where can I find that log? I took a look in the bin folder where the service, and there is no log there. Thanks in advance! Raymond O'Donnell wrote: > > On 02/09/2009 11:39, Inigo Barandiaran wrote: >> PosgreSQL seems to be correct, but the service is not started afterwards. >> I >> tried to start it manually but takes a lot of time and finally a windows >> error appears telling that "the PostgreSQL Database server 8.3 service on >> Local Computer Started and then stopped. Some services stop automatically >> if >> they have no work to do" > > There should be more detail in the Postgres logs - have a look there and > see what it says. > > Ray. > > -- > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > r...@iol.ie > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > -- > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/PosgreSQL-Service-does-not-Start-In-Vista-tp25255182p25255298.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PosgreSQL Service does not Start In Vista
On 02/09/2009 11:39, Inigo Barandiaran wrote: > PosgreSQL seems to be correct, but the service is not started afterwards. I > tried to start it manually but takes a lot of time and finally a windows > error appears telling that "the PostgreSQL Database server 8.3 service on > Local Computer Started and then stopped. Some services stop automatically if > they have no work to do" There should be more detail in the Postgres logs - have a look there and see what it says. Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
