Postgresql error status 1060

BUG #6388: I can not install postgre Sql

The following bug has been logged on the website:

Bug reference: 6388
Logged by: stoian
Email address: stoian_cris2004(at)yahoo(dot)com
PostgreSQL version: 8.4.10
Operating system: windows XP
Description:

I can not install postgre Sql . I get the following message: Sorry, could
not install Postgre SQL!.

Cause:
Output folder: C:Program FilesPSQLINSTALL
top level install dir —>C:Program Files
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe. 100%
Extract: TestFirewall.exe.config. 100%
Antivirus Installed: True
test antivirus returned 1
antivirus installed
security center error status: 0
security center status: 4
disabling security center
security center error status: 0
security center status: 1
disabled security center
seclogon error status: 0
seclogon status: 4
firewall enabled: 0
firewall not enabled
postgresql error status: 1060
postgresql status: 0
starting pgsql-8.3
postgresql error status: 1060
postgresql status: 0
postgresql error status: 1060
postgresql status: 0
starting postgresql-8.4
postgresql error status: 1060
postgresql status: 0
postgres installdir: C:Program FilesPSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection
refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?
C:Program
FilesPostgreSQL8.4-prev-2012-02-Jan-00-20-01
Create folder: C:Program FilesPostgreSQL8.4-prev-2012-02-Jan-00-20-01
Moving files: C:Program FilesPostgreSQL8.4*.* to C:Program
FilesPostgreSQL8.4-prev-2012-02-Jan-00-20-01
Remove folder: C:Program FilesPostgreSQL8.4
renamed dir
wrote testfile
Delete file: C:Program FilesPostgreSQLtestfile
Extract: postgresql-8.4.1-1-windows.exe. 100%
Execute: «C:Program FilesPSQLINSTALLpostgresql-8.4.1-1-windows.exe»
—mode unattended —superpassword postgrespass
postgres installdir: C:Program FilesPSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection
refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?

Copyright © 1996-2023 The PostgreSQL Global Development Group

Источник

Thread: PostgreSQL Install Problem

Thread Tools

Display

PostgreSQL Install Problem

I am having trouble installing PostgreSQL on my machine. My computer has Vista operating system, and I have disabled UAC, and have no anti-virus or firewalls turned on. I have made sure that windows script enabling or whatever it is called is available. Any help would be much appreciated.

Here is the error logging:

Output folder: C:Program Files (x86)PSQLINSTALL
top level install dir —>C:
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe. 100%
Extract: TestFirewall.exe.config. 100%
Antivirus Installed: False
test antivirus returned 0
seclogon error status: 0
seclogon status: 4
firewall enabled: 0
firewall not enabled
postgresql error status: 1060
postgresql status: 0
starting pgsql-8.3
postgresql error status: 1060
postgresql status: 0
postgresql error status: 1060
postgresql status: 0
starting postgresql-8.4
postgresql error status: 1060
postgresql status: 0
postgres installdir: C:Program Files (x86)PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?
C:PostgreSQL-prev-2012-20-May-10-09-35
Create folder: C:PostgreSQL-prev-2012-20-May-10-09-35
Moving files: C:PostgreSQL*.* to C:PostgreSQL-prev-2012-20-May-10-09-35
Remove folder: C:PostgreSQL
renamed dir
wrote testfile
Extract: postgresql-8.4.7-1-windows.exe. 100%
Create folder: c:postgreSQL
Execute: «C:Program Files (x86)PSQLINSTALLpostgresql-8.4.7-1-windows.exe» —mode unattended —superpassword postgrespass —prefix c:postgreSQL —datadir c:postgreSQLdata
postgres installdir: C:Program Files (x86)PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?

I would like to apologize for the issues you are having with HM2, Holdem Manager has a built in installer in the setup program available from http://www.holdemmanager.com/downloa. er_2_Setup.exe

