New install of 9.5.12 missing default PostgreSQL DB

On 05/08/2018 06:12 PM, chandru.aroor@yahoo.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.klaver@aklaver.com

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.klaver@aklaver.com> wrote:

On 05/08/2018 06:12 PM, chandru.aroor@yahoo.com
<mailto:chandru.aroor@yahoo.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

I don't even have a server to connect to and that is my problem.

On Wednesday, May 9, 2018, 6:48:40 PM CDT, Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com> wrote:

On 05/08/2018 06:12 PM, chandru.aroor@yahoo.com
<mailto:chandru.aroor@yahoo.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

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.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

On 05/08/2018 06:12 PM, chandru.aroor@yahoo.com

<mailto:chandru.aroor@yahoo.com>

<mailto:chandru.aroor@yahoo.com <mailto:chandru.aroor@yahoo.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

<mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

Yes, the service shows as running. But I don't have a Server to connect to!

On Wednesday, May 9, 2018, 9:43:02 PM CDT, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

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.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
  >
  >
  > On 05/08/2018 06:12 PM, chandru.aroor@yahoo.com
<mailto:chandru.aroor@yahoo.com>
  > <mailto:chandru.aroor@yahoo.com <mailto:chandru.aroor@yahoo.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
<mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>

  >
  >

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

On Wed, May 9, 2018 at 8:05 PM, Chandru Aroor <caroor@yahoo.com> wrote:

Yes, the service shows as running. But I don't have a Server to connect
to!

​I have to imagine you can add a server to pgAdmin...try host: localhost
and port: 5432

David J.

That did it! Thanks much!