Deleted user 'postgres' - oops

Question

I accidentally deleted the user 'postgres' user the #userdel command and no longer have access to the database.

What can I do to create a new postgres user and how can I start postgresql again?

If I have to re-install postgresql, do I just delete my current postgres setup by removing the /usr/local/postgresql-8.3.6/ directory?

NOTE: I have no idea how to start postgresql. I basically downloaded a gzip file and unloaded it into a directory /usr/local/postgresql-8.3.6

Maybe belongs on Serverfault?

Stefan Mai
– Stefan Mai

2009-07-01 04:20:21 +00:00
Commented Jul 1, 2009 at 4:20 — Stefan Mai
– Stefan Mai, Commented Jul 1, 2009 at 4:20

Milen A. Radev · Accepted Answer · 2009-07-01 11:02:33Z

2

Recreate the user - there's nothing special about it. Except it has no password ("!" in the password field in "/etc/shadow"), but that's normal for service accounts.

And you need this system account only for running the service.

If you have downloaded the source ("I basically downloaded a gzip file...") then you need to follow the installation instructions here to make a working installation out of it.

Easier would be to install the provided pre-packaged version of Postgres from Debian:

apt-get install postgresql-8.3 postgresql-contrib-8.3

answered Jul 1, 2009 at 11:02

Milen A. Radev

63.1k22 gold badges111 silver badges112 bronze badges

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

Collectives™ on Stack Overflow

Deleted user 'postgres' - oops

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