If you have issues with this installer please try the following before installing:
1) Go to start > programs > accessories > click on command prompt
(If your using Vista or Windows 7 and have UAC enabled you’ll need to do the following before clicking on command prompt: right-click on command prompt and chose run as administrator)
2) In the dos window that appears type the following and press return:
net user postgres /delete

Please note if you get an error at this point and report it to us. Then proceed with the installation. If you receive any errors during installation please take a screenshot of the error and send to us.

Alternatively you repeat steps 1 and 2 above and then install the versions below and see if they work and also note any errors you receive during installation:
PostgreSQL 9.0, 8.4 or 8.3 — Download PostgreSQL | EnterpriseDB
PostgreSQL 8.2 — http://wwwmaster.postgresql.org/down. l-8.2.21-1.zip

We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

Thanks
Holdem Manager Support

Thank you for your help. I tried your suggestion and typed «net user postgres /delete» in the command prompt, but received a message that said «the user name could not be found». Do you have any other suggestions for me? Do you need any more information from me?

Turn on the secondary Logon. The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.

Participate in the Beta release of the newest Hold’em Manager version: HM Cloud. Sign-up HERE.

If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, — you can do this here

Thank you for your help. The secondary Logon was already turned on, so that is not the problem.

I tried using the installer you provided, but ran into a problem. The message I received is:

Error reading from file
C:UserRobAppDataLocalTempTemp1_postgresql-8.2.22.1.zippostgresql-8.2-int.msi.
Verify that the file exists and that you can access it.

Now, when I look through my files, that file path seems to be incorrect. There is no «AppData» under «Rob». There is an «AppData» foler, but it is under «Users», and there is only one folder in the «AppData» folder, called «LocalLow», but the only file in it is unrelated to PostgreSQL.

Any thoughts on this?

.enable the option to see Hidden System Files: How to see hidden files in Windows

.in your license file)

Or download the file again, but download it to desktop.

Participate in the Beta release of the newest Hold’em Manager version: HM Cloud. Sign-up HERE.

If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, — you can do this here

Источник

Thread: Problems installing postgres during HM setup

Thread Tools

Display

Problems installing postgres during HM setup

Output folder: C:Program Files (x86)PSQLINSTALL
top level install dir —>C:
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe. 100%
Extract: TestFirewall.exe.config. 100%
Antivirus Installed: False
test antivirus returned 0
seclogon error status: 0
seclogon status: 4
firewall enabled: 0
firewall not enabled
postgresql error status: 1060
postgresql status: 0
starting pgsql-8.3
postgresql error status: 1060
postgresql status: 0
postgresql error status: 1060
postgresql status: 0
starting postgresql-8.4
postgresql error status: 1060
postgresql status: 0
postgres installdir: C:Program Files (x86)PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?
C:PostgreSQL-prev-2017-20-Apr-10-21-22
Create folder: C:PostgreSQL-prev-2017-20-Apr-10-21-22
Moving files: C:PostgreSQL*.* to C:PostgreSQL-prev-2017-20-Apr-10-21-22
Remove folder: C:PostgreSQL
renamed dir
wrote testfile
Create folder: c:postgreSQL
Execute: «C:Program Files (x86)PSQLINSTALLpostgres84.exe» —mode unattended —superpassword postgrespass —prefix c:postgreSQL —datadir c:postgreSQLdata
postgres installdir: C:Program Files (x86)PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?

Uninstall PostgreSQL & try the following steps:

1) Run cmd.exe as Admin (Start > Search ‘cmd’ > Right-Click > Run As Admin)
2) in CMD window run (type the code then hit Enter key) following command:
net user postgres /del
3) Reboot PC
4) after reboot open cmd.exe again & run following commands:

When it asks about password please input postgrespass & don`t worry if you don`t see any new symbolsinputs in cmd window. If you did all steps right then you should get new cmd window for postgres user.

Источник

Thread: troubleshooting installation of PostgreSQL

Thread Tools

Display

troubleshooting installation of PostgreSQL

