Re: [ADMIN] FATAL: the database system is starting up

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

Re: [ADMIN] Slony-I installation Package compatible with PostgreSQL 8.4

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

[ADMIN] Why are some WAL files in pg_xlog symlinks to old files?

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

[ADMIN] question about phppgadmin

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 login,

Re: [ADMIN] question about phppgadmin

On Tue, Sep 28, 2010 at 5:31 PM, osman mohamad osma...@ieee.org 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

[ADMIN] Hot standby server does not start

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:

Re: [ADMIN] Hot standby server does not start

On Wed, Sep 29, 2010 at 4:52 PM, Michal Glowacki mg.scan...@gmail.comwrote: 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

Re: [ADMIN] Hot standby server does not start

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

[ADMIN] Reg: invalid byte sequence for encoding utf8 0x00

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

Re: [ADMIN] Old database format..

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

Re: [ADMIN] Reg: invalid byte sequence for encoding utf8 0x00

On Wed, Sep 29, 2010 at 7:18 PM, JSPrabu psudhar...@iradcle.com 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

Re: [ADMIN] Hot standby server does not start

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

[ADMIN] could not connect to server: Connection refused (0x0000274D/10061)

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:

Re: [ADMIN] could not connect to server: Connection refused (0x0000274D/10061)

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

Re: [ADMIN] could not connect to server: Connection refused (0x0000274D/10061)

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]

Re: [ADMIN] could not connect to server: Connection refused (0x0000274D/10061)

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

Re: [ADMIN] could not connect to server: Connection refused (0x0000274D/10061)

* 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