* Anuj Pankaj wrote:
Please help to run my postgres on remote manchine through pgAdmin III.
Do you have a firewall on the database server or anywhere between your
Windows client and the database server that might be blocking the
connections?
--
Christian
--
Sent via pgsql-admin mailing li
Below is the output by running the command (ps ax | grep [p]ost)
1118 ?S 0:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
1120 ?S 0:00 postgres: logger process
1122 ?S 0:00 postgres: writer process
1123 ?S 0:00 postgres: stats bu
Is it really running? (run ps ax | grep [p]ost)
2010/9/29 Anuj Pankaj
> Ya, I have restarted the server by "service postgresql restart". I am
> getting OK sign.
>
> Regards,
> Anuj Pankaj
>
>
> -Original Message-
> From: Devrim GÜNDÜZ [mailto:dev...@gunduz.org]
> Sent: Wednesday, Septemb
Thank you for your response!
So I guess what's happening is that the old symlink from 3 weeks ago
(generated by pg_standby -l) is now stuck in the primary's pg_xlog, and gets
repeatedly recycled and renamed to be a new WAL file. I checked the mod
date of the target of the symlink, and confirmed t
Ya, I have restarted the server by "service postgresql restart". I am getting
OK sign.
Regards,
Anuj Pankaj
-Original Message-
From: Devrim GÜNDÜZ [mailto:dev...@gunduz.org]
Sent: Wednesday, September 29, 2010 6:42 PM
To: Anuj Pankaj
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN]
On Wed, 2010-09-29 at 18:26 +0530, Anuj Pankaj wrote:
>
> I modified listen_addresses = '*' in Postgresql.conf and however If I
> try to access postgres through pgAdmin III. I am sticking with an
> exception.
Did you restart PostgreSQL after the change?
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Con
Hi,
I installed Postgres 8.1.4 on Linux and postgres server is running and I
successfully created database on local machine.
I modified listen_addresses = '*' in Postgresql.conf and however If I
try to access postgres through pgAdmin III. I am sticking with an
exception.
Exception is:
cou
W dniu 2010-09-29 10:56, Guillaume Lelarge pisze:
Using rar on the data folder should work if you don't have tablespaces.
If you have some, add them to your data rar archive.
And instead of overwriting the data folder on the slave, wipe out your
old data folder and recreate it by restoring you
On Wed, Sep 29, 2010 at 7:18 PM, JSPrabu wrote:
> Hi Support,
>
>
>
> Please help for the following issues which I am facing with migration and
> replication process of oracle to EnterpriseDB database.
>
>
>
> 1) While migrating tables from oracle to edb database, I am facing
> “*invalid
>
Hi,
Earlier, I had installed Postgres 8.1.9 on Linux and then uninstalled
the same(Postgres 8.1.9) .
Now I have installed the Postgres 8.1.4 and while running up server, I
am getting error.
I have logged in as Postgres user and it takes me to Bash Shell and then
I fired the following commands
Hi Support,
Please help for the following issues which I am facing with migration and
replication process of oracle to EnterpriseDB database.
1) While migrating tables from oracle to edb database, I am facing
"invalid byte sequence for encoding utf8" error.
Actually I am migrating th
Le 29/09/2010 10:16, Michal Glowacki a écrit :
> Fujii, I believe I should follow this (from documentation):
>
>
>
> The procedure for making a base backup is relatively simple:
>
> 1.
>
> Ensure that WAL archiving is enabled and working.
>
> 2.
>
> Con
Fujii, I believe I should follow this (from documentation):
The procedure for making a base backup is relatively simple:
1.
Ensure that WAL archiving is enabled and working.
2.
Connect to the database as a superuser, and issue the command
SELECT
On Wed, Sep 29, 2010 at 4:52 PM, Michal Glowacki wrote:
>
> I try to do it on two machines, my computer and local server. My system is
> Windows 7 64bit, standby is XP professional sp2 64bit. Both machines run
> postgres 9.0.0. I tried dump, dump_all, pgadmin III's backup and restore -
> nothing w
hi,
I wanted to take new feature of postgres 9 into action - hot standby.
However for some days I am still struggling with starting hot standby
server. I have set up everything as mentioned in Postgres Tutorial, on
master and standby. All the time I get:
2010-09-27 15:56:22 CEST LOG: data
On Tue, Sep 28, 2010 at 5:31 PM, osman mohamad wrote:
> when I create a user "user1" and give this user the permissions on
> a database "db1" (including login privilage),
>
> this user can access all databases although it doesn't have the privilges
> (even after implmenting the revoke command)
>
when I create a user "user1" and give this user the permissions on
a database "db1" (including login privilage),
this user can access all databases although it doesn't have the privilges
(even after implmenting the revoke command)
on the other hand, any user can access the database "db1"
after lo
Hello,
We're running PG 8.3 in a warm standby configuration. About 3 weeks ago we
had to fail over from the primary to the standby. That worked fine, but
we're having problems getting standby mode set up again. On the standby,
everything works fine for a little while: WALs are rsynced over and
Hi,
On Installing using One-Click Installer The stack-builder shows an error
message "Failed to open application list
http://www.postgresql.org/applications-v2.xml Error: The URL specified
could not be opened." Even after setting the proxy used in the IE
tools->options menu, the same message is s
Hello Fujii,
Sorry for the delay in my response, and thank you very much for the help.
I did not have the server configured to be a hot_standby in the
postgresql.conf, and once I did replication is working perfectly for me.
-Joe
On Thu, Sep 23, 2010 at 8:48 AM, Fujii Masao wrote:
> On Thu,
20 matches
Mail list logo
