Re: [ADMIN] What does a .1 suffix on a PG data file signify?

2012-05-16 Thread k...@rice.edu
On Wed, May 16, 2012 at 02:52:44PM -0400, David Schnur wrote: > I'm investigating a 'could not stat file' error that points to a file > "base/16384/52212305.1". All the data files I've ever seen have names that > are whole numbers; I've never seen a decimal suffix. It occurs to me that > perhaps

[ADMIN] What does a .1 suffix on a PG data file signify?

2012-05-16 Thread David Schnur
I'm investigating a 'could not stat file' error that points to a file "base/16384/52212305.1". All the data files I've ever seen have names that are whole numbers; I've never seen a decimal suffix. It occurs to me that perhaps this is some kind of temp-file, or a system for avoiding duplicate fil

Re: [ADMIN] dangling connections

2012-05-16 Thread Daryl Stultz
> > > On Tue, May 15, 2012 at 3:31 AM, Sergey Konoplev wrote: > >> >> select client_addr, client_port from pg_stat_activity; >> >> after shutting down the Tomcat and find out what holds the >> on >> the >> >> [user@ ~]$ sudo netstat -pnao | grep >> >> The second column from the right will be the