SEO

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

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
> **

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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
>> **


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Hi Jignesh,

But than I have the problem that I have 2 installations of postgres with default settings on one machine. Is it possible to have two installations with default settings on one machine?

Do they not interrupt each other with ports or something else....?

Cheers Thomas



-----Original Message-----
From: J.K.Shah@Sun.COM [mailto:J.K.Shah@Sun.COM]
Sent: Dienstag, 29. April 2008 04:45
To: Thomas Bräutigam
Cc: Robert.Lor@Sun.COM; pgsql-admin@postgresql.org
Subject: Re: Remove Postgres from Solaris 10

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
> **



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

On Wed, 30 Apr 2008 01:47:02 +0200
Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> wrote:

> Hi Jignesh,
>
> But than I have the problem that I have 2 installations of postgres
> with default settings on one machine. Is it possible to have two
> installations with default settings on one machine?
>
> Do they not interrupt each other with ports or something else....?

You will want to change the ports they run on. It may also affect your
kernel settings such as shmmax.

Joshua D. Drake


--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIF7S6ATb/zqfZUUQRAriPAJ95tGjJKn8LEpRoHsrmYDFO8NuA0ACZAWea
V+DDOotJ4hd2mhlUZ/Ua4LU=
=1gL2
-----END PGP SIGNATURE-----

Hi Joshua

The problem is this that I need this ports for my default postgres database.

Is it than possible to have 2 default postgres databases in parallel? Same ports etc.....?

Right now I just used the hammer method and removed the packages from the Solaris 10 version, but this seem to be not the elegant version of doin it.

Cheers Thomas

-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Mittwoch, 30. April 2008 01:52
To: Thomas Bräutigam
Cc: J.K.Shah@Sun.COM; Robert.Lor@Sun.COM; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from Solaris 10

On Wed, 30 Apr 2008 01:47:02 +0200
Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> wrote:

> Hi Jignesh,
>
> But than I have the problem that I have 2 installations of postgres
> with default settings on one machine. Is it possible to have two
> installations with default settings on one machine?
>
> Do they not interrupt each other with ports or something else....?

You will want to change the ports they run on. It may also affect your kernel settings such as shmmax.

Joshua D. Drake


--
The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQLCommunity Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate





--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Hi Joshua,

Why does it affect shmmax?

Cheers Thomas


-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Mittwoch, 30. April 2008 01:52
To: Thomas Bräutigam
Cc: J.K.Shah@Sun.COM; Robert.Lor@Sun.COM; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from Solaris 10

On Wed, 30 Apr 2008 01:47:02 +0200
Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> wrote:

> Hi Jignesh,
>
> But than I have the problem that I have 2 installations of postgres
> with default settings on one machine. Is it possible to have two
> installations with default settings on one machine?
>
> Do they not interrupt each other with ports or something else....?

You will want to change the ports they run on. It may also affect your kernel settings such as shmmax.

Joshua D. Drake


--
The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQLCommunity Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate





--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

On Wed, 30 Apr 2008 02:00:42 +0200
Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> wrote:

> Hi Joshua,
>
> Why does it affect shmmax?

Because you would have two clusters access shared memory.

http://www.postgresql.org/docs/curre...resources.html

Joshua D. Drake


--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIF7h/ATb/zqfZUUQRAp/1AJ9JIR3P1/qYqZyIQlVj9ThONX6uowCgj599
i56tPuwHndxvZ8H8aoJbs2k=
=ehQ3
-----END PGP SIGNATURE-----

On Wed, 30 Apr 2008 01:59:08 +0200
Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> wrote:

> Hi Joshua
>
> The problem is this that I need this ports for my default postgres
> database.
>
> Is it than possible to have 2 default postgres databases in parallel?
> Same ports etc.....?

I am afraid I don't understand what you are asking. You can't have two
postgresql installations bound to the same port. You can have two
postgresql installations pointing to different ports on the same
machine.

Joshua D. Drake


--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIF75CATb/zqfZUUQRAufwAJ0Rtq9I3l4PIUijA7ZeBeXFY2EkEwCgpOcC
BgZ6owMspUb2qOmZVkrLyds=
=FtNa
-----END PGP SIGNATURE-----

In our organization, we are running multiple databases on the same box on
the default port. However, they all have their own data directories and they
listen on different VIP's. Here are the parameters in postrgresql.conf to
make it work:

unix_socket_directory = 'data directory for a particular DB here'
listen_addresses = 'VIP here'
port = 5432


On 4/29/08 5:33 PM, "Joshua D. Drake" <jd@commandprompt.com> wrote:

> On Wed, 30 Apr 2008 01:59:08 +0200
> Thomas Bräutigam <thomas.braeutigam@nexustelecom.com> wrote:
>
>> Hi Joshua
>>
>> The problem is this that I need this ports for my default postgres
>> database.
>>
>> Is it than possible to have 2 default postgres databases in parallel?
>> Same ports etc.....?
>
> I am afraid I don't understand what you are asking. You can't have two
> postgresql installations bound to the same port. You can have two
> postgresql installations pointing to different ports on the same
> machine.
>
> Joshua D. Drake
>

--



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin