cancel
Showing results for 
Search instead for 
Did you mean: 

PostgreSQL installation issues

Adventurer

PostgreSQL installation issues

hey guys i only recently installed PostgreSQL on my laptop and when i try to check if its working on the shell i get the following error

Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
find: /c/$Recycle.Bin/S-1-5-18: Permission denied
find: /c/$Recycle.Bin/S-1-5-21-2016335222-133078178-1699233605-1000: Permission denied
find: /c/$Recycle.Bin/S-1-5-21-2016335222-133078178-1699233605-1002: Permission denied
find: /c/$Recycle.Bin/S-1-5-21-2016335222-133078178-1699233605-1004: Permission denied
find: /c/$Recycle.Bin/S-1-5-21-2016335222-133078178-1699233605-500: Permission denied
find: /c/hiberfil.sys: Permission denied
find: /c/pagefile.sys: Permission denied
find: /c/Program Files/Microsoft Office/root/Office16/AppvIsvStream64.dll: No such file or directory
find: /c/Program Files/Microsoft Office/root/VFS/ProgramFilesCommonX64/Microsoft Shared/OFFICE16/AppvIsvStream64.dll: No such file or directory

 

please help me to solve this issue as i dont know why this is happening

10 REPLIES 10
EDB Team Member

Re: PostgreSQL installation issues

Hi thegeshwar,

 

Can you please provide the following details :

1. PostgreSQL version and OS details.

2. The command which you are using to connect the server.

3. PostgreSQL logs at the time when this issue occurred.

Regards,
Dhananjay
Adventurer

Re: PostgreSQL installation issues

umm im new to this so im not sure how to get all the log details can you please help me out a little bit more??

 

Adventurer

Re: PostgreSQL installation issues

PostgreSql version 11.5

Windows version : Running the latest windows 10 Home

Im not sure how to run commands in this as i am new and trying to learn the language.

Im guessiing this is the log... i just copied what was on the text file.

 

2019-09-01 22:34:36.242 IST [10932] LOG: database system was shut down at 2019-09-01 22:34:13 IST
2019-09-01 22:34:36.315 IST [8280] LOG: database system is ready to accept connections
2019-09-02 12:43:46.320 IST [2432] ERROR: cannot drop a template database
2019-09-02 12:43:46.320 IST [2432] STATEMENT: DROP DATABASE template1;

2019-09-02 12:43:55.502 IST [2432] ERROR: cannot drop a template database
2019-09-02 12:43:55.502 IST [2432] STATEMENT: DROP DATABASE template0;

2019-09-02 12:43:55.624 IST [6408] FATAL: database "template0" is not currently accepting connections
2019-09-02 12:47:18.749 IST [8280] LOG: received fast shutdown request
2019-09-02 12:47:18.784 IST [8280] LOG: aborting any active transactions
2019-09-02 12:47:18.785 IST [12124] FATAL: terminating connection due to administrator command
2019-09-02 12:47:18.786 IST [2432] FATAL: terminating connection due to administrator command
2019-09-02 12:47:18.802 IST [8280] LOG: background worker "logical replication launcher" (PID 5916) exited with exit code 1
2019-09-02 12:47:18.808 IST [7080] LOG: shutting down
2019-09-02 12:47:19.007 IST [8280] LOG: database system is shut down

 

Thanks for the help

EDB Team Member

Re: PostgreSQL installation issues

Hi thegeshwar,

 

Default PostgreSQL installation on a window machine goes below location:

 

C:\Program Files\PostgreSQL\11\

Log files will be present under the below directory:

C:\Program Files\PostgreSQL\11\data\pg_log\

 

 

 

Regards,
Dhananjay
EDB Team Member

Re: PostgreSQL installation issues

Hi thegeshwar,

 

After looking at shared logs it looks like your database is shutdown. You need to start the database service from the services program.

Once the database is started kindly execute below example command to connect to the database server.

C:\Program Files\PostgreSQL\11\bin>psql.exe -U postgres -h localhost -p 5432

Hope this helps.

Regards,
Dhananjay
Adventurer

Re: PostgreSQL installation issues

How do i start the database services is there a particular method or an applicatoin for it ? 

I tried searching for a services application in the start folder but nothing came up

Adventurer

Re: PostgreSQL installation issues

Okay i started the server and all but when i go to the shell it still gives the firrst error that i had posted, its not even asking me for my password

EDB Team Member

Re: PostgreSQL installation issues

can you share the exact screenshot where you are getting this error and also if possible the command you are using on the shell prompt.

Regards,
Dhananjay
Adventurer

Re: PostgreSQL installation issues

5.JPG1.JPG2.JPG4.JPG3.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

these are the screenshots... i have not used any command because the shell does not let me as it gives error after i click enter on the username line...i think it is searching for files in the recycle bin.