Re: [ADMIN] Database just hangs at startup

I'd hate to contradict Tom, and since ^ is probably a typo, and you likely meant *, yes, that's likely, but be sure you understand the implications of listening on all interfaces first. Just saying from an IT point of view.Tom Lane wrote:Terry Khatri writes: > I am having problems making any c

Re: [ADMIN] Database just hangs at startup

Terry, It looks like typo in local line in pg_hba.conf. I work in pg8.4 and 9.1 but I think that there is nothing like 'trustit' in pg_hba.conf file in 9.2. *local all all trustit *Change this to *local all all trust * Regards, Vipul Shah On Tue, Oct 16, 2012 at 5:18 PM, Scott Whitney wrote:

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

On Wed, Oct 3, 2012 at 4:53 PM, Greg Williamson wrote: > > Indeed -- stopping repmgr has lef to a continued accumulation of the dead but > not gone file handles, but almost all are now owned by the application, with > only a few held by WAL shipping and the like. So repmgr was just getting the

[ADMIN] pg_dump out of memory

Dear All, I am running a PostgreSQL 8.3 server (not my choice, would prefer 9.1) but I am experiencing memory issues when using pg_dump. I have looked on the forums for memory issues, and can say that the data is not corrupt. We are running a VM with RHEL6, 4GB RAM, 2CPU and 80GB HDD Does any

Re: [ADMIN] pg_dump out of memory

Neil Morgan writes: > I am running a PostgreSQL 8.3 server (not my choice, would prefer 9.1) but I > am experiencing memory issues when using pg_dump. 8.3.what? > Does anyone have any ideas please? For starters, turn on log_statements so you can see what query is triggering this. It'd be even

[ADMIN] Postgresql switch over process

Can somebody tell me how we can automate the switch over process, I know there is once file recovery.conf which contains the parameter trigger_file. But my question is what code that file containsHope my thinking is correct. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) T

Re: [ADMIN] Postgresql switch over process

On 10/17/2012 3:20 PM, Shams Khan wrote: Can somebody tell me how we can automate the switch over process, I know there is once file recovery.conf which contains the parameter trigger_file. But my question is what code that file containsHope my thinking is correct. The trigger file itself

[ADMIN] Streaming Replication (Master Delta Sync)

Hi We are using streaming replication for c++ Postgres-9.1 server. We have setup 1 master and 1 slave and streaming replication is working fine. On checking the x-log status for both master and slave, we observed that the master is quite ahead of the slave all the time. Now we have 2 questions

[ADMIN] WAL corruption while replication

Hi, How to recover, if master postgres WAL got corrupted before it is applied to the standby server? Will I loose all the data present in the WAL segment? How can I partially apply the WAL? Regards, Parkirat Singh Bagga. -- View this message in context: http://postgresql.1045698.n5.nabble.

Re: [ADMIN] Streaming Replication (Master Delta Sync)

Also, does the start or fast failover based on the content of trigger file apply to Steaming replication as well? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-Replication-Master-Delta-Sync-tp5728704p5728706.html Sent from the PostgreSQL - admin mailing list

Re: [ADMIN] Streaming Replication (Master Delta Sync)

On Wed, Oct 17, 2012 at 1:34 PM, Parkirat Bagga wrote: > Hi > > We are using streaming replication for c++ Postgres-9.1 server. > > We have setup 1 master and 1 slave and streaming replication is working > fine. > > On checking the x-log status for both master and slave, we observed that the > mas

Re: [ADMIN] Streaming Replication (Master Delta Sync)

Thanks Netllama for the reply. Does rsysc sync's the partial logs as well. As I would be doing the rsync from old master to new master (when the old master recovers), there might be some partial logs present in the old master? Delay is there because both the machines are on cloud and they are in

Re: [ADMIN] Streaming Replication (Master Delta Sync)

On Wed, Oct 17, 2012 at 2:01 PM, Parkirat Bagga wrote: > Thanks Netllama for the reply. > > Does rsysc sync's the partial logs as well. As I would be doing the rsync > from old master to new master (when the old master recovers), there might be > some partial logs present in the old master? I don

Re: [ADMIN] Streaming Replication (Master Delta Sync)

Thanks for the clarifications. For the slow link path, we don't have much option as the data transfer happens over the internet. I was trying to figure out the ways to reduce the gap as less as possible, for which I have read somewhere that we should have a sufficient value for max_wal_sender, an

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

fantastic ! thanks. greg > > From: Jaime Casanova >To: Greg Williamson >Cc: "pgsql-admin@postgresql.org" >Sent: Wednesday, October 17, 2012 10:05 AM >Subject: Re: [ADMIN] Database size stays constant but disk space keeps >shrinking -- postgres 9.1 > >On W

[ADMIN] Migration from Postgresql 9 to Oracle 10g

Hi Experts, I am in the process of migration from PG 9 to oracle. All of the database objects has been migrated apart from functions. The main issue I am facing with function code where DML statements are used in the code. On the other side, Oracle doesn't support DML's in functions or procedures.