pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert Lor <Robert.Lor@Sun.COM>
To: Jignesh K. Shah <J.K.Shah@Sun.COM>
Cc: Thomas Bräutigam <thomas.braeutigam@nexustelecom.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Remove Postgres from Solaris 10
Date: Tue, 29 Apr 2008 15:48:14 -0500
Message-ID: <4817898E.9070701@sun.com> (raw)
In-Reply-To: <48168B9A.8060704@sun.com>
References: <46F5921DF52F6E40860287B30CADADC78172B9@EROS.nexus-ag.com>
	<48168B9A.8060704@sun.com>

There are a couple of options you can take to accomplish this.

1) Remove the role by running ¨roledel postgres¨ . This will remove 
postgres from /etc/passwd and /etc/user_attr, and you can use useradd to 
add postgres as a user.

2) Modify ¨postgres¨ from being a role to user. Below are the steps I use:

    a) run ¨passwd -d postgres¨
    b) edit /etc/user_attr and change type for ¨postgres¨  from ¨role¨ 
to ¨user¨
    c) create a home dir for postgres if needed
    d) use the usermod command to change the home dir and shell


-Robert


Jignesh K. Shah wrote:
> I guess what you mean is to remove the "role" postgres so that you can 
> redefine it as a normal user and not remove the binaries that are 
> installed with Postgres as they can be overridden by having right PATH 
> variables
>
> Its easy... Modify /etc/user_attr and remove type=role from the 
> postgres line and modify /etc/passwd to set a home path and change 
> default shell to /bin/sh or /bin/bash and set password for it.. and 
> now you have a normal user..
> Is this what you are trying to do?
>
> -Jignesh
>
>
> Thomas Bräutigam wrote:
>> Hello all,
>>  
>> I have a software solution with a postgres database. The user 
>> postgres is abolutly needed for my software.
>>  
>> With Solaris 10, Postgres is automatically installed and uses the 
>> user postgres. How can I easily remove the current postgres install 
>> from this Solaris 10? Is there a process which is provided from 
>> Solaris to remove it? Whats the best way to do it?
>>  
>> Thank you for your help.
>>  
>> Cheers Thomas
>> ** 




view thread (19+ messages)  latest in thread

Message-ID: <4817898E.9070701@sun.com>
Permalink:  ../4817898E.9070701@sun.com/
Also on:    postgresql.org/message-id/4817898E.9070701@sun.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Robert.Lor@Sun.COM, J.K.Shah@Sun.COM, thomas.braeutigam@nexustelecom.com
  Subject: Re: Remove Postgres from Solaris 10
  In-Reply-To: <4817898E.9070701@sun.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox