Обсуждение: Default UID for postgres user in linux
Hi All,
--
--Regards
RAMAKRISHNAN KANDASAMY
While installing postgres, a user named "postgres" will be automatically created.
What is the default UID for postgres user in linux ?
--Regards
RAMAKRISHNAN KANDASAMY
On 04/09/2014 06:28 AM, Rama Krishnan wrote: > Hi All, > > While installing postgres, a user named "postgres" will be > automatically created. > What is the default UID for postgres user in linux ? > There isn't one. PostgreSQL isn't in charge of assigning user-names or passwords and the user under which it runs does not have to be postgres. Many Linux distributions will create a "postgres" user with PostgreSQL is installed but the UID can vary depending on distribution and the order that services were installed. I just looked at a few of my machines and found UIDs of 114, 106, 107, 26, ... and a similar variation in GID. Cheers, Steve
Thanks all,
Actually I am trying to setup a postgres failover using common setup.
I.e,
A postgres data directory is stored in central location.
Two postgres uses the same location
If One postgres down and the other will start....
The problem is, If the postgres users in the two machines has different UID's then i need to change ownership of data directory every time -- which takes long time
If din't change ownership of data directory then i am getting access denied errors ..
So if the both users have same UID's then there is no issue.
On Sat, Apr 12, 2014 at 12:46 AM, Steve Crawford <scrawford@pinpointresearch.com> wrote:
On 04/09/2014 06:28 AM, Rama Krishnan wrote:There isn't one. PostgreSQL isn't in charge of assigning user-names or passwords and the user under which it runs does not have to be postgres.Hi All,
While installing postgres, a user named "postgres" will be automatically created.
What is the default UID for postgres user in linux ?
Many Linux distributions will create a "postgres" user with PostgreSQL is installed but the UID can vary depending on distribution and the order that services were installed. I just looked at a few of my machines and found UIDs of 114, 106, 107, 26, ... and a similar variation in GID.
Cheers,
Steve
--Regards
RAMAKRISHNAN KANDASAMY
On 04/14/2014 09:18 PM, Rama Krishnan wrote: > Thanks all, > > Actually I am trying to setup a postgres failover using common setup. > > I.e, > A postgres data directory is stored in central location. > Two postgres uses the same location > If One postgres down and the other will start.... > > The problem is, If the postgres users in the two machines has > different UID's then i need to change ownership of data directory > every time -- which takes long time > If din't change ownership of data directory then i am getting access > denied errors .. > > So if the both users have same UID's then there is no issue. > > The postgres user is what most distros install but PostgreSQL can run under pretty much any user. You will have to use care in how you install (everything from the same base image, for instance) or do some after-install tweaking of UIDs to make sure they match on all machines. But... I think you should explain your reasoning, setup and use-case more fully to get ideas from the community. In most cases the part most likely to fail or get corrupted is the storage - far more likely than the CPU/RAM/etc.. It seems that your setup has the storage as a single point of failure. Unless you are very careful, you risk the possibility of both PostgreSQL servers trying to connect to the same storage which will not end well. You will also need to be sure to match not only UID but machine type, architecture and OS. Don't assume that the files will be identical between, say, 32-bit Windows and 64-bit Linux or even the same OS installed on different CPU families. Without more info it's hard to tell but it's possible that replication or other solutions may better address your end goal. Cheers, Steve