[GENERAL] Postgres service (Windows) running as "local system"

Hi Postgres on windows - Is it ok to activate Postgres service, while logged on as "local system" Thanks, Yuval Yuval Sofer BMC Software CTM&D Business Unit DBA Team 972-52-4286-282 yuval_so...@bmc.com

Re: [GENERAL] avoiding file system caching of a table

On Mon, Feb 17, 2014 at 2:33 PM, Gabriel Sánchez Martínez < gabrielesanc...@gmail.com> wrote: > Is there a way of asking PostgreSQL to read the files of a table directly > off the disk, asking the OS not to use the file cache? I am running > PostgreSQL 9.1 on Ubuntu Server 64-bit. The server in

Re: [GENERAL] avoiding file system caching of a table

On 02/17/2014 08:45 PM, Jeff Janes wrote: On Mon, Feb 17, 2014 at 5:09 PM, "Gabriel E. Sánchez Martínez" mailto:gabrielesanc...@gmail.com>> wrote: On 02/16/2014 10:33 PM, Gabriel Sánchez Martínez wrote: Is there a way of asking PostgreSQL to read the files of a table dire

Re: [GENERAL] avoiding file system caching of a table

Jeff Janes writes: > If you told postgresql to tell the kernel not to cache the data it reads, > how would this help? I seem to recall also that O_DIRECT disables optimizations we definitely want, like read-ahead. So it could come out a loser independently of any what's-in-cache concerns.

Re: [GENERAL] Deleted files still open long after droping a database

Kevin Grittner writes: > Perhaps we should arrange for a DROP DATABASE command to somehow > signal all backends to close files from that backend? See commit ff3f9c8de, which was back-patched into 9.1.x as of 9.1.7. Unfortunately, the complainant is running 9.1.2. regards

Re: [GENERAL] avoiding file system caching of a table

On Mon, Feb 17, 2014 at 5:09 PM, "Gabriel E. Sánchez Martínez" < gabrielesanc...@gmail.com> wrote: > > On 02/16/2014 10:33 PM, Gabriel Sánchez Martínez wrote: > >> Is there a way of asking PostgreSQL to read the files of a table directly >> off the disk, asking the OS not to use the file cache? I

Re: [GENERAL] Deleted files still open long after droping a database

Vincent de Phily wrote: > I have droped a database a few hours ago to reclaim some badly-needed space, > but that disk space has not been freed yet. Investigating further, there are > lots of deleted but open files that seem to correspond to the droped db, all > open by some postgres process. > >

Re: [GENERAL] avoiding file system caching of a table

On 02/16/2014 10:33 PM, Gabriel Sánchez Martínez wrote: Is there a way of asking PostgreSQL to read the files of a table directly off the disk, asking the OS not to use the file cache? I am running PostgreSQL 9.1 on Ubuntu Server 64-bit. The server in question has the maximum amount of RAM i

Re: [GENERAL] File system level backup of shut down standby does not work?

On Mon, Feb 17, 2014 at 7:02 PM, Jürgen Fuchsberger < juergen.fuchsber...@uni-graz.at> wrote: > Hi all, > > I have a master-slave configuration running the master with WAL > archiving enabled and the slave in recovery mode reading back the WAL > files from the master ("Log-shipping standby" as des

[GENERAL] Re: [ADMIN] could not create lock file postmaster.pid: No such file or directory, but file does exist

You don't give a lot of information, but try "sudo rm postmaster.pid" or "sudo -u postgres rm postmaster.pid" if you are sure that postgres is not running. Cheers, Cliff On Tue, Feb 18, 2014 at 12:07 AM, Rob Goethals / SNP wrote: > Hi, > > > > This is my first post to this list, so I hope I am

[GENERAL] Database compare tools

Hello all, I was wondering if anyone of you know any database compare tools. I've been using PgComparer, and it has been working great until we upgraded Postgres from 9.0 to 9.3, and PgComparer stops to work. Any help is appreciated. Thanks! -Laurent

Re: [GENERAL] CREATE EXTENSION does not seem to work in 9.2

Hi, On Wed, 2014-01-22 at 11:07 -0800, Susan Cassidy wrote: > It wasn't installed in the yum package that we used to install > postgres 9.2. This has nothing to do with the RPMs -- PL/pgSQL is installed by defaults since 9.0. As Adrian wrote, you will need to omit the file path there (still, yo

Re: [GENERAL] Will modifications to unlogged tables also be flused to disk?

On Sat, Feb 15, 2014 at 3:03 AM, Clemens Eisserer wrote: > Hi, > > I would like to use postgresql's unlogged tables on an embedded system > to avoid frequent writes to flash memory. > While documentation clearly states that unlogged tables don't have to > go through the WAL, That's not really tr

Re: [GENERAL] Deleted files still open long after droping a database

Vincent de Phily writes: > I have droped a database a few hours ago to reclaim some badly-needed space, > but that disk space has not been freed yet. Investigating further, there are > lots of deleted but open files that seem to correspond to the droped db, all > open by some postgres process.

Re: [GENERAL] Deleted files still open long after droping a database

On Monday 17 February 2014 18:46:49 Vincent de Phily wrote: > Hi List, > > I have droped a database a few hours ago to reclaim some badly-needed space, > but that disk space has not been freed yet. Investigating further, there > are lots of deleted but open files that seem to correspond to the dro

[GENERAL] Deleted files still open long after droping a database

Hi List, I have droped a database a few hours ago to reclaim some badly-needed space, but that disk space has not been freed yet. Investigating further, there are lots of deleted but open files that seem to correspond to the droped db, all open by some postgres process. A lot of process were d

[GENERAL] How do I track down a possible locking problem?

I have a production system using Postgresql 9.1.2. The system basically receives messages, puts them in a queue, and then several parallel modules, each in its own thread, read from that queue, and perform two inserts, then release the message to the next queue for non-database-related processi

Re: [GENERAL] Database connection Pooling using JNDI

Hi Sumit, I think you need to refer to the documentation for the JDBC driver and not the actual PostgresSQL database server documentation. See here: http://jdbc.postgresql.org/documentation/92/jndi.html#ds-jndi Hope this helps. Andrew On 17/02/14 09:27, Sumit Sureka wrote: Hi, I am planni

[GENERAL] Re: could not create lock file postmaster.pid: No such file or directory, but file does exist

OK, it is clear to me that I didn't make the best choices setting up this database. :( I am happy I found this list because I am learning a lot in a very short period of time. :) Thank you all for your tips and comments. I will definitely move the database to a Linux-system and set fsync to on.

Re: [GENERAL] Toast and slice of toast

Thanks everybody ! Cheers, Rémi-C 2014-02-17 10:37 GMT+01:00 Andres Freund : > On 2014-02-17 14:16:33 +1100, Haribabu Kommi wrote: > > On Sun, Feb 16, 2014 at 9:38 PM, Rémi Cura wrote: > > > > > Hey Dear List, > > > could somebody point me to some ressources about getting only parts of > > >

[GENERAL] Re: could not create lock file postmaster.pid: No such file or directory, but file does exist

Rob Goethals wrote: > OK, clear. I hereby send this reply also to the list. Cool. >> Interesting. >> How did you get PostgreSQL into this state? Did you set fsync=off or >> similar? >> Which storage did you put pg_xlog on? > 2014-02-15 00:49:04 CET LOG: WAL writer process (PID 1127) was term

[GENERAL] Database connection Pooling using JNDI

Hi, I am planning to create my Application to use the database connection via connection pool which i registered to the JNDI service. I found one link that speaks about it: http://www.postgresql.org/docs/7.4/static/jdbc-datasource.html But the classes mentioned in the above link is not available

Re: [GENERAL] Re: could not create lock file postmaster.pid: No such file or directory, but file does exist

Rob Goethals / SNP writes: > When it is trying to startup again this is the logfile output: > ... > 2014-02-15 00:50:05 CET PANIC: could not create file > "pg_xlog/xlogtemp.5390": Input/output error The above PANIC is the reason for the abort that happens immediately thereafter. On local stor

Re: [GENERAL] Re: could not create lock file postmaster.pid: No such file or directory, but file does exist

On 17 February 2014 14:42, Rob Goethals / SNP wrote: > 2014-02-15 00:49:04 CET LOG: WAL writer process (PID 1127) was terminated > by signal 6: Aborted Signal 6 is usually caused by hardware issues. Then again, you also say: >I mounted a directory on a NTFS network-disk (because of the avail

[GENERAL] Re: could not create lock file postmaster.pid: No such file or directory, but file does exist

> -Oorspronkelijk bericht- > Van: Albe Laurenz [mailto:laurenz.a...@wien.gv.at] > Verzonden: maandag 17 februari 2014 14:22 > Aan: Rob Goethals > Onderwerp: RE: could not create lock file postmaster.pid: No such file or > directory, but file does exist > > Dear Rob, > > you should send

[GENERAL] File system level backup of shut down standby does not work?

Hi all, I have a master-slave configuration running the master with WAL archiving enabled and the slave in recovery mode reading back the WAL files from the master ("Log-shipping standby" as described in http://www.postgresql.org/docs/9.1/static/warm-standby.html) I take frequent backups of the s

[GENERAL] Re: could not create lock file postmaster.pid: No such file or directory, but file does exist

Rob Goethals wrote: > This is my first post to this list, so I hope I am posting it to the correct > lists. But I am really > stuck and getting pretty desperate at the moment. You should not post to more than one list. > This weekend my database crashed while importing some Openstreetmapdata and

[GENERAL] could not create lock file postmaster.pid: No such file or directory, but file does exist

Hi, This is my first post to this list, so I hope I am posting it to the correct lists. But I am really stuck and getting pretty desperate at the moment. This weekend my database crashed while importing some Openstreetmapdata and I can't get it back to work again. It happened before and normally

Re: [GENERAL] Toast and slice of toast

On 2014-02-17 14:16:33 +1100, Haribabu Kommi wrote: > On Sun, Feb 16, 2014 at 9:38 PM, Rémi Cura wrote: > > > Hey Dear List, > > could somebody point me to some ressources about getting only parts of > > toasted data? > > > > I have a very big custom type and I would like to take blocks of it (li

Re: [GENERAL] excute function before DROP EXTENSION

Hi Beena, How about using *TWO* extension? 1. ext_install 2. ext_uninstall Let me explain, 1. ext_uninstall will contain two command, A] SQL calling to cleanup function B] DROP EXTENSION ext_install 2. ext_install will have DROP EXTENSION IF EXISTS ext_install (cycle of install/uninstall)

[GENERAL] Re: Is PostgreSQL 9.3 using indexes for pipelined top-N window function queries?

Behrang Saeedzadeh, 15.02.2014 02:35: > Hi, > > I just stumbled upon this article from 2012 [1], according to which > (emphasis mine): > > Window functions offer yet another way to implement pagination in > SQL. This is a flexible, and above all, standards-compliant method. > However, only SQL Se