Thread: 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

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.