Re: New install of 9.5.12 missing default PostgreSQL DB

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Chandru Aroor <caroor(at)yahoo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: New install of 9.5.12 missing default PostgreSQL DB
Date: 2018-05-10 02:42:07
Message-ID: c2958606-436f-9bfc-fcd8-2f326a1bad18@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/09/2018 07:12 PM, Chandru Aroor wrote:
> I don't even have a server to connect to and that is my problem.

I thought you said earlier that the Postgres service was running.

Is it running?

>
>
> On Wednesday, May 9, 2018, 6:48:40 PM CDT, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>
> On 05/09/2018 06:56 AM, Chandru Aroor wrote:
>
> Please reply to list also.
> Ccing list.
>
> > I am used to seeing an instance of the PostgreSQL database once I finish
> > installing.  I then restore a copy of the database I need to work with
> > into this instance.
> >
> > Inline image
> > I am setting up a dev environment, into which I wish to restore a backup
> > of a Test instance. However after the install is done and I open
> > pgAdmin, this is what I see in the new install. That is the Servers
> > group is empty and I (presume) I cannot restore my Test instance here.
>
> Have you tried?:
>
> https://www.pgadmin.org/docs/pgadmin4/3.x/connecting.html
>
> Contents:
>
>     The Server Dialog
>
>
> >
> >
> > Inline image
> >
> >
> > On Wednesday, May 9, 2018, 8:28:44 AM CDT, Adrian Klaver
> > <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
> >
> >
> > On 05/08/2018 06:12 PM, chandru(dot)aroor(at)yahoo(dot)com
> <mailto:chandru(dot)aroor(at)yahoo(dot)com>
> > <mailto:chandru(dot)aroor(at)yahoo(dot)com <mailto:chandru(dot)aroor(at)yahoo(dot)com>> wrote:
> >  > I installed PostgreSQL using PostgreSQL-9.5.12-1-win64-bigsql on a
> >  > Windows 10 system.  I installed as a local admin.  The installation
> >  > completed fine, although it failed earlier when I tried to install
> it as
> >  > non-admin of the laptop.
> >  >
> >  > When I launch pgAdmin, I don't see the default instance of the DB
> >  > installed on my system.  When I expand the Servers group it is
> empty.  I
> >
> > What do you consider the default database?
> >
> > You need to set up the Server(s):
> >
> > https://www.pgadmin.org/docs/pgadmin4/3.x/connecting.html
> >
> >
> >  > went to services to make sure that the PostgreSQL service (PostgreSQL
> >  > 9.5 Server) was running. I restarted the service too.
> >  >
> >  >
> >  > What an I missing?  Appreciate any help on this.
> >  >
> >  > Thanks,
> >  >
> >  > Chandru
> >
> >  >
> >  >
> >
> >
> > --
> > Adrian Klaver
> > adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chandru Aroor 2018-05-10 03:05:09 Re: New install of 9.5.12 missing default PostgreSQL DB
Previous Message Chandru Aroor 2018-05-10 02:12:52 Re: New install of 9.5.12 missing default PostgreSQL DB