Shell script to drop PostgreSQL database

Question

I use these commands:

su - postgres // change user to 'postgres'
dropdb db1    // drop database 'db1'
exit          // change user back to root

These commands work well from console, so I created a small sh file with the same lines and added a -x chmod to execute the file. However, when I execute the Script, only the first line and changes the user to postgres and stops there with the blinking cursor. Then, if I type exit to return back to root, it shows the message: dropdb: error: could not connect to database template1: FATAL: role "root" does not exist.

How can I get this working?

Try PGUSER=postgres dropdb db1.

kometen
– kometen

2022-01-05 15:14:42 +00:00
Commented Jan 5, 2022 at 15:14 — kometen
– kometen, Commented Jan 5, 2022 at 15:14
…or simply dropdb -u postgres db1

Bergi
– Bergi

2022-01-05 15:24:41 +00:00
Commented Jan 5, 2022 at 15:24 — Bergi
– Bergi, Commented Jan 5, 2022 at 15:24

Joe Almore · Accepted Answer · 2022-01-06 17:17:56Z

1

#!/bin/bash
sudo -u postgres psql -c 'drop database IF EXISTS test'
exit

edited Jan 6, 2022 at 17:17

Joe Almore

4,36910 gold badges57 silver badges83 bronze badges

answered Jan 5, 2022 at 15:51

jian

5,0131 gold badge29 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Shell script to drop PostgreSQL database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related