Обсуждение: [GENERAL] Install doesnt set SuperUser PW
Hi Postgres,
My installation of Postgress 9.6 did not include any setting of a SuperUser password so I'm at a loss.
Do I have a bad installation?
I got it here:
I'm running Windows 7 in 64 bit VM on a Mac Pro.
I'm new to this stuff ok? Please go easy on me :-)
Thanks!
-- Jovi
Hi Postgres,My installation of Postgress 9.6 did not include any setting of a SuperUser password so I'm at a loss.Do I have a bad installation?I got it here:I'm running Windows 7 in 64 bit VM on a Mac Pro.I'm new to this stuff ok? Please go easy on me :-)
Haven't used this particular install method but the Apt packages I use don't setup a password but instead allow for localhost connections on a trust basis - and don't listed on TCP/IP sockets by default either. I suspect that this installer is similar.
Also, I personally find it to be bad form to link directly to a page that starts downloading a 120MB software executable when you navigate to it. Wasn't there a landing page with information that you could have linked to instead?
David J.
On 12/13/2016 12:46 PM, Jovi Federici wrote: > Hi Postgres, > > My installation of Postgress 9.6 did not include any setting of a > SuperUser password so I'm at a loss. How did you determine this? > > Do I have a bad installation? > > I got it here: > > http://www.enterprisedb.com/postgresql-961-installers-win64?ls=Crossover&type=Crossover > > I'm running Windows 7 in 64 bit VM on a Mac Pro. > > I'm new to this stuff ok? Please go easy on me :-) So did you do the following?: https://www.enterprisedb.com/docs/en/9.6/instguide/PostgreSQL_Installation_Guide.1.08.html# If so, in about step 4 you created the password. > > Thanks! > -- > Jovi -- Adrian Klaver adrian.klaver@aklaver.com
Hi David, sorry bout that. Agreed: bad form. Here's the page:
Thank you for your help. I don't understand what you mean but "trust basis" and "don't listed on TCP/IP sockets by default" cause I'm really not that informed. I know python programming, basics on DB design, but very little on networking and SQL.
I'm really just trying to learn new stuff and I might be way over my head but I just wanted to create a DB and start populating it with some data and then mess around with it so I can learn. I'm interested in developing my own text analysis tools off of my own emails in Outlook.
Thanks again.
Jovi
On Tue, Dec 13, 2016 at 4:34 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
Hi Postgres,My installation of Postgress 9.6 did not include any setting of a SuperUser password so I'm at a loss.Do I have a bad installation?I got it here:I'm running Windows 7 in 64 bit VM on a Mac Pro.I'm new to this stuff ok? Please go easy on me :-)Haven't used this particular install method but the Apt packages I use don't setup a password but instead allow for localhost connections on a trust basis - and don't listed on TCP/IP sockets by default either. I suspect that this installer is similar.Also, I personally find it to be bad form to link directly to a page that starts downloading a 120MB software executable when you navigate to it. Wasn't there a landing page with information that you could have linked to instead?David J.
Jovi
Hi Adrian, I did graphical installer is in
Except I was not asked to input anything. I didn't input paths, I didn't input a PW.
It just ran and finished and that was it.
BTW, I had installed same previously then ran the uninstall.exe and re-installed because I forgot if I had entered a PW the first time but I really don't think I ever did.
Thanks for you help!
Jovi
On Tue, Dec 13, 2016 at 4:45 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/13/2016 12:46 PM, Jovi Federici wrote:Hi Postgres,
My installation of Postgress 9.6 did not include any setting of a
SuperUser password so I'm at a loss.
How did you determine this?
Do I have a bad installation?
I got it here:
http://www.enterprisedb.com/postgresql-961-installers-win64? ls=Crossover&type=Crossover
I'm running Windows 7 in 64 bit VM on a Mac Pro.
I'm new to this stuff ok? Please go easy on me :-)
So did you do the following?:
https://www.enterprisedb.com/docs/en/9.6/instguide/PostgreSQ L_Installation_Guide.1.08. html#
If so, in about step 4 you created the password.
Thanks!
--
Jovi
--
Adrian Klaver
adrian.klaver@aklaver.com
Jovi
On 12/13/2016 01:49 PM, Jovi Federici wrote: > Hi Adrian, I did graphical installer is in > > https://www.enterprisedb.com/docs/en/9.6/instguide/PostgreSQL_Installation_Guide.1.08.html# > <https://www.enterprisedb.com/docs/en/9.6/instguide/PostgreSQL_Installation_Guide.1.08.html#> > > Except I was not asked to input anything. I didn't input paths, I didn't > input a PW. > > It just ran and finished and that was it. Did you do this part?: "Note that in some versions of Windows, you can invoke the installer with Administrator privileges by right clicking on the installer icon and selecting Run as Administrator from the context menu." > > BTW, I had installed same previously then ran the uninstall.exe and > re-installed because I forgot if I had entered a PW the first time but I > really don't think I ever did. > > Thanks for you help! > > Jovi > -- Adrian Klaver adrian.klaver@aklaver.com
No! I did not do that! I will uninstall and re-install that way now.
On Tue, Dec 13, 2016 at 4:56 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/13/2016 01:49 PM, Jovi Federici wrote:Hi Adrian, I did graphical installer is in
https://www.enterprisedb.com/docs/en/9.6/instguide/PostgreSQ L_Installation_Guide.1.08. html#
<https://www.enterprisedb.com/docs/en/9.6/instguide/PostgreS QL_Installation_Guide.1.08. html#>
Except I was not asked to input anything. I didn't input paths, I didn't
input a PW.
It just ran and finished and that was it.
Did you do this part?:
"Note that in some versions of Windows, you can invoke the installer with Administrator privileges by right clicking on the installer icon and selecting Run as Administrator from the context menu."--
BTW, I had installed same previously then ran the uninstall.exe and
re-installed because I forgot if I had entered a PW the first time but I
really don't think I ever did.
Thanks for you help!
Jovi
Adrian Klaver
adrian.klaver@aklaver.com
Jovi
Just re-ran installer in Administrator mode with no difference. Correction on previous statement: the installed does ask for Paths but does not ask for a PW.
-Jovi
On Tue, Dec 13, 2016 at 4:58 PM, Jovi Federici <jovi.federici@gmail.com> wrote:
No! I did not do that! I will uninstall and re-install that way now.--On Tue, Dec 13, 2016 at 4:56 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:On 12/13/2016 01:49 PM, Jovi Federici wrote:Hi Adrian, I did graphical installer is in
https://www.enterprisedb.com/docs/en/9.6/instguide/PostgreSQ L_Installation_Guide.1.08.html #
<https://www.enterprisedb.com/docs/en/9.6/instguide/PostgreS QL_Installation_Guide.1.08.htm l#>
Except I was not asked to input anything. I didn't input paths, I didn't
input a PW.
It just ran and finished and that was it.
Did you do this part?:
"Note that in some versions of Windows, you can invoke the installer with Administrator privileges by right clicking on the installer icon and selecting Run as Administrator from the context menu."--
BTW, I had installed same previously then ran the uninstall.exe and
re-installed because I forgot if I had entered a PW the first time but I
really don't think I ever did.
Thanks for you help!
Jovi
Adrian Klaver
adrian.klaver@aklaver.comJovi
Jovi
On 12/13/2016 02:08 PM, Jovi Federici wrote: > Just re-ran installer in Administrator mode with no difference. > Correction on previous statement: the installed does ask for Paths but > does not ask for a PW. I have no idea at this point. I do not run Windows anymore, so I have nothing to test against. My suggestion would be to try here: http://forums.enterprisedb.com/forums/show/9.page;jsessionid=49D70EC0A476B22D3C6FEF3A24F0BA90 Or if you are willing to try something different: https://www.bigsql.org/postgresql/installers.jsp > > -Jovi > -- Adrian Klaver adrian.klaver@aklaver.com
On 12/13/2016 02:08 PM, Jovi Federici wrote: > Just re-ran installer in Administrator mode with no difference. > Correction on previous statement: the installed does ask for Paths but > does not ask for a PW. Dept of Late thoughts: Did the Postgres server actually get installed? Do you have a postgres OS user? Can you connect to the server in any manner? > > -Jovi > -- Adrian Klaver adrian.klaver@aklaver.com
I'm going to try the new installer at bigsql, thanks!
Did the Postgres server actually get installed? - I think so. I have Postgres in Programs folder
Do you have a postgres OS user? - I don't know. I assume the postgres user is created upon install. I have not done anything (create user) after install.
Can you connect to the server in any manner? - This is as far as I get:
![Inline image 1](cid:ii_158fa5b62642ca0e)
Do you have a postgres OS user? - I don't know. I assume the postgres user is created upon install. I have not done anything (create user) after install.
Can you connect to the server in any manner? - This is as far as I get:
On Tue, Dec 13, 2016 at 5:35 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/13/2016 02:08 PM, Jovi Federici wrote:Just re-ran installer in Administrator mode with no difference.
Correction on previous statement: the installed does ask for Paths but
does not ask for a PW.
Dept of Late thoughts:
Did the Postgres server actually get installed?
Do you have a postgres OS user?
Can you connect to the server in any manner?
Jovi
Вложения
OMG it worked! I just threw in a PW I had used for something else and it worked! Must have been your good vibes :-)
![Inline image 1](cid:ii_158fa5db2d795cde)
On Tue, Dec 13, 2016 at 5:44 PM, Jovi Federici <jovi.federici@gmail.com> wrote:
I'm going to try the new installer at bigsql, thanks!Did the Postgres server actually get installed? - I think so. I have Postgres in Programs folder
Do you have a postgres OS user? - I don't know. I assume the postgres user is created upon install. I have not done anything (create user) after install.
Can you connect to the server in any manner? - This is as far as I get:--On Tue, Dec 13, 2016 at 5:35 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:On 12/13/2016 02:08 PM, Jovi Federici wrote:Just re-ran installer in Administrator mode with no difference.
Correction on previous statement: the installed does ask for Paths but
does not ask for a PW.
Dept of Late thoughts:
Did the Postgres server actually get installed?
Do you have a postgres OS user?
Can you connect to the server in any manner?Jovi
Jovi
Вложения
On 12/13/2016 02:44 PM, Jovi Federici wrote: > I'm going to try the new installer at bigsql, thanks! I would uninstall the EDB version first. > > Did the Postgres server actually get installed? - I think so. I have > Postgres in Programs folder > > Do you have a postgres OS user? - I don't know. I assume the postgres > user is created upon install. I have not done anything (create user) > after install. > > Can you connect to the server in any manner? - This is as far as I get: > > Inline image 1 > So what happens if you just hit Enter without supplying a password? Or if you do?: psql -U postgres > > On Tue, Dec 13, 2016 at 5:35 PM, Adrian Klaver > <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote: > > On 12/13/2016 02:08 PM, Jovi Federici wrote: > > Just re-ran installer in Administrator mode with no difference. > Correction on previous statement: the installed does ask for > Paths but > does not ask for a PW. > > > Dept of Late thoughts: > > Did the Postgres server actually get installed? > > Do you have a postgres OS user? > > Can you connect to the server in any manner? > > > > -Jovi > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > > > > > -- > Jovi -- Adrian Klaver adrian.klaver@aklaver.com
On 12/13/2016 02:46 PM, Jovi Federici wrote: > OMG it worked! I just threw in a PW I had used for something else and it > worked! Must have been your good vibes :-) Best guess, at some point in past you did an install where you supplied a password and the installer stored that somewhere, so it did not need it when you reinstalled. > > Inline image 1 > > On Tue, Dec 13, 2016 at 5:44 PM, Jovi Federici <jovi.federici@gmail.com > <mailto:jovi.federici@gmail.com>> wrote: > > I'm going to try the new installer at bigsql, thanks! > > Did the Postgres server actually get installed? - I think so. I have > Postgres in Programs folder > > Do you have a postgres OS user? - I don't know. I assume the > postgres user is created upon install. I have not done anything > (create user) after install. > > Can you connect to the server in any manner? - This is as far as I get: > > Inline image 1 > > > On Tue, Dec 13, 2016 at 5:35 PM, Adrian Klaver > <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote: > > On 12/13/2016 02:08 PM, Jovi Federici wrote: > > Just re-ran installer in Administrator mode with no difference. > Correction on previous statement: the installed does ask for > Paths but > does not ask for a PW. > > > Dept of Late thoughts: > > Did the Postgres server actually get installed? > > Do you have a postgres OS user? > > Can you connect to the server in any manner? > > > > -Jovi > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > > > > > -- > Jovi > > > > > -- > Jovi -- Adrian Klaver adrian.klaver@aklaver.com
On 12/13/2016 01:46 PM, Jovi Federici wrote: > Hi David, sorry bout that. Agreed: bad form. Here's the page: > > http://www.enterprisedb.com/products-services-training/pgdownload#windows > > Thank you for your help. I don't understand what you mean but "trust > basis" and "don't listed on TCP/IP sockets by default" cause I'm really > not that informed. I know python programming, basics on DB design, but > very little on networking and SQL. The 'trust' authentication method will be found in your pg_hba.conf file: https://www.postgresql.org/docs/9.5/static/auth-methods.html#AUTH-TRUST On Windows, sockets really have no meaning as Postgres will use localhost in their place. > > I'm really just trying to learn new stuff and I might be way over my > head but I just wanted to create a DB and start populating it with some > data and then mess around with it so I can learn. I'm interested in > developing my own text analysis tools off of my own emails in Outlook. > > Thanks again. > > Jovi > > On Tue, Dec 13, 2016 at 4:34 PM, David G. Johnston > <david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> wrote: > > On Tue, Dec 13, 2016 at 1:46 PM, Jovi Federici > <jovi.federici@gmail.com <mailto:jovi.federici@gmail.com>>wrote: > > Hi Postgres, > > My installation of Postgress 9.6 did not include any setting of > a SuperUser password so I'm at a loss. > > Do I have a bad installation? > > I got it here: > > http://www.enterprisedb.com/postgresql-961-installers-win64?ls=Crossover&type=Crossover > <http://www.enterprisedb.com/postgresql-961-installers-win64?ls=Crossover&type=Crossover> > > I'm running Windows 7 in 64 bit VM on a Mac Pro. > > I'm new to this stuff ok? Please go easy on me :-) > > > Haven't used this particular install method but the Apt packages I > use don't setup a password but instead allow for localhost > connections on a trust basis - and don't listed on TCP/IP sockets by > default either. I suspect that this installer is similar. > > Also, I personally find it to be bad form to link directly to a page > that starts downloading a 120MB software executable when you > navigate to it. Wasn't there a landing page with information that > you could have linked to instead? > > David J. > > > > > -- > Jovi -- Adrian Klaver adrian.klaver@aklaver.com