Re: [GENERAL] authentication failure

On Sat, Jan 4, 2014 at 1:29 PM, Jayadevan M wrote: > There is only one instance - > > ps -eaf | grep bin/postgres | grep -v grep > postgres 3203 1 0 2013 ?00:02:04 /usr/pgsql-9.3/bin/postgres > This only tells that there is one instance running! There could be multiple PostgreSQL

[GENERAL] help interpreting pg_stat_user_index view values

Need some help interpreting the results of queries against the pg_stat_user_index view. Given the following four contrieved indexes and their scan, read and fetch values in pg_stat_user_index view: Index name idx_scan idx_tup_read idx_tup_fetch idx1 100

Re: [GENERAL] authentication failure

Log entries for 3 situations - 2 successful and one failed attempt - >From non-chroot, shell user postgres 2014-01-05 10:11:58 IST [17008]: [2-1] user=postgres,db=postgres LOG: connection authorized: user=postgres database=postgres 2014-01-05 10:12:03 IST [17008]: [3-1] user=postgres,db=postgres

Re: [GENERAL] file system level backup

On 01/04/2014 04:37 PM, zach cruise wrote: So is there anything in the Windows system logs? > looks like file system level backups don't work well on windows because they get corrupted during transfer. Whoa, how did we get to that conclusion? Does the Task Manager show another Postgres r

Re: [GENERAL] file system level backup

I am still not understanding. You have a 2008 server at a and one at b. You copied the Postgres data files from 2008 server a to 2008 server b. This did not work, so you say you restored the data directory on server b from an old copy of the data directory at b. So where did t

Re: [GENERAL] file system level backup

On 01/04/2014 02:13 PM, zach cruise wrote: I am still not understanding. You have a 2008 server at a and one at b. You copied the Postgres data files from 2008 server a to 2008 server b. This did not work, so you say you restored the data directory on server b from an old copy of the data direc

Re: [GENERAL] file system level backup

Questions: 1) Both servers are x64? > yes 2) What installation files(Graphical installer, source,etc)? > postgresql-9.3.0-1-windows-x64 from enterprisedb.com 3) Does the data directory have the config files? > yes however,

Re: [GENERAL] file system level backup

On 01/04/2014 01:20 PM, zach cruise wrote: Questions: 1) Both servers are x64? > yes 2) What installation files(Graphical installer, source,etc)? > postgresql-9.3.0-1-windows-x64 from enterprisedb.com 3) Does the data directory have the config files? > yes

Re: [GENERAL] file system level backup

Questions: 1) Both servers are x64? > yes 2) What installation files(Graphical installer, source,etc)? > postgresql-9.3.0-1-windows-x64 from enterprisedb.com 3) Does the data directory have the config files? > yes however, postgresql b won't start ("not listening")? 4) How are you start

Re: [GENERAL] Suddenly all tables were gone

On 01/04/2014 12:58 PM, Moshe Jacobson wrote: Ccing the list. On Sat, Jan 4, 2014 at 2:08 PM, Adrian Klaver mailto:adrian.kla...@gmail.com>> wrote: So we are looking at a fresh 9.3 cluster. So you created an 9.3 instance and then used pg_dump to transfer the data from the 9.1 inst

Re: [GENERAL] file system level backup

On 01/04/2014 12:54 PM, zach cruise wrote: so i installed 9.3 x64 on two windows 2008 servers from one set of installation files. then i created databases on postgresql a, shutdown all the servers, copied /data/ (from "show data_directory") from postgresql a to postgresql b. in short, i did a ful

[GENERAL] file system level backup

so i installed 9.3 x64 on two windows 2008 servers from one set of installation files. then i created databases on postgresql a, shutdown all the servers, copied /data/ (from "show data_directory") from postgresql a to postgresql b. in short, i did a full file system level backup ( http://www.postg

Re: [GENERAL] Suddenly all tables were gone

On 01/04/2014 10:15 AM, Moshe Jacobson wrote: On Fri, Jan 3, 2014 at 8:37 PM, Adrian Klaver mailto:adrian.kla...@gmail.com>> wrote: I know the database is gone now, still for the record it would be nice to know what the sequence of events where. You mentioned pg_dump and upgrade from

Re: [GENERAL] Possible multiprocess lock/unlock-loop problem in Postgresql 9.2

On Sat, 04 Jan 2014 19:40:31 +0100, Andrew Sullivan wrote: On Sat, Jan 04, 2014 at 07:07:08PM +0100, Yngve N. Pettersen wrote: I tried that before, but ran into some issues, IIRC a similar looping problem as this where queries never ended. I split it up in an attempt to solve that problem

Re: [GENERAL] Possible multiprocess lock/unlock-loop problem in Postgresql 9.2

On Sat, Jan 04, 2014 at 07:07:08PM +0100, Yngve N. Pettersen wrote: > I tried that before, but ran into some issues, IIRC a similar looping > problem as this where queries never ended. I split it up in an attempt to > solve that problem. Pulling the data out into the application and sending it bac

Re: [GENERAL] Suddenly all tables were gone

On Fri, Jan 3, 2014 at 8:37 PM, Adrian Klaver wrote: > I know the database is gone now, still for the record it would be nice to > know what the sequence of events where. You mentioned pg_dump and upgrade > from 9.1 -> 9.3. > So what was done and in what order? > First the conversion to 9.3, the

Re: [GENERAL] Possible multiprocess lock/unlock-loop problem in Postgresql 9.2

Hi, On Sat, 04 Jan 2014 16:23:42 +0100, Andrew Sullivan wrote: On Sat, Jan 04, 2014 at 12:14:42PM +0100, Yngve N. Pettersen wrote: The update query looks like this: UPDATE queue SET state = E'S' WHERE state = E'I' AND id IN () RETURNING id; There is a BEGIN/COMMIT wrap around the operati

Re: [GENERAL] Possible multiprocess lock/unlock-loop problem in Postgresql 9.2

On Sat, Jan 04, 2014 at 12:14:42PM +0100, Yngve N. Pettersen wrote: > The update query looks like this: > > UPDATE queue SET state = E'S' WHERE state = E'I' AND id IN ( of integers>) RETURNING id; > > There is a BEGIN/COMMIT wrap around the operation, including the > SELECT query. Am I right t

Re: [GENERAL] authentication failure

On 01/03/2014 09:29 PM, Jayadevan M wrote: There is only one instance - ps -eaf | grep bin/postgres | grep -v grep postgres 3203 1 0 2013 ?00:02:04 /usr/pgsql-9.3/bin/postgres The basic checks I did - Connectivity from other machines work (so server is accessible) No .pgpass fi

[GENERAL] Possible multiprocess lock/unlock-loop problem in Postgresql 9.2

Hello all, I am running a Postgresql 9.2 system (IIRC v9.2.4; I am about to upgrade to 9.2.6) on a system with 32-cores, 256GB RAM, 64GB shared RAM for postgresql. The applications I am running are written using Django (currently v1.5) For a while I have been observing what may be special