SQL

postgresql server restart

sudo service postgresql start

how to restart psql in linux

sudo service postgresql restart
# To restart the postgresql service

restart postgresql

sudo /etc/init.d/postgresql restart

restart postgres

sudo systemctl restart postgresql-13.service

restart pk sql postgres

ALTER SEQUENCE <tablename>_<id>_seq RESTART WITH 1

restart postgreSql from terminal

            
                
            
         pg_ctl -D "C:Program FilesPostgreSQL12data" restartCode language: JavaScript (javascript)

how to restart postgres server on windows

#for windows:
Press Windows key + R, ‘RUN’ box will appear.
Type services.msc in the Run box and hit enter.
Services window will open, search for postgresql-13. Here 13 is the version of PostgreSQL installed in the window machine.
Right-click on the postgresql-13 and click on the restart option.
The services will restart now.
This is how we can restart PostgreSQL services in windows machines.
#source: https://sqlserverguides.com/restart-postgres/

restart pk sql postgres

ALTER SEQUENCE users_id_seq RESTART WITH 1