-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Thomas Bräutigam
Enviado el: martes, 29 de abril de 2008 23:10
Para: Joshua D. Drake
CC: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] Remove Postgres from Solaris 10
Hi Joshua,
I think I have to
Thomas Bräutigam wrote:
That's the issue, the database is not running which gets delivered with Solaris
10 but I am not sure if the my customer accidently activates it or not, so I
want to be on the safe side of live, that I minimize this risk.
In that case, just pick a non default port for
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 20:25
To: Thomas Bräutigam
Cc: [EMAIL PROTECTED]; Joshua D. Drake; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from Solaris 10
Thomas Bräutigam wrote:
> Hi Jignesh
>
> What things do I all need to ta
Thomas Bräutigam wrote:
Hi Jignesh
What things do I all need to take care when I want to run both postgres
databases on the same box. Like the Solaris 10 postgres db and my postgres db.
By default the Postgres versions that are shipped with Solaris are
disabled (run "svcs postgresql" to ver
al Message-
From: Igor Polishchuk [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 03:57
To: Joshua D. Drake; Thomas Bräutigam
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from Solaris 10
In our organization, we are running multi
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 05:58
To: Thomas Bräutigam
Cc: Joshua D. Drake; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from Solaris 10
Here are my two cents:
You dont want to remove
On Wed, 30 Apr 2008 05:10:00 +0200
Thomas Bräutigam <[EMAIL PROTECTED]> wrote:
> Hi Joshua,
>
> I think I have to explain it a little more detailed
>
> - my product uses a postgres database with the standart config (ports
> etc.)
> - with Solaris 10 postgres is already installed as standart
> -
rom: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 02:33
To: Thomas Bräutigam
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from Solaris 10
On Wed, 30 Apr 2008 01:59:08 +0200
Thomas Bräutigam <[EMAIL PROTECTED]&
Thomas
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 02:33
To: Thomas Bräutigam
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from Solaris 10
On Wed, 30 Apr 2008 01:59:08
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
On Wed, 30 Apr 2008 01:59:08 +0200
Thomas Bräutigam <[EMAIL PROTECTED]> 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 und
On Wed, 30 Apr 2008 02:00:42 +0200
Thomas Bräutigam <[EMAIL PROTECTED]> wrote:
> Hi Joshua,
>
> Why does it affect shmmax?
Because you would have two clusters access shared memory.
http://www.postgresql.org/docs/current/static/kernel-resources.html
Joshua D. Drake
--
The PostgreSQL Company
Hi Joshua,
Why does it affect shmmax?
Cheers Thomas
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 01:52
To: Thomas Bräutigam
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres
not the elegant version of doin it.
Cheers Thomas
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 30. April 2008 01:52
To: Thomas Bräutigam
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Remove Postgres from
On Wed, 30 Apr 2008 01:47:02 +0200
Thomas Bräutigam <[EMAIL PROTECTED]> 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 th
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
-Origina
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 ste
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
li
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 proces
19 matches
Mail list logo
