On Thu, Oct 14, 2010 at 1:39 AM, Vishnu S. wrote:
> drop node(id = 1, event node = 2);
once you've dropped the node, you need to re-initialize it from
scratch. just follow the slony procedures for adding a new node to
your replication cluster after you "dropdb" the database from that
machine.
a
Hi,
I am using Slony-I for database replication.
When the master machine is failed, the slave machine is promoted to
master. The script used for this is as below,
cluster name = sql_cluster;
node 1 admin conninfo = 'dbname=postgres host=10.1.20.55 port=5432
user=postgres';
node 2 adm
On Thu, Sep 30, 2010 at 5:09 AM, Vishnu S. wrote:
> On starting the server using pg_ctl command the following message is shown.
>
>
>
> server starting
>
>
>
> C:\Program Files\PostgreSQL\8.4\bin>2010-09-30 14:36:07 ISTLOG: could not
> create file "postmaster.opts": Permission denied.
>
Are you
Hi,
On starting the server using pg_ctl command the following message is
shown.
server starting
C:\Program Files\PostgreSQL\8.4\bin>2010-09-30 14:36:07 ISTLOG: could
not create file "postmaster.opts": Permission denied.
Thanks & Regards,
Vishnu S
From: Sachin S
Hi,
I have uninstalled the PostgreSQL 8.4 and removed the related
directories from the system. Again I have installed the PostgreSQL 8.4
on the same folder. Now the PostgreSQL server is not starting. When I
tried to start the postgreSQL service from the Windows Service manager,
the following
[Please keep the thread on the mailing list]
From the logs, the initdb is successful but there were some error while
creating the postgres service. I believe you are not using the latest 8.4.4
installer as that installer has some detailed logging which is helpful in
realizing where exactly is
Can you send the installation log (%TEMP%\install-postgresql.log)?
In case, Have you used the uninstaller to uninstall the previous instance or
manually removed the directories?
On Sep 30, 2010, at 12:53 PM, Vishnu S. wrote:
> Hi,
>
>
> I have uninstalled the PostgreSQL 8.4 and removed the
