Postgresql not be started

pablosarg 2019-11-04 01:04:43 UTC #1

Hol
When I try to start my server, Apache works but postgres not be started:

lappstack-7.1.25-0/postgresql/scripts/ctl.sh : postgresql  could not be started
Stderr:
pg_ctl.bin: could not start server
Examine the log output.

I use in ubuntu 18.04
Gracias
Pablo

jota 2019-11-04 08:22:56 UTC #2

Hi @pablosarg,

We have a Support Tool that will gather relevant information for us to analyze your configuration and logs. Could you please download and execute it on the machine where the stack is running by following the steps described in the guide below?

How to Run the Bitnami Support Tool

Please note that you need to paste the code ID that is shown at the end.

pablosarg 2019-11-09 19:53:07 UTC #3

Hola
Is 9969b2a2-6bcb-e96c-6852-cc5b9910e727
Gracias
Pablo

gongomgra 2019-11-11 11:28:59 UTC #4

Hola @pablosarg,

Parece que el fichero de log de PostgreSQL es demasiado grande y debido a ello la herramienta de soporte no ha podido incluirlo. ¿Puedes ejecutar el siguiente comando en tu ordenador y enviarnos la salida?

tail -n100 /home/pablo/lappstack-7.1.25-0/postgresql/postgresql.log

Ese comando mostrará las 100 últimas líneas del fichero de log de PostgreSQL para que podamos ver el error.

Un saludo,
Gonzalo

pablosarg 2019-11-12 01:15:16 UTC #5