the installation of PostgreSQL is always a headache to me.
Here is the problem:
Output folder: C:Program Files (x86)PSQLINSTALL
top level install dir —>C:
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe. 100%
Extract: TestFirewall.exe.config. 100%
Antivirus Installed: False
test antivirus returned 0
seclogon error status: 0
seclogon status: 1
starting seclogon
seclogon error status: 0
seclogon status: 4
firewall enabled: 0
firewall not enabled
postgresql error status: 1060
postgresql status: 0
starting pgsql-8.3
postgresql error status: 1060
postgresql status: 0
postgresql error status: 1060
postgresql status: 0
starting postgresql-8.4
postgresql error status: 1060
postgresql status: 0
postgres installdir: C:Program Files (x86)PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?
C:PostgreSQL-prev-2012-20-May-10-09-35
Create folder: C:PostgreSQL-prev-2012-20-May-10-09-35
Moving files: C:PostgreSQL*.* to C:PostgreSQL-prev-2012-20-May-10-09-35
Remove folder: C:PostgreSQL
renamed dir
wrote testfile
Extract: postgresql-8.4.7-1-windows.exe. 100%
Create folder: c:postgreSQL
Execute: «C:Program Files (x86)PSQLINSTALLpostgresql-8.4.7-1-windows.exe» —mode unattended —superpassword postgrespass —prefix c:postgreSQL —datadir c:postgreSQLdata
postgres installdir: C:Program Files (x86)PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?

If you have Win7 (or Vista), consider the following:

1) PC name must be in English and «in one word» — requires reboot after changing.

2) The same for Windows user name. If not — create new Win user with EN name and reboot PC for this user when install Postgres. And he must have admin rights. After installation you can kill this new user — his mission is completed.
This means: if you have Russian (or French, or else) Windows — your PC name possibly contains «non-english» letters.
Like «Вася-PC» or «Rene-PC»
The same with windows username. Or spaces in the name.
Postgres doesn’t like that — and won’t run as a result of it.

3) Secondary logon service must be set to «Autostart».
This is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services.

5) Disable firewall and antivirus when installing Postgres and HM. Or uninstall them at all.

6) All installations must run «as admin» (by right-click on file). And do them as first thing after PC reboot.

7) If you want to change install path for Postgres (or to set non-default folder for database cluster) — download «standalone» installation file from Download PostgreSQL | EnterpriseDB

If your Windows is not in English — you have to install Postgres not in default folder in Program_Files. Create new (example: c:postgresql) first and select it when install.

9) Install Postgres and HM separarelly, one after one. As admin. If HM (when runs for the 1st time) says «no database» — simply create it via DBControlpanel.

10) If Postgres install fails — after uninstalling don’t forget to kill windows user named «postgres»:
Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:
net user postgres /del
exactly as shown. You should get a confirmation if it was successful.

11) Run all pokerclients «as admin».

12) Finally, if you use the automatic combo install in Holdem Manager to install HM and PostgreSQL together. If you run into the problem, password «postgrespass» does not comply with domain password requirements. Please manually install PostgreSQL and enter another password to make it work. PostgreSQL: The world’s most advanced open source database

Источник

05-21-2010, 05:49 AM

#1

Не могу установить, выскакивает ошибка: Sorry could not install PostgreSQL, при этом лог следующий:
Output folder: C:Program FilesPSQLINSTALL
top level install dir —>C:
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe… 100%
Extract: TestFirewall.exe.config… 100%
Antivirus Installed: False
test antivirus returned 0
seclogon error status: 0
seclogon status: 1
starting seclogon
seclogon error status: 0
seclogon status: 4
firewall enabled: 1
firewall port 5432 enabled: 0
port 5432 not added
set port 5432 enabled
postgresql error status: 1060
postgresql status: 0
starting pgsql-8.3
postgresql error status: 1060
postgresql status: 0
postgresql error status: 1060
postgresql status: 0
starting postgresql-8.4
postgresql error status: 1060
postgresql status: 0
postgres installdir: C:Program FilesPSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?
<—error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient
no existing install dir
wrote testfile
Delete file: C:testfile
Create folder: c:postgreSQL
Execute: «C:Program FilesPSQLINSTALLpostgres84.exe» —mode unattended —superpassword postgrespass —prefix c:postgreSQL —datadir c:postgreSQLdata
postgres installdir: C:Program FilesPSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?
<—error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient

