On 02/09/2011 07:52 AM, Vick Khera wrote:
On Tue, Feb 8, 2011 at 8:06 PM, u235sentinel <mailto:u235senti...@gmail.com>> wrote:
Is there a way we can validate a postgers backup? (short of
restoring it somewhere)
Define "validate" for your purpose. Once you do that,
Is there a way we can validate a postgers backup? (short of restoring it
somewhere)
Thanks!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm tracking a problem with our tables being bloated and was curious if
someone regularly kills autovacuum jobs, will autovacuum later reattempt
to vacuum the table it was killed under?
I've made autovacuum more aggressive and given more worker threads. Yet
for some reason we're not keeping u
We're backing up our database using pg_dump with compression. We're
selecting each database however when we tried running a pg_restore
everything cept for the roles were restored.
I'm digging through the pg_restore options, Is there an option I'm
forgetting to include?
Also we're restorin
On 06/07/2010 08:08 PM, Vick Khera wrote:
Our primary DB server is a Sun X4200 M2 with 20Gb RAM with a "Dual
LSILogic FC7X04X 4Gb/s FC PCI-Express Adapter" fibre channel card
plugged into it, directly connected to a SurfRAID Triton 16 array from
Partners Data Systems. The SurfRAID does the RAID
On 06/07/2010 08:01 PM, Scott Marlowe wrote:
Where I work we use these:
http://www.pc-pitstop.com/sata_enclosures/scsas16rm.asp
for when we need lots of throughput (file servers). They allow four
SAS connectors instead of the typical one or two.
and will be using these:
http://www.aberdeeni
On 06/07/2010 12:13 PM, Vick Khera wrote:
Ditto. Of late I'm buying HPs, but I haven't yet put one into
database service. Our DB servers are all currently Sun with fibre
channel cards to external RAID systems.
What kind of external RAID systems do you connect your Sun servers to?
I've
On 06/06/2010 02:04 AM, Greg Smith wrote:
u235sentinel wrote:
A Dell system running a PERC with battery-backed write controller will
be faster on database writes than your 4540. Those Sun boxes are
terrible at OLTP style workloads in particular, the types of writes
PostgreSQL does can'
On 06/05/2010 07:20 PM, John R Pierce wrote:
My manager and I are looking at replacing a Sun x4540 server with a
Dell server connected to a disk subsystem (or two). We're looking at
the R710 servers connected to an MD1220 I believe (I'd have to look
again at the quote).
why are you looki
I'm curious if anyone has had any experiences (good and bad) using
Postgres on Dell PowerEdge servers.
My manager and I are looking at replacing a Sun x4540 server with a Dell
server connected to a disk subsystem (or two). We're looking at the
R710 servers connected to an MD1220 I believe (I'
ROFL!!
That's funny... We're spam but he requested and validated the email
address to receive the list emails.
On 06/02/2010 03:37 PM, John R Pierce wrote:
hmmm. the listadmin may wanna poke this guy for using lame
whitelisting. sadly, the headers give no clue who the recipient was,
oth
On 06/02/2010 08:05 AM, Stephen Frost wrote:
* Joshua Tolley (eggyk...@gmail.com) wrote:
On Tue, Jun 01, 2010 at 11:56:19AM -0600, u235sentinel wrote:
I'm still trying to figure out why you wouldn't want to use GSSAPI..
It's a heck of alot better than using LD
Is there is a way to connect postgres to authenticate against a windows
domain without recompiling and using gssapi. Ldap perhaps?
Thanks!
Adrian Klaver wrote:
On Thursday 11 February 2010 1:57:39 am Albe Laurenz wrote:
u235sentinel wrote:
I have a strange problem we noticed the other day with
triggers. We're
running 8.3.3 on Solaris 10 (intel) and have a feed that comes in
regularly to populate a table we're
Adrian Klaver wrote:
Well that would depend on any number of factors. Without information
on how the feed is being done or more detailed logs it is hard to say
for sure. At a guess though, I would say it is because the 'feed' is
being done wrapped in a transaction and when the trigger errors
Trigger function for an insert/update trigger should return "NEW", not
NULL (OLD - for "on delete" trigger):
It's an AFTER TRIGGER, so the RETURN-Value ignored.
According the doc:
The return value of a BEFORE or AFTER statement-level trigger or an
AFTER row-level trigger is always
I have a strange problem we noticed the other day with triggers. We're
running 8.3.3 on Solaris 10 (intel) and have a feed that comes in
regularly to populate a table we're working on. The feed works just
fine inserting rows however the following trigger stops the feed until
we remove the tri
17 matches
Mail list logo
