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 Server
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
On 2014-02-17 14:16:33 +1100, Haribabu Kommi wrote:
On Sun, Feb 16, 2014 at 9:38 PM, Rémi Cura remi.c...@gmail.com 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
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
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 I
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
-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 your
On 17 February 2014 14:42, Rob Goethals / SNP rob.goeth...@snp.nl 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
Rob Goethals / SNP rob.goeth...@snp.nl 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.
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
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 terminated
Thanks everybody !
Cheers,
Rémi-C
2014-02-17 10:37 GMT+01:00 Andres Freund and...@2ndquadrant.com:
On 2014-02-17 14:16:33 +1100, Haribabu Kommi wrote:
On Sun, Feb 16, 2014 at 9:38 PM, Rémi Cura remi.c...@gmail.com wrote:
Hey Dear List,
could somebody point me to some ressources
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
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
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
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
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 droped
Vincent de Phily vincent.deph...@mobile-devices.fr 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
On Sat, Feb 15, 2014 at 3:03 AM, Clemens Eisserer linuxhi...@gmail.comwrote:
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,
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, you
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
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 rob.goeth...@snp.nlwrote:
Hi,
This is my first post to this list, so
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 described
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
Vincent de Phily vincent.deph...@mobile-devices.fr 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
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 am
Kevin Grittner kgri...@ymail.com 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.
Jeff Janes jeff.ja...@gmail.com 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
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
gabrielesanc...@gmail.com 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
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
Hi
Postgres on windows - Is it ok to activate Postgres service, while logged on as
local system
Thanks,
Yuval
Yuval Sofer
BMC Software
CTMD Business Unit
DBA Team
972-52-4286-282
yuval_so...@bmc.commailto:yuval_so...@bmc.com
31 matches
Mail list logo