Заранее спасибо)

The following bug has been logged on the website:

Bug reference: 6388
Logged by: stoian
Email address: stoian_cris2004(at)yahoo(dot)com
PostgreSQL version: 8.4.10
Operating system: windows XP
Description:

I can not install postgre Sql . I get the following message: Sorry, could
not install Postgre SQL!.

Cause:
Output folder: C:Program FilesPSQLINSTALL
top level install dir —>C:Program Files
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe… 100%
Extract: TestFirewall.exe.config… 100%
Antivirus Installed: True
test antivirus returned 1
antivirus installed
security center error status: 0
security center status: 4
disabling security center
security center error status: 0
security center status: 1
disabled security center
seclogon error status: 0
seclogon status: 4
firewall enabled: 0
firewall not enabled
postgresql error status: 1060
postgresql status: 0
starting pgsql-8.3
postgresql error status: 1060
postgresql status: 0
postgresql error status: 1060
postgresql status: 0
starting postgresql-8.4
postgresql error status: 1060
postgresql status: 0
postgres installdir: C:Program FilesPSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection
refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?
<—error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient
granting write permission on top level postgres directory
found dir
try rename C:Program FilesPostgreSQL8.4 —> C:Program
FilesPostgreSQL8.4-prev-2012-02-Jan-00-20-01
Create folder: C:Program FilesPostgreSQL8.4-prev-2012-02-Jan-00-20-01
Moving files: C:Program FilesPostgreSQL8.4*.* to C:Program
FilesPostgreSQL8.4-prev-2012-02-Jan-00-20-01
Remove folder: C:Program FilesPostgreSQL8.4
renamed dir
wrote testfile
Delete file: C:Program FilesPostgreSQLtestfile
Extract: postgresql-8.4.1-1-windows.exe… 100%
Execute: «C:Program FilesPSQLINSTALLpostgresql-8.4.1-1-windows.exe»
—mode unattended —superpassword postgrespass
postgres installdir: C:Program FilesPSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: —>could not connect to server: Connection
refused (0x0000274D/10061)
Is the server running on host «127.0.0.1» and accepting
TCP/IP connections on port 5432?
<—error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient

WHAT CAN I DO ?

Hi, I’ve been trying to install postgrSQL all day unsuccessfully. I’m running a Windows 10 (64bit) and I keep trying different solutions I find through Google and nothing is working. Here is a log. I uninstalled my anti-virus and turned off firewall. Any help is greatly appreciated.

P.S. is there a place where I can buy remote support for this? Have them fix it remotely?

Thanks.

Output folder: C:Program Files (x86)PSQLINSTALL

top level install dir —>C:

Is admin account

fs=NTFS

.NET found

Extract: TestFirewall.exe… 100%

Extract: TestFirewall.exe.config… 100%

Antivirus Installed: False

test antivirus returned 0

seclogon error status: 0

seclogon status: 1

starting seclogon

seclogon error status: 0

seclogon status: 4

firewall enabled: 0

firewall not enabled

postgresql error status: 1060

postgresql status: 0

starting pgsql-8.3

postgresql error status: 1060

postgresql status: 0

postgresql error status: 1060

postgresql status: 0

starting postgresql-8.4

postgresql error status: 1060

postgresql status: 0

postgres installdir: C:Program Files (x86)PSQLINSTALL

==================== running PsqlTestClient

try userid: postgres

try pass: postgrespass

try pass: postgrespass

Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host «127.0.0.1» and accepting TCP/IP connections on port 5432?

