5

Force ID of user created by apt-get

view full story
linux-howto

http://serverfault.com – Context: I'm automatically installing postgresql-9.1 on an Ubuntu server with apt-get. This creates the required postgres user. The Postgres data is on an external volume that survives reinstalls. This data is obviously owned by the postgres user. The problem I'm having is that the ownership is not recorded under the name postgres, but under the UID that postgres had at creation time. When the server is reinstalled, postgres sometimes gets a different UID, and no longer owns the data directory, and thus does not work. Question: Can I force the UID of the user postgres created by apt-get (HowTos)

taskli's picture
Submitted by taskli on 06/19/2012 – Made popular on 06/19/2012

Stories similar to Force ID of user created by apt-get

I'm trying to get this command to work as the user postgres (so I can ship wal files):

rsync -a /tmp/test postgres@server2:/tmp/test

But I get the error:

Permission denied (publickey).

I've run ssh-keygen eval `ssh-agent` and ssh-add as postgres user on server1.

postgres 8.4 /Win7 64 42 weeks 2 days ago

I have a database on a hard drive from a computer whose motherboard died. The HD is fine.

I'm trying to XCOPY the data directory and overwrite the contents of a Postgres 8.4 data directory on another computer.

I'm getting Access Denied. I have verified that the Postgres service is stopped. The target computer has 2 user accounts, one of which is "Postgres" which the Postgres install created.

What are the permissions for /var/lib/pgsql? A fresh yum install of postgresql-server sets the directory and all subdirs to postgres:postgres 700. I believe all files in /var/lib/pgsql/data after... [by Winter]

I need to compile and install postgresql from source code in a fresh install, no use of apt-get or dpkg and no postgres user created yet. Compiling and installing is already done, i need those script to start and stop the postgresql service and the creating of postgres user the exactly same way ubuntu does.

Edit: see comment for answer.

I have an interesting question. On my OS X 10.8 server postgres is running fine.

Launchd has is loaded under the label 'org.postgresql.postgres' and '# launchctl list org.postgresql.postgres' gives the output I expected.

The problem is: I cant find the configuration file. In /S/L/LaunchDeamons and in /L/LaunchDeamons I only have an 'org.postgresql.postgres_alt.plis

When you initialize the new database as the postgres user:initdb --lc-collate <insert 9.1 collate here> -D /var/lib/postgres/data

Archaiic https://bbs.archlinux.org/profile.php?id=50927

2012-10-01T04:37:16Z

I have installed Postgres 9.1.4 on an Ubuntu 12.04 (precise) 64-bit from here http://www.openscg.com/se/postgresql/packages.jsp, but right after installing many commands (programs) are throwing these following warnings in different combinations:

/opt/postgres/9.1/lib/libxml2.so.2: no version information available /opt/postgres/9.1/lib/libcrypto.so.1.0.0: no version information available /opt/pos

I have a PostgreSQL server running on a remote Debian Squeeze server. I would like to login with the user postgres using the ident and md5 method at the same time. The former is needed for debian maintenance.

postgres logfile 23 weeks 3 days ago

I have installed postgres on f18 x86_64 with the following packages

rpm -qa | grep postgres postgresql-libs-9.2.2-1.fc18.x86_64 postgresql-server-9.2.2-1.fc18.x86_64 postgresql-9.2.2-1.fc18.x86_64

These are the instructions I could find to setup and start postgres

su - cd /usr/lib64/pgsql su postgres

$ initdb -D /var/lib/pgsql/data $ pg_ctl -D /v