Hola
Qué bueno poder escribir en castellano
Te paso lo que me pediste:
(base) pablo@pablo-l:~$ tail -n100 /home/pablo/lappstack-7.1.25-0/postgresql/postgresql.log
2019-09-05 00:31:14.389 -03 [32009] STATEMENT: update public.sistema_financiero u
set radio_2010=r.cod_2010
from ceur.radios2010 r
where st_contains(r.geom, u.geom)
2019-09-05 00:31:26.802 -03 [32009] ERROR: relation "datos.sistema_financiero" does not exist at character 8
2019-09-05 00:31:26.802 -03 [32009] STATEMENT: update datos.sistema_financiero u
set radio_2010=r.cod_2010
from ceur.radios2010 r
where st_contains(r.geom, u.geom)
2019-09-05 00:31:36.902 -03 [32009] ERROR: syntax error at or near "-" at character 21
2019-09-05 00:31:36.902 -03 [32009] STATEMENT: update datos.sistema-financiero u
set radio_2010=r.cod_2010
from ceur.radios2010 r
where st_contains(r.geom, u.geom)
2019-09-05 00:31:51.298 -03 [32009] ERROR: relation "ceur.radios2010" does not exist at character 66
2019-09-05 00:31:51.298 -03 [32009] STATEMENT: update datos.sistema_financiero u
set radio_2010=r.cod_2010
from ceur.radios2010 r
where st_contains(r.geom, u.geom)
2019-09-05 00:32:37.726 -03 [748] ERROR: relation "datos.Sistema-Financiero" does not exist at character 15
2019-09-05 00:32:37.726 -03 [748] STATEMENT: SELECT * FROM "datos"."Sistema-Financiero" LIMIT 1
2019-09-05 11:02:05.870 -03 [27865] LOG: received smart shutdown request
2019-09-05 11:02:05.876 -03 [31867] FATAL: terminating connection due to administrator command
2019-09-05 11:02:05.877 -03 [32009] FATAL: terminating connection due to administrator command
2019-09-05 11:02:05.878 -03 [31884] FATAL: terminating connection due to administrator command
2019-09-05 11:02:05.931 -03 [27865] LOG: worker process: logical replication launcher (PID 27872) exited with exit code 1
2019-09-05 11:02:05.931 -03 [27867] LOG: shutting down
2019-09-05 11:02:05.932 -03 [27865] LOG: received SIGHUP, reloading configuration files
2019-09-05 11:02:05.970 -03 [27865] LOG: received SIGHUP, reloading configuration files
2019-09-05 11:02:06.034 -03 [27865] LOG: database system is shut down
2019-09-06 22:29:07.361 -03 [5101] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-09-06 22:29:07.366 -03 [5101] LOG: listening on Unix socket "/home/pablo/lappstack-7.1.25-0/postgresql/.s.PGSQL.5432"
2019-09-06 22:29:07.392 -03 [5102] LOG: database system was shut down at 2019-09-05 11:02:05 -03
2019-09-06 22:29:07.400 -03 [5101] LOG: database system is ready to accept connections
2019-09-07 00:20:25.079 -03 [5101] LOG: received fast shutdown request
2019-09-07 00:20:25.082 -03 [5101] LOG: aborting any active transactions
2019-09-07 00:20:25.082 -03 [5101] LOG: worker process: logical replication launcher (PID 5108) exited with exit code 1
2019-09-07 00:20:25.083 -03 [5103] LOG: shutting down
2019-09-07 00:20:25.110 -03 [5101] LOG: database system is shut down
2019-09-07 13:04:21.291 -03 [3866] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-09-07 13:04:21.296 -03 [3866] LOG: listening on Unix socket "/home/pablo/lappstack-7.1.25-0/postgresql/.s.PGSQL.5432"
2019-09-07 13:04:21.324 -03 [3867] LOG: database system was shut down at 2019-09-07 00:20:25 -03
2019-09-07 13:04:21.332 -03 [3866] LOG: database system is ready to accept connections
2019-09-07 16:06:31.502 -03 [3866] LOG: worker process: logical replication launcher (PID 3873) exited with exit code 1
2019-09-07 16:06:31.506 -03 [3866] LOG: received smart shutdown request
2019-09-07 16:06:31.509 -03 [3866] LOG: received SIGHUP, reloading configuration files
2019-09-07 16:06:31.510 -03 [3868] LOG: shutting down
2019-09-07 16:06:31.538 -03 [3866] LOG: database system is shut down
2019-10-07 09:03:58.926 -03 [18898] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-10-07 09:03:58.930 -03 [18898] LOG: listening on Unix socket "/home/pablo/lappstack-7.1.25-0/postgresql/.s.PGSQL.5432"
2019-10-07 09:03:58.954 -03 [18899] LOG: database system was shut down at 2019-09-07 16:06:31 -03
2019-10-07 09:03:58.965 -03 [18898] LOG: database system is ready to accept connections
2019-10-07 18:09:05.080 -03 [18898] LOG: worker process: logical replication launcher (PID 18905) exited with exit code 1
2019-10-07 18:09:05.108 -03 [18898] LOG: received SIGHUP, reloading configuration files
2019-10-07 18:09:05.167 -03 [18898] LOG: received smart shutdown request
2019-10-07 18:09:05.180 -03 [18900] LOG: shutting down
2019-10-07 18:09:05.207 -03 [18898] LOG: database system is shut down
2019-10-24 00:09:32.287 -03 [17881] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-10-24 00:09:32.292 -03 [17881] LOG: listening on Unix socket "/home/pablo/lappstack-7.1.25-0/postgresql/.s.PGSQL.5432"
2019-10-24 00:09:32.318 -03 [17882] LOG: database system was shut down at 2019-10-07 18:09:05 -03
2019-10-24 00:09:32.326 -03 [17881] LOG: database system is ready to accept connections
2019-10-24 01:52:53.656 -03 [31570] FATAL: terminating connection due to administrator command
2019-10-24 01:52:53.656 -03 [31583] FATAL: terminating connection due to administrator command
2019-10-24 01:52:53.658 -03 [17881] LOG: worker process: logical replication launcher (PID 17888) exited with exit code 1
2019-10-24 01:52:53.658 -03 [17881] LOG: received smart shutdown request
2019-10-24 01:52:53.658 -03 [32378] FATAL: terminating connection due to administrator command
2019-10-24 01:52:53.658 -03 [32293] FATAL: terminating connection due to administrator command
2019-10-24 01:52:53.679 -03 [17883] LOG: shutting down
2019-10-24 01:52:53.702 -03 [17881] LOG: received SIGHUP, reloading configuration files
2019-10-24 01:52:53.825 -03 [17881] LOG: database system is shut down
2019-11-03 21:48:40.628 -03 [4433] LOG: could not bind IPv4 address "127.0.0.1": Address already in use
2019-11-03 21:48:40.628 -03 [4433] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2019-11-03 21:48:40.628 -03 [4433] WARNING: could not create listen socket for "127.0.0.1"
2019-11-03 21:48:40.628 -03 [4433] FATAL: could not create any TCP/IP sockets
2019-11-03 21:48:40.628 -03 [4433] LOG: database system is shut down
2019-11-03 21:50:06.433 -03 [5047] LOG: could not bind IPv4 address "127.0.0.1": Address already in use
2019-11-03 21:50:06.433 -03 [5047] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2019-11-03 21:50:06.433 -03 [5047] WARNING: could not create listen socket for "127.0.0.1"
2019-11-03 21:50:06.433 -03 [5047] FATAL: could not create any TCP/IP sockets
2019-11-03 21:50:06.433 -03 [5047] LOG: database system is shut down
2019-11-03 21:50:16.815 -03 [5122] LOG: could not bind IPv4 address "127.0.0.1": Address already in use
2019-11-03 21:50:16.815 -03 [5122] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2019-11-03 21:50:16.816 -03 [5122] WARNING: could not create listen socket for "127.0.0.1"
2019-11-03 21:50:16.816 -03 [5122] FATAL: could not create any TCP/IP sockets
2019-11-03 21:50:16.816 -03 [5122] LOG: database system is shut down
2019-11-03 21:55:01.499 -03 [8036] LOG: could not bind IPv4 address "127.0.0.1": Address already in use
2019-11-03 21:55:01.499 -03 [8036] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2019-11-03 21:55:01.499 -03 [8036] WARNING: could not create listen socket for "127.0.0.1"
2019-11-03 21:55:01.499 -03 [8036] FATAL: could not create any TCP/IP sockets
2019-11-03 21:55:01.499 -03 [8036] LOG: database system is shut down
2019-11-03 22:39:04.658 -03 [10664] LOG: could not bind IPv4 address "127.0.0.1": Address already in use
2019-11-03 22:39:04.658 -03 [10664] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2019-11-03 22:39:04.659 -03 [10664] WARNING: could not create listen socket for "127.0.0.1"
2019-11-03 22:39:04.659 -03 [10664] FATAL: could not create any TCP/IP sockets
2019-11-03 22:39:04.659 -03 [10664] LOG: database system is shut down
2019-11-09 16:30:39.445 -03 [4179] LOG: could not bind IPv4 address "127.0.0.1": Address already in use
2019-11-09 16:30:39.445 -03 [4179] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2019-11-09 16:30:39.446 -03 [4179] WARNING: could not create listen socket for "127.0.0.1"
2019-11-09 16:30:39.446 -03 [4179] FATAL: could not create any TCP/IP sockets
2019-11-09 16:30:39.446 -03 [4179] LOG: database system is shut down

Gracias
Pablo

jota 2019-11-12 12:07:04 UTC #6

Hola @pablosarg,

Parece que hay un PostgreSQL ejecutandose en la maquina actualmente

27396 /usr/lib/postgresql/10/bin/postgres
27888 /usr/lib/postgresql/11/bin/postgres
28284 /usr/lib/postgresql/12/bin/postgres

¿puedes parar esos servicios del sistema e intentar arrancar el PostgreSQL de Bitnami? En el caso de que estes usándolos, tendrás que cambiar el puerto del PostgreSQL de Bitnami en su fichero de configuración (/home/pablo/lappstack-7.1.25-0/postgresql/data/postgresql.conf)

Espero que sea util esta información

system 2020-01-14 19:38:40 UTC #7

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!