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
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
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.
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  LOG: database system was shut down at 2019-09-01 22:34:13 IST
2019-09-01 22:34:36.315 IST  LOG: database system is ready to accept connections
2019-09-02 12:43:46.320 IST  ERROR: cannot drop a template database
2019-09-02 12:43:46.320 IST  STATEMENT: DROP DATABASE template1;
2019-09-02 12:43:55.502 IST  ERROR: cannot drop a template database
2019-09-02 12:43:55.502 IST  STATEMENT: DROP DATABASE template0;
2019-09-02 12:43:55.624 IST  FATAL: database "template0" is not currently accepting connections
2019-09-02 12:47:18.749 IST  LOG: received fast shutdown request
2019-09-02 12:47:18.784 IST  LOG: aborting any active transactions
2019-09-02 12:47:18.785 IST  FATAL: terminating connection due to administrator command
2019-09-02 12:47:18.786 IST  FATAL: terminating connection due to administrator command
2019-09-02 12:47:18.802 IST  LOG: background worker "logical replication launcher" (PID 5916) exited with exit code 1
2019-09-02 12:47:18.808 IST  LOG: shutting down
2019-09-02 12:47:19.007 IST  LOG: database system is shut down
Thanks for the help
Default PostgreSQL installation on a window machine goes below location:
Log files will be present under the below directory:
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.
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
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
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.
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.
I tried to reproduce your issue on my local environment.
However, I was not able to reproduce it.
Kindly refer below screenshots for my testing:
If you can share the environment details and steps to reproduce the issue it will be helpful for us to fix the issue.
Also, I have used below documented steps to install the environment on my local server.