<—error

1 testclient return status: 1

testclient return from file: 1

==================== finished PsqlTestClient

granting write permission on top level postgres directory

found dir

try rename C:PostgreSQL —> C:PostgreSQL-prev-2018-03-Apr-17-30-24

Create folder: C:PostgreSQL-prev-2018-03-Apr-17-30-24

Moving files: C:PostgreSQL*.* to C:PostgreSQL-prev-2018-03-Apr-17-30-24

Remove folder: C:PostgreSQL

renamed dir

wrote testfile

Create folder: c:postgreSQL

Execute: «C:Program Files (x86)PSQLINSTALLpostgres84.exe» —mode unattended —superpassword postgrespass —prefix c:postgreSQL —datadir c:postgreSQLdata

postgres installdir: C:Program Files (x86)PSQLINSTALL

==================== running PsqlTestClient

try userid: postgres

try pass: postgrespass

try pass: postgrespass

Connection to database failed: —>could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host «127.0.0.1» and accepting TCP/IP connections on port 5432?

<—error

1 testclient return status: 1

testclient return from file: 1

==================== finished PsqlTestClient

One day, My Postgresql server stopped working. Checked log. It was shutdown somehow.

root@ip_address:/# tail /var/log/postgresql/postgresql-10-main.log
2020-02-19 06:47:49.215 CET [23497] LOG:  received smart shutdown request
2020-02-19 06:47:49.477 CET [23497] LOG:  worker process: logical replication launcher (PID 23512) exited with exit code 1
2020-02-19 06:47:49.482 CET [23507] LOG:  shutting down
2020-02-19 06:47:49.546 CET [23497] LOG:  database system is shut down

When I run,

root@ip_address:/# psql
psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

It complained that there are no files and directory. so I checked if my postgresql running.

root@ip_address:/# systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
   Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
   Active: active (exited) since Sun 2020-03-08 16:19:24 CET; 26min ago
  Process: 30136 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
 Main PID: 30136 (code=exited, status=0/SUCCESS)

Mar 08 16:19:24 vps584959 systemd[1]: Starting PostgreSQL RDBMS...
Mar 08 16:19:24 vps584959 systemd[1]: Started PostgreSQL RDBMS.

It was running. but, if I check postgresql cluster.

root@ip_address:/# pg_lsclusters
Ver Cluster Port Status Owner    Data directory              Log file
10  main    5432 down   postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log

It was DOWN

so I tried

root@ip_address:/# pg_ctlcluster 10 main start
 Error: Config owner (deploy:1003) and data owner (postgres:114) do not match, and config owner is not root

I wasn’t able to make it work. then I tried.

sudo chown -R deploy:postgres /var/lib/postgresql/10/ && sudo chmod -R u=rwX,go= /var/lib/postgresql/10/

try again.

root@ip_address:/# pg_ctlcluster 10 main start
Job for postgresql@10-main.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status postgresql@10-main.service" and "journalctl -xe" for details.

root@ip_address:/# systemctl status postgresql@10-main.service
● postgresql@10-main.service - PostgreSQL Cluster 10-main
   Loaded: loaded (/lib/systemd/system/postgresql@.service; indirect; vendor preset: enabled)
   Active: failed (Result: protocol) since Sun 2020-03-08 16:59:53 CET; 2min 52s ago
  Process: 31635 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 10-main start (code=exited, status=1/FAILURE)
 Main PID: 23497 (code=exited, status=0/SUCCESS)

Mar 08 16:59:53 vps584959 systemd[1]: Starting PostgreSQL Cluster 10-main...
Mar 08 16:59:53 vps584959 postgresql@10-main[31635]: Error: /usr/lib/postgresql/10/bin/pg_ctl /usr/lib/postgresql/10/bin/pg_ctl start -D /var/lib/postgresql/10/main -l /var/log/postgre
Mar 08 16:59:53 vps584959 systemd[1]: postgresql@10-main.service: Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory
Mar 08 16:59:53 vps584959 systemd[1]: postgresql@10-main.service: Failed with result 'protocol'.
Mar 08 16:59:53 vps584959 systemd[1]: Failed to start PostgreSQL Cluster 10-main.

