Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

restarting of postgresql server when not connecting to default port

~$ sudo chown postgres.postgres /var/lib/postgresql/12/main/global/pg_internal.init
~$ sudo rm -rf 12/main/global/pg_internal.init
~$ sudo rm -rf /var/lib/postgresql/12/main/pg_logical/replorigin_checkpoint
~$ sudo -i -u postgres
~$ /usr/lib/postgresql/12/bin/pg_ctl restart -D /var/lib/postgresql/12/main
Source by askubuntu.com #
 
PREVIOUS NEXT
Tagged: #restarting #postgresql #server #connecting #default #port
ADD COMMENT
Topic
Name
1+5 =