pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPOSTGRES ISSUES
5+ messages / 5 participants
[nested] [flat]
* POSTGRES ISSUES
@ 2019-09-20 06:59 Myke Ndungu <mykendoch@gmail.com>
2019-09-22 11:21 ` Re: POSTGRES ISSUES Andreas Steinel <a.steinel@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Myke Ndungu @ 2019-09-20 06:59 UTC (permalink / raw)
To: pgadmin-support@postgresql.org
Hello there im in windows trying to install both postreSQL 11 a and Pgadmin
4 but without good progress.
im keeping on receiving an error "database cluster not initialized" have
used all the solutions eg
adding postgres in computer management and giving it full rights on the
security properties section in postgreSQL file folder though during
reinstallation its telling me to chose another directory to upgrade the
current application.
i also tried to install afresh postgres using the command prompt still not
yet
ALSO INCLUDED THE POSTGRES PATH IN THE ENVIRONMENT VARIABLE still not
working
Advise from there please
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: POSTGRES ISSUES
2019-09-20 06:59 POSTGRES ISSUES Myke Ndungu <mykendoch@gmail.com>
@ 2019-09-22 11:21 ` Andreas Steinel <a.steinel@gmail.com>
2019-09-22 14:26 ` Re: POSTGRES ISSUES Doug Easterbrook <doug@artsman.com>
0 siblings, 1 reply; 5+ messages in thread
From: Andreas Steinel @ 2019-09-22 11:21 UTC (permalink / raw)
To: Myke Ndungu <mykendoch@gmail.com>; +Cc: pgadmin-support@postgresql.org
Hi Myke,
On Fri, Sep 20, 2019 at 12:54 PM Myke Ndungu <mykendoch@gmail.com> wrote:
> Hello there im in windows trying to install both postreSQL 11 a and
> Pgadmin 4 but without good progress.
> im keeping on receiving an error "database cluster not initialized" have
> used all the solutions eg
> adding postgres in computer management and giving it full rights on the
> security properties section in postgreSQL file folder though during
> reinstallation its telling me to chose another directory to upgrade the
> current application.
> i also tried to install afresh postgres using the command prompt still not
> yet
> ALSO INCLUDED THE POSTGRES PATH IN THE ENVIRONMENT VARIABLE still not
> working
> Advise from there please
>
Yes, Windows and PostgreSQL are not the best friends and that's OK.
Why don't you just go down the Docker route and stop trying to use Windows
for PostgreSQL.
There is no easier method to get started with both than Docker.
--
With kind regards / Mit freundlichen Grüßen
Andreas Steinel
M.Sc. Visual Computing
M.Sc. Informatik
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: POSTGRES ISSUES
2019-09-20 06:59 POSTGRES ISSUES Myke Ndungu <mykendoch@gmail.com>
2019-09-22 11:21 ` Re: POSTGRES ISSUES Andreas Steinel <a.steinel@gmail.com>
@ 2019-09-22 14:26 ` Doug Easterbrook <doug@artsman.com>
2019-09-23 05:24 ` Re: POSTGRES ISSUES Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
2019-09-23 09:07 ` Re: POSTGRES ISSUES Milan Oparnica <milan.opa@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Doug Easterbrook @ 2019-09-22 14:26 UTC (permalink / raw)
To: Andreas Steinel <a.steinel@gmail.com>; +Cc: Myke Ndungu <mykendoch@gmail.com>; pgadmin-support@postgresql.org
I might just say that this advice is a little harsh.
I’ve never had any problem with enterprise DB’s Postgres installers for windows. if you have your machine generally up todate with latest patches and you are using 64 bit OS like win 2008 server, 2012 server 2016 server, 2019 server, win 81. or win 10 — it basically installs out the gate.
I’ve never fussed with it. I’ve ben buil my on installers around it .. The only parameters I give to the postgres install package are
--mode unattended --superpassword [myPassword] --servicepassword [myPassword]
and its hardly more stock than that. [myPassword]. is a password of my choosing. read about the parameters using —help as the installer parameters.
Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug@artsman.com
http://www.artsman.com
Phone (403) 650-1978
> On September 22, 2019, at 4:21 AM, Andreas Steinel <a.steinel@gmail.com> wrote:
>
> Hi Myke,
>
> On Fri, Sep 20, 2019 at 12:54 PM Myke Ndungu <mykendoch@gmail.com <mailto:mykendoch@gmail.com>> wrote:
> Hello there im in windows trying to install both postreSQL 11 a and Pgadmin 4 but without good progress.
> im keeping on receiving an error "database cluster not initialized" have used all the solutions eg
> adding postgres in computer management and giving it full rights on the security properties section in postgreSQL file folder though during reinstallation its telling me to chose another directory to upgrade the current application.
> i also tried to install afresh postgres using the command prompt still not yet
> ALSO INCLUDED THE POSTGRES PATH IN THE ENVIRONMENT VARIABLE still not working
> Advise from there please
>
> Yes, Windows and PostgreSQL are not the best friends and that's OK.
> Why don't you just go down the Docker route and stop trying to use Windows for PostgreSQL.
> There is no easier method to get started with both than Docker.
>
> --
> With kind regards / Mit freundlichen Grüßen
>
> Andreas Steinel
> M.Sc. Visual Computing
> M.Sc. Informatik
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: POSTGRES ISSUES
2019-09-20 06:59 POSTGRES ISSUES Myke Ndungu <mykendoch@gmail.com>
2019-09-22 11:21 ` Re: POSTGRES ISSUES Andreas Steinel <a.steinel@gmail.com>
2019-09-22 14:26 ` Re: POSTGRES ISSUES Doug Easterbrook <doug@artsman.com>
@ 2019-09-23 05:24 ` Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
1 sibling, 0 replies; 5+ messages in thread
From: Aditya Toshniwal @ 2019-09-23 05:24 UTC (permalink / raw)
To: Doug Easterbrook <doug@artsman.com>; pgsql-admin; +Cc: Andreas Steinel <a.steinel@gmail.com>; Myke Ndungu <mykendoch@gmail.com>
Myke,
Removing the postgres user altogether might work. Not sure of windows, but
I used to get that error on Mac and removing postgres user worked for me.
++pgsql-admin
On Sun, Sep 22, 2019 at 7:57 PM Doug Easterbrook <doug@artsman.com> wrote:
> I might just say that this advice is a little harsh.
>
> I’ve never had any problem with enterprise DB’s Postgres installers for
> windows. if you have your machine generally up todate with latest patches
> and you are using 64 bit OS like win 2008 server, 2012 server 2016 server,
> 2019 server, win 81. or win 10 — it basically installs out the gate.
>
> I’ve never fussed with it. I’ve ben buil my on installers around it
> .. The only parameters I give to the postgres install package are
>
> --mode unattended --superpassword [myPassword] --servicepassword
> [myPassword]
>
>
>
> and its hardly more stock than that. [myPassword]. is a password of my
> choosing. read about the parameters using —help as the installer
> parameters.
>
> *Doug Easterbrook*
> *Arts Management Systems Ltd.*
> mailto:doug@artsman.com <doug@artsman.com>
> http://www.artsman.com
> Phone (403) 650-1978
>
> On September 22, 2019, at 4:21 AM, Andreas Steinel <a.steinel@gmail.com>
> wrote:
>
> Hi Myke,
>
> On Fri, Sep 20, 2019 at 12:54 PM Myke Ndungu <mykendoch@gmail.com> wrote:
>
>> Hello there im in windows trying to install both postreSQL 11 a and
>> Pgadmin 4 but without good progress.
>> im keeping on receiving an error "database cluster not initialized" have
>> used all the solutions eg
>> adding postgres in computer management and giving it full rights on the
>> security properties section in postgreSQL file folder though during
>> reinstallation its telling me to chose another directory to upgrade the
>> current application.
>> i also tried to install afresh postgres using the command prompt still
>> not yet
>> ALSO INCLUDED THE POSTGRES PATH IN THE ENVIRONMENT VARIABLE still not
>> working
>> Advise from there please
>>
>
> Yes, Windows and PostgreSQL are not the best friends and that's OK.
> Why don't you just go down the Docker route and stop trying to use Windows
> for PostgreSQL.
> There is no easier method to get started with both than Docker.
>
> --
> With kind regards / Mit freundlichen Grüßen
>
> Andreas Steinel
> M.Sc. Visual Computing
> M.Sc. Informatik
>
>
>
--
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: POSTGRES ISSUES
2019-09-20 06:59 POSTGRES ISSUES Myke Ndungu <mykendoch@gmail.com>
2019-09-22 11:21 ` Re: POSTGRES ISSUES Andreas Steinel <a.steinel@gmail.com>
2019-09-22 14:26 ` Re: POSTGRES ISSUES Doug Easterbrook <doug@artsman.com>
@ 2019-09-23 09:07 ` Milan Oparnica <milan.opa@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Milan Oparnica @ 2019-09-23 09:07 UTC (permalink / raw)
To: pgadmin-support@lists.postgresql.org
I share experience with Duogh.
We've installed PostgreSQL on Windows almost as much as on Linux
(dozens) and had no issues on either OS.
I remember once having issue similar to yours, it happened while
upgrading Pg 10.1 to 10.4.
New installer wouldn't recognize the database in the previous folder.
Turned out to be some strange user permissions issue, which, by the way,
we couldn't solve. We allowed installer to create a new folder and
copied old data into. And that was it.
BR,
M.O.
On 22.9.19. 16:26, Doug Easterbrook wrote:
> I might just say that this advice is a little harsh.
>
> I’ve never had any problem with enterprise DB’s Postgres installers
> for windows. if you have your machine generally up todate with
> latest patches and you are using 64 bit OS like win 2008 server, 2012
> server 2016 server, 2019 server, win 81. or win 10 — it basically
> installs out the gate.
>
> I’ve never fussed with it. I’ve ben buil my on installers around
> it .. The only parameters I give to the postgres install package are
>
> --mode unattended --superpassword [myPassword] --servicepassword
> [myPassword]
>
>
>
> and its hardly more stock than that. [myPassword]. is a password of
> my choosing. read about the parameters using —help as the installer
> parameters.
> *
> **Doug Easterbrook*
> *Arts Management Systems Ltd.*
> mailto:doug@artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
>
>> On September 22, 2019, at 4:21 AM, Andreas Steinel
>> <a.steinel@gmail.com <mailto:a.steinel@gmail.com>> wrote:
>>
>> Hi Myke,
>>
>> On Fri, Sep 20, 2019 at 12:54 PM Myke Ndungu <mykendoch@gmail.com
>> <mailto:mykendoch@gmail.com>> wrote:
>>
>> Hello there im in windows trying to install both postreSQL 11 a
>> and Pgadmin 4 but without good progress.
>> im keeping on receiving an error "database cluster not
>> initialized" have used all the solutions eg
>> adding postgres in computer management and giving it full rights
>> on the security properties section in postgreSQL file folder
>> though during reinstallation its telling me to chose another
>> directory to upgrade the current application.
>> i also tried to install afresh postgres using the command prompt
>> still not yet
>> ALSO INCLUDED THE POSTGRES PATH IN THE ENVIRONMENT VARIABLE still
>> not working
>> Advise from there please
>>
>>
>> Yes, Windows and PostgreSQL are not the best friends and that's OK.
>> Why don't you just go down the Docker route and stop trying to use
>> Windows for PostgreSQL.
>> There is no easier method to get started with both than Docker.
>>
>> --
>> With kind regards / Mit freundlichen Grüßen
>>
>> Andreas Steinel
>> M.Sc. Visual Computing
>> M.Sc. Informatik
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-09-23 09:07 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-09-20 06:59 POSTGRES ISSUES Myke Ndungu <mykendoch@gmail.com>
2019-09-22 11:21 ` Andreas Steinel <a.steinel@gmail.com>
2019-09-22 14:26 ` Doug Easterbrook <doug@artsman.com>
2019-09-23 05:24 ` Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
2019-09-23 09:07 ` Milan Oparnica <milan.opa@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox