Re: Install doesnt set SuperUser PW

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(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:
>
> On Tue, Dec 13, 2016 at 1:46 PM, Jovi Federici
> <jovi(dot)federici(at)gmail(dot)com <mailto:jovi(dot)federici(at)gmail(dot)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(dot)klaver(at)aklaver(dot)com