Don’t know what to do more. Is anybody had the same problem?

More infos.

root@ip_address:/var/run/postgresql# ls
total 0
drwxrwsr-x  3 postgres postgres   60 Feb 19 06:47 .
drwxr-xr-x 28 root     root     1060 Mar  8 13:58 ..
drwxr-s---  2 postgres postgres   40 Feb 19 06:47 10-main.pg_stat_tmp

root@vps584959:~# journalctl -xe
Mar 08 17:46:07 vps584959 sudo[2154]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl start postgresql@10-main
Mar 08 17:46:07 vps584959 sudo[2154]: pam_unix(sudo:session): session opened for user root by root(uid=0)
Mar 08 17:46:07 vps584959 systemd[1]: Starting PostgreSQL Cluster 10-main...
-- Subject: Unit postgresql@10-main.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit postgresql@10-main.service has begun starting up.
Mar 08 17:46:07 vps584959 postgresql@10-main[2157]: Error: Config owner (deploy:1003) and data owner (root:0) do not match, and config owner is not root
Mar 08 17:46:07 vps584959 systemd[1]: postgresql@10-main.service: Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory
Mar 08 17:46:07 vps584959 systemd[1]: postgresql@10-main.service: Failed with result 'protocol'.
Mar 08 17:46:07 vps584959 systemd[1]: Failed to start PostgreSQL Cluster 10-main.
-- Subject: Unit postgresql@10-main.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit postgresql@10-main.service has failed.
--
-- The result is RESULT.
Mar 08 17:46:07 vps584959 sudo[2154]: pam_unix(sudo:session): session closed for user root
Mar 08 17:46:08 vps584959 sshd[2152]: Invalid user ftp1 from x.x.x.x port 57060
Mar 08 17:46:08 vps584959 sshd[2152]: pam_unix(sshd:auth): check pass; user unknown
Mar 08 17:46:08 vps584959 sshd[2152]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=x.x.x.x
Mar 08 17:46:09 vps584959 sshd[2152]: Failed password for invalid user ftp1 from 159.89.196.75 port 57060 ssh2
Mar 08 17:46:10 vps584959 sshd[2152]: Received disconnect from x.x.x.x port 57060:11: Bye Bye [preauth]
Mar 08 17:46:10 vps584959 sshd[2152]: Disconnected from invalid user ftp1 159.89.196.75 port 57060 [preauth]
Mar 08 17:46:11 vps584959 sshd[2150]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=x.x.x.x  user=root
Mar 08 17:46:12 vps584959 sshd[2159]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=x.x.x.x  user=root
Mar 08 17:46:13 vps584959 sshd[2150]: Failed password for root from xx.xx.xx.xx port 20408 ssh2

Update
— still not working.

root@myserver:~# chown -R postgres:postgres /etc/postgresql/10/main/
root@myserver:~#
root@myserver:~#
root@myserver:~# pg_ctlcluster 10 main start
Job for postgresql@10-main.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status postgresql@10-main.service" and "journalctl -xe" for details.
root@myserver:~# systemctl status postgresql@10-main.service
● postgresql@10-main.service - PostgreSQL Cluster 10-main
   Loaded: loaded (/lib/systemd/system/postgresql@.service; indirect; vendor preset: enabled)
   Active: failed (Result: protocol) since Thu 2020-03-12 00:09:43 CET; 7s ago
  Process: 23767 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 10-main start (code=exited, status=1/FAILURE)

root@vps584959:~# systemctl status postgresql@10-main.service
● postgresql@10-main.service - PostgreSQL Cluster 10-main
   Loaded: loaded (/lib/systemd/system/postgresql@.service; indirect; vendor preset: enabled)
   Active: failed (Result: protocol) since Thu 2020-03-12 00:09:43 CET; 11min ago
  Process: 23767 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 10-main start (code=exited, status=1/FAILURE)

Update 2

root@vps584959:~# journalctl -xe
--
-- Unit UNIT has finished starting up.
--
-- The start-up result is RESULT.
Mar 14 13:55:16 vps584959 systemd[31170]: Startup finished in 171ms.
-- Subject: User manager start-up is now complete
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The user manager instance for user 0 has been started. All services queued
-- for starting have been started. Note that other services might still be starting
-- up or be started at any later time.
--
-- Startup of the manager took 171927 microseconds.
Mar 14 13:55:17 vps584959 sshd[31156]: Failed password for root from 49.88.112.111 port 29693 ssh2
Mar 14 13:55:18 vps584959 sshd[31156]: Received disconnect from 49.88.112.111 port 29693:11:  [preauth]
Mar 14 13:55:18 vps584959 sshd[31156]: Disconnected from authenticating user root 49.88.112.111 port 29693 [preauth]
Mar 14 13:55:18 vps584959 sshd[31156]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=49.88.112.111  user=root
Mar 14 13:55:33 vps584959 sshd[31363]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=134.17.94.237  user=root
Mar 14 13:55:35 vps584959 sshd[31363]: Failed password for root from 134.17.94.237 port 3684 ssh2
Mar 14 13:55:35 vps584959 sshd[31363]: Received disconnect from 134.17.94.237 port 3684:11: Bye Bye [preauth]
Mar 14 13:55:35 vps584959 sshd[31363]: Disconnected from authenticating user root 134.17.94.237 port 3684 [preauth]
Mar 14 13:55:43 vps584959 systemd[1]: Starting PostgreSQL Cluster 10-main...
-- Subject: Unit postgresql@10-main.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit postgresql@10-main.service has begun starting up.
Mar 14 13:55:43 vps584959 postgresql@10-main[31373]: Error: /usr/lib/postgresql/10/bin/pg_ctl /usr/lib/postgresql/10/bin/pg_ctl start -D /var/lib/postgresql/10/main -l /var/log/p
Mar 14 13:55:43 vps584959 postgresql@10-main[31373]: 2020-03-14 13:55:43.696 CET [31378] FATAL:  private key file "/etc/ssl/private/ssl-cert-snakeoil.key" must be owned by the da
Mar 14 13:55:43 vps584959 postgresql@10-main[31373]: 2020-03-14 13:55:43.698 CET [31378] LOG:  database system is shut down
Mar 14 13:55:43 vps584959 postgresql@10-main[31373]: pg_ctl: could not start server
Mar 14 13:55:43 vps584959 postgresql@10-main[31373]: Examine the log output.
Mar 14 13:55:43 vps584959 systemd[1]: postgresql@10-main.service: Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory
Mar 14 13:55:43 vps584959 systemd[1]: postgresql@10-main.service: Failed with result 'protocol'.
Mar 14 13:55:43 vps584959 systemd[1]: Failed to start PostgreSQL Cluster 10-main.
-- Subject: Unit postgresql@10-main.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit postgresql@10-main.service has failed.
--
-- The result is RESULT.

and,

root@vps584959:~# cat /var/log/postgresql/postgresql-10-main.log
.
.
2020-03-12 00:09:43.609 CET [23773] FATAL:  private key file "/etc/ssl/private/ssl-cert-snakeoil.key" must be owned by the database user or root
2020-03-12 00:09:43.611 CET [23773] LOG:  database system is shut down
pg_ctl: could not start server
Examine the log output.
2020-03-14 13:55:43.696 CET [31378] FATAL:  private key file "/etc/ssl/private/ssl-cert-snakeoil.key" must be owned by the database user or root
2020-03-14 13:55:43.698 CET [31378] LOG:  database system is shut down
pg_ctl: could not start server
Examine the log output.
root@vps584959:~#