What I want is something similar to this:
CREATE OR REPLACE FUNCTION f( /* "some args..." */)
RETURNS SETOF RECORD AS
$BODY$
DECLARE
...
BEGIN
DROP TABLE IF EXISTS tbl_temp;
CREATE TEMPORARY TABLE tbl_temp(
-- "based on args..."
);
WHILE
INSERT INTO tbl_temp VALUES (/*"some values"*/
What I want is something similar to this:
CREATE OR REPLACE FUNCTION f( /* "some args..." */)
RETURNS text AS
$BODY$
DECLARE
...
BEGIN
DROP TABLE IF EXISTS tbl_temp;
CREATE TEMPORARY TABLE tbl_temp(
-- "based on args..."
);
WHILE
INSERT INTO tbl_temp VALUES (/*"some values"*/);
END
ner and is
equivalent to SELECT * FROM f(). For example, EXECUTE FUNCTION
function_name()...
So... is there a grain of truth in all this?
Regards,
Davor
"Davor J." wrote in message
news:hl11bd$2fs...@news.hub.org...
> What I want is something similar to this:
>
>
Thank you for the link Andreas. It was helpfull, but still not quite what I
need.
Regards,
Davor
""A. Kretschmer"" wrote in message
news:20100212114635.gb25...@a-kretschmer.de...
> In response to Davor J. :
>> What I want is something similar to this:
>>
By default, there is some barely visible dotted rectangle around the
QItemSelectionModel::currentIndex (). Has anyone suggestions how to change
this efficiently. (i.e. I think adjusting the model data with setData() and
Qt::FontRole or Qt::BackgroundRole or something similar isn't the right way
I need to make certain views from the database visible online (on our
webpage) and I wonder if there is any reasonably quick solution for this
that works with Postgres?
At best, a query should be specified and the user should be able to select
the layout on certain columns (like stepped, or out
Thank you all for the nice suggestions!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I just wonder whether the two are equivalent from user perspective: As far
as I see, you can always rewrite a multi-command rule as a conditional rule
and vice versa. Further more, Postgres seems to execute all the conditional
rules, just as if it would execute all the commands in the one uncond
I've just had the common problem with not finding the readline library
while compiling/linking 8.4.4 on a new linux (Debian 5 - lenny). Nothing
seemed to work: --with-libraries=/lib and pointing CFLAGs there all
failed to find readline. The installed packages though said that it was
present.
Thanks for the pointer to the correct packages. I didn't realise that
the dev versions had the generic libs but, yes, you do need them for the
headers anyway.
Apologies for wasting time.
J
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
g monstrous and too user oriented (the machine is a small server,
mostly used headless).
J
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have the same table as yours with potential to grow over 50 billion of
records once operational. But our hardware is currently very limited (8GB
RAM).
I concur with Tom Lane about the fact that partial indexes aren't really an
option, but what about partitioning?
I read from the Postgres doc
r Filesystem?
http://en.wikipedia.org/wiki/Clustered_file_system
NFS is nice for sharing files between multiple systems, but most server
products specifically mention it is not compatible with file sharing protocols
like NFS/CIFS/
--
J. Roeleveld
--
Sent via pgsql-general mailing list (pgsql-general@
On Friday 25 June 2010 02:23:17 Iwao Shikase wrote:
> Hi Roeleveld-san,
>
> Thank you for your advice. But My purpose is to test PostgreSQL
> which data cluster is in NFS server.
> As your says, Cluster Filesystem is one of answer of sharing files.
> But my company still want to use NFS server. S
Several times I wanted to "extend" some of the postgres objects, like roles
or functions. For example, sometimes you want to add extra attributes to
roles, which are application dependent. Or sometimes you want to store
functions and reference them in your custom tables, without losing
referent
I couldn't find it on the net. I also coudn't find any reference to it in
the psql source?
Anyone any suggestions?
Regards,
Davor
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n system tables is allowed in
MySQL.
So, all this just leaves me wondering why this is not possible in Postgres.
Regards,
Davor
"Craig Ringer" wrote in message
news:4c313581.2060...@postnewspapers.com.au...
> On 04/07/10 21:43, Davor J. wrote:
>
>
>> PS using
Great option!
Thanks Andreas
""A. Kretschmer"" wrote in message
news:20100706093242.gd13...@a-kretschmer.de...
> In response to Davor J. :
>> I couldn't find it on the net. I also coudn't find any reference to it in
>> the psql source?
>>
"Craig Ringer" wrote in message
news:4c33dc32.7080...@postnewspapers.com.au...
> On 06/07/10 17:47, Davor J. wrote:
>> Thanks Craig.
>>
>> I still find it a bit awkward that we have to use "priv check function"-s
>> because we can't define tr
It seems no secret that a child table will not fire a trigger defined on
it's parent table. Various posts comment on this. But nowhere could I find a
reason for this.
Now, I just wonder whether the people who request this are wrong in their
assumption that a trigger should fire on the child tab
""Karsten Hilbert"" wrote in message
news:20100719182027.123...@gmx.net...
>> On Thu, Jul 15, 2010 at 4:05 AM, Davor J. wrote:
>> > It seems no secret that a child table will not fire a trigger defined
>> > on
>> > it's parent table. Va
"Craig Ringer" wrote in message
news:4c3ed37c.1070...@postnewspapers.com.au...
> My understanding is that it's mostly an implementation limitation. In
> other words, rather than any fundamental reason why it should not be
> done, the issue is that nobody has gone and implemented it, tested it,
>
"Karsten Hilbert" wrote in message
news:20100728182051.gj2...@hermes.hilbert.loc...
> On Tue, Jul 27, 2010 at 10:33:19AM +0200, Davor J. wrote:
>
>> Well... I found it out the hard way :). There are some extra caveats I
>> have
>> come along. There is the
"Data Growth Pty Ltd" wrote in message
news:aanlktimzaio+7mtur=sx0jcqwu7uk+_xznudl4qrm...@mail.gmail.com...
I have a table of around 200 million rows, occupying around 50G of disk. It
is slow to write, so I would like to partition it better.
Have you actually tested this? Why do you expect a
Suppose you have a table CREATE TABLE tbl_formulas (formula_id integer,
formula text)
The formula field can be any postgres-supported mathematical operation which
references some input data with $1 like "sin($1) + cos($1)" and returns one
numeric value. Such formulas should be used in the SELEC
On Sunday 12 September 2010 00:43:19 Bruce Momjian wrote:
> Gabe Nell wrote:
> > > That section has been removed from the current 9.0 docs because we are
> > > unsure it works.
> >
> > Hmm. So the only way to make a consistent backup from a standby server
> > is to shut down the standby first? Or
On Sunday 12 September 2010 13:32:00 Martijn van Oosterhout wrote:
> On Sun, Sep 12, 2010 at 12:18:10PM +0200, J. Roeleveld wrote:
> > How can you ensure the snapshot is in a consistent state if the server is
> > running?
> >
> > If a snapshot is taken between 2 upda
Zope. http://www.zope.org
Been using PostgreSQL behind Zope for a couple of sites for over 8
months now and it has been a pleasure.
Cheers,
J
At 9:15 PM -0400 9/25/2000, Michelle Murrain wrote:
>Hi folks,
>
>I thought (now that I've solved my DBD::Pg problem) that I'd ask
Hello
It is probably something quite silly but I have installed all the binaries
from the RH6.2 installation disk and browsed through the manual. These
are:
postgresql-6.5.3-6.i386.rpmpostgresql-python-6.5.3-6.i386.rpm
postgresql-devel-6.5.3-6.i386.rpm postgresql-server-6.5.3-6.i386.rp
Hi
As a newbie to SQL and databases, someone has asked me what is a "pivotal
system". Since in my experience most concepts are common across a number
of disciplines, just the vocabulary changes, can anyone (i) point me in
the right direction and (ii) can Postgres be set up to implement such a
sy
Hi,
I'm building a site based on linux/apache/PHP/Postgresql.
(redhat7,apache 1.3/PHP4.04/Postgres 7.1)
I have the following SQL on a PHP page that processes a rather complex
search form.
SELECT talent.*,models.* FROM talent join models on
(models.usrindx=talent.indx) where validated=1 AND ( (a
Hi,
I have found what appears to be a bug in PostgreSQL, or is this a feature?
I don't think it's a feature, because the postgreSQL documentation state it
should work.
When creating delete-rules for views, i have found that only the first
expression is being executed, when
using multiple express
Hi,
I keep running into problems with:
ERROR: DefineQueryRewrite: rule plan string too big.
Does anyone have any insights into this? And how to fix this?
Hoping for help,
Joost Roeleveld
ps. I am willing to post _all_ Create-queries I use if anyone thinks he/she
can fix it in my case.
Hi,
I keep running into problems with:
ERROR: DefineQueryRewrite: rule plan string too big.
Does anyone have any insights into this? And how to fix this?
Hoping for help,
Joost Roeleveld
ps. I am willing to post _all_ Create-queries I use if anyone thinks he/she
can fix it in my case.
> Hi everyone,
>
> I've been using MS Sql Server for the last 4 years on NT and I am quite
> fed-up with it.
> So I am now seriously considering a move towards LINUX and I investigate
> the serious DB offering and PostgreSql Seems to come as a really strong
> candidate.
>
> however I have some que
Hi,
I was wondering if anyone knows what's being
executed first,
a Rule on a view, or a trigger set to 'before
' on a view?
Eg. what's executed first? The RULE, or the
TRIGGER?
Joost Roeleveld
ps. I hope I'm making
sense.
> What filesystem? I know (thank god) very little about Linux, but
> there have been comments here by some Linux folks (Thomas, wasn't it
> you?) that indicated that ext2fs sucks for this? Are you running with
> fsync() on or off?
What is the problem with ext2fs? Is it just performance? or is t
Hi,
I just found a reference to descriptions to functions/tables/...etc.
and am now wondering how to add them myself?
Joost Roeleveld
ps. as an example of what I'm referring to:
mydb=> \dd currval
description
--
sequence current value
(1 row)
mydb=> \dd mytable
Hi,
I just found a reference to descriptions to functions/tables/...etc.
and am now wondering how to add them myself?
Joost Roeleveld
ps. as an example of what I'm referring to:
mydb=> \dd currval
description
--
sequence current value
(1 row)
mydb=> \dd mytable
Hi,
I would like to know if, and how, I can find out who's logged into
the database at any given time.
And is it possible to maintain a connection-log of log-ins and log-outs?
with kind regards,
Joost Roeleveld
> Hello All,
>
> I have the following situation:
>
> CREATE TABLE "Contacts" (
> "Contact" Serial,
> "StuffTheir" Text,
> "TheDate" datetime DEFAULT TEXT 'now',
> "Subj" Text,
> "CustomerId" int4,
> "Agent" int4,
> "ActionType"
Hi,
I've been checking the archives and documentation for what the
system requirements are for a PostgreSQL database
It's to be used for a database with 8 users, and has MS-Access front-end
which causes app. 2 connections per user.
My idea was:
128Meg Ram
20 Gig HD
500 Mhz. Celeron
will
> Hello i start yesterday afternoon a COPY command into a table.
> the file is 15 Mb
> i've set triggers before and after insert on the table
> the before trigger just perform data check.
> the after trigger update a 10 000 rows linked table.
>
> the COPY command runs all the night ad has not yet
> I had a similar thing once, while compiling a program, it took the
computer
> 28 hours to complete. (on a P200)
>
> My best guess is is that it's still running, make a quick check that the
> main
> process is still running. The action you are doing requires not just alot
of
> CPU-power, but also
> Hello
>
> I like to create a user who can do the followings on a table: select,
> insert, update
> But he can't delete!
> I tried this: grant INSERT, SELECT, UPDATE on table_name to testuser;
> After this the test user can delete from the table_name table without any
> problems. The testuser is
on 6.5.3 and see if it still happens?
J
At 1:19 AM -0500 4/25/2000, Stephan Richter wrote:
>Hello everyone,
>
>This is a help message to every mailing list, I think this issue
>could be related to. We are in production and 5000 flyers (45000
>follow) were sent out and the si
I have been looking around for the RPM for 7.0 anyone have a quick link?
Thanks,
J
Yup.. I (original poster) am using 6.5.3 and should/would/will head to 7.0.2
(already on another site in production). Just waiting for the time/need.
Thanks to everyone for their help.
J
> From: "Ryan Williams" <[EMAIL PROTECTED]>
> Date: Thu, 24 Aug 2000 12:08:46 -0700
&
e_number). That way
two transactions won't be able to add a node with the same sequence
number under the same parent. You will have to handle duplicate key
errors, though.
hp
--
_ | Peter J. Holzer| we build much bigger, better disasters now
|_|_) || because we
recognized as a function. So apparently
columnname open-parenthesis tablename closed-parenthesis is a specific
syntactic construct, but I can't find it documented anywhere.
hp
--
_ | Peter J. Holzer| we build much bigger, better disasters now
|_|_) |
On 2017-08-18 15:57:39 -0500, Justin Pryzby wrote:
> On Fri, Aug 18, 2017 at 10:47:37PM +0200, Peter J. Holzer wrote:
> > On 2017-08-18 06:37:15 -0500, Justin Pryzby wrote:
> > > On Fri, Aug 18, 2017 at 01:01:45PM +0200, Rob Audenaerde wrote:
> > > > Can anyone
Service Postgresql_for_odoo not found and Server internal error while open
localhost:8069. If I uninstall postgresql, Error stopping and delete
postgresql_for_odoo. Thanks
On 2017-08-22 12:57:15 -0300, marcelo wrote:
> We'll replace those QNX machines with WIndows XP ones
The future is already here — it's just not very evenly distributed.
SCNR,
hp
--
_ | Peter J. Holzer| we build much bigger, better
y to recover from this situation without drastic
measures like nuking the whole database.
hp
--
_ | Peter J. Holzer| we build much bigger, better disasters now
|_|_) || because we have much more sophisticated
| | | h...@hjp.at | management t
On 2017-09-01 09:57:52 -0600, Rob Sargent wrote:
> On 09/01/2017 02:29 AM, Peter J. Holzer wrote:
> >TLDR: Don't.
> >
> >I'm currently conducting tests which should eventually lead to a 2 node
> >cluster with working bidirectional logical replication.
> >
On 2017-09-01 10:29:51 +0200, Peter J. Holzer wrote:
> pglogical supports replication of sequences, and although the way it
> does this suggests that it can't really work in both directions
> (actually I'm sceptical that it works reliably in one direction), of
> course I ha
software maintainability
POV I think a dictionary lookup in Perl is a lot nicer than 50 joins
(or 300 in your case).
hp
--
_ | Peter J. Holzer| we build much bigger, better disasters now
|_|_) || because we have much more sophisticated
| | | h...@hjp.at | m
ndom accesses, most of which are unneccessary.
The materialize returns 184791 rows. This one I understand: There are 6
non-null distinct values of arbeitsvolumen in facttable_kon_eh, and each
appears 36958 times. 36958 * 5 + 1 = 184791. So it stops once it reaches
the largest value. Although now
ps with timezones, which isn't the case
for PostgreSQL.)
hp
--
_ | Peter J. Holzer| we build much bigger, better disasters now
|_|_) || because we have much more sophisticated
| | | h...@hjp.at | management tools.
__/ | http://www.hjp.at/ | --
or What exactly it make the difference for
> client
> if i use md5/password in pg_hba.conf file in DB server?.
See
https://www.postgresql.org/docs/10/static/auth-methods.html#AUTH-PASSWORD
With method password, passwords are sent in plain text. With md5, an md5
hash of the password, th
QL
is really up and services which don't need PostgreSQL (e.g. SSH or X11
login or a web- or mail server) shouldn't depend on it.
One of the purported advantages of systemd over SystemV init is that it
starts up services in parallel, so a service which takes a long (or
infinite) time to st
Greetings,
I just got around to upgrading from 9.3-beta1 to 9.3-beta2, and was
surprised to see that the server was refusing to start. In the log,
I'm seeing:
2013-07-24 13:41:47 PDT [7083]: [1-1] db=,user= FATAL: database files
are incompatible with server
2013-07-24 13:41:47 PDT [7083]: [2-1] d
On Wed, Jul 24, 2013 at 2:05 PM, Tom Lane wrote:
> Alvaro Herrera writes:
>> Lonni J Friedman escribió:
>>> I'm using the RPMs from yum.postgresql.org on RHEL6. Is this
>>> expected, intentional behavior? Do I really need to dump & reload to
>>>
Greetings,
I have a postgresql-9.3-beta1 cluster setup (from the
yum.postgresql.org RPMs), where I'm experimenting with the postgres
FDW extension. The documentation (
http://www.postgresql.org/docs/9.3/static/postgres-fdw.html )
references three Cost Estimation Options which can be set for a
fore
On Fri, Jul 26, 2013 at 3:28 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> nightly=# ALTER SERVER cuda_db10 OPTIONS (SET use_remote_estimate 'true') ;
>> ERROR: option "use_remote_estimate" not found
>
>> Am I doing something wrong, or is this a
I've never seen this happen. Looks like you might be using 9.1? Are
you up to date on all the 9.1.x releases?
Do you have just 1 slave syncing from the master?
Which OS are you using?
Did you verify that there aren't any network problems between the
slave & master?
Or hardware problems (like the
syncs right
> back up and all if working again so if it is a network issue, the
> replication is just stopping after some hiccup instead of retrying and
> resuming when things are back up.
>
> Thanks!
>
>
>
> On Thu, Aug 15, 2013 at 11:32 AM, Lonni J Friedman
> wrote:
gt; #log_min_messages = warning
> #log_min_error_statement = error
> #log_min_duration_statement = -1
> #log_checkpoints = off
> #log_connections = off
> #log_disconnections = off
> #log_error_verbosity = default
>
> I'm going to have a look at the NICs to make s
The first thing to do is look at your server logs around the time when
it stopped working.
On Wed, Aug 21, 2013 at 7:08 AM, Joseph Marlin wrote:
> We're having an issue with our warm standby server. About 9:30 last night, it
> stopped applying changes it received in WAL files that are shipped ov
Greetings,
I'm running a PostgreSQL 9.3.0 cluster (1 master with two streaming
replication hot standby slaves) on RHEL6-x86_64. Yesterday I upgraded
from 9.2.4 to 9.3.0, and since the upgrade I'm seeing a significant
performance degradation. PostgreSQL simply feels slower. Nothing
other than the
On Tue, Sep 17, 2013 at 9:54 AM, Eduardo Morras wrote:
> On Tue, 17 Sep 2013 09:19:29 -0700
> Lonni J Friedman wrote:
>
>> Greetings,
>> I'm running a PostgreSQL 9.3.0 cluster (1 master with two streaming
>> replication hot standby slaves) on RHEL6-x86_64. Yeste
Thanks for your reply. Comments/answers inline below
On Tue, Sep 17, 2013 at 11:28 AM, Jeff Janes wrote:
> On Tue, Sep 17, 2013 at 11:22 AM, Lonni J Friedman
> wrote:
>>
>>
>> > c) What does logs say?
>>
>> The postgres server logs look perfectly no
On Tue, Sep 17, 2013 at 3:47 PM, Andres Freund wrote:
> Hi,
>
> On 2013-09-17 09:19:29 -0700, Lonni J Friedman wrote:
>> I'm running a PostgreSQL 9.3.0 cluster (1 master with two streaming
>> replication hot standby slaves) on RHEL6-x86_64. Yesterday I upgraded
>>
On Wed, Sep 18, 2013 at 2:02 AM, Kevin Grittner wrote:
> Lonni J Friedman wrote:
>
>> top shows over 90% of the load is in sys space. vmstat output
>> seems to suggest that its CPU bound (or bouncing back & forth):
>
> Can you run `perf top` during an episode and see
On Wed, Sep 18, 2013 at 2:02 AM, Kevin Grittner wrote:
> Lonni J Friedman wrote:
>
>> top shows over 90% of the load is in sys space. vmstat output
>> seems to suggest that its CPU bound (or bouncing back & forth):
>
> Can you run `perf top` during an episode and see
Greetings,
I've got two different 9.3 clusters setup, a & b (on Linux if that
matters). On cluster b, I have a table (nppsmoke) that is partitioned
by date (month), which uses a function which is called by a trigger to
manage INSERTS (exactly as documented in the official documentation
for partiti
I've got two 9.3 clusters, with a postgres foreign data wrapper (FDW)
setup to point from one cluster to the other. One of the (foreign)
tables associated with the foreign server has a bigint sequence for
its primary key, defined as:
id | bigint | not null default
On Wed, Sep 25, 2013 at 2:47 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> If I INSERT a new row into the local table (not the foreign table
>> version), without specifying the 'id' column explicitly, it
>> automatically is assigned the nextval in the seq
anada
wrote:
> Hi Lonni,
>
> 2013/9/25 Lonni J Friedman :
>> The problem that I'm experiencing is if I attempt to perform an INSERT
>> on the foreign nppsmoke table on cluster a, it fails claiming that the
>> table partition which should hold the data in the
On Thu, Sep 26, 2013 at 8:52 AM, Tom Lane wrote:
> Lonni J Friedman writes:
>> Thanks for your reply. This sounds like a relatively simple
>> workaround, so I'll give it a try. Is the search_path of the remote
>> session that postgres_fdw forces considered to b
Greetings,
I've recently pushed a new postgres-9.3 (Linux-x86_64/RHEL6) cluster
into production, with one master, and two hot standby streaming
replication slaves. Everything seems to be working ok, however
roughly half of my pg_basebackup attempts are failing at the very end
with the error:
pg_b
Hello,
I'm working on an upgrade to our database cluster, attempting to move from 8.4
to 9.2. I'm encountering the following error when I attempt the upgrade (in
pg_upgrade_restore.log):
CREATE FUNCTION "st_envelope_in"(cstring) RETURNS st_envelope
LANGUAGE "c" IMMUTABLE STRICT
AS 'st_g
The --link argument doesn't work, either:
bash-4.1$ export LD_LIBRARY_PATH=/usr/pgsql-9.2/lib
bash-4.1$ /usr/pgsql-9.2/bin/pg_upgrade --old-datadir=/var/lib/pgsql/data
--new-datadir=/var/lib/pgsql/9.2/data --old-bindir=/usr/bin
--new-bindir=/usr/pgsql-9.2/bin --check
Performing Consistency Check
Adrian,
On 1/1/14, 12:26 PM, "Adrian Klaver" wrote:
>On 01/01/2014 09:08 AM, Reiser, John J. wrote:
>> The --link argument doesn't work, either:
>>
>
>>
>> Consult the last few lines of "pg_upgrade_restore.log" for
>> the probable c
On 1/1/14, 12:38 PM, "Tom Lane" wrote:
>"Reiser, John J." writes:
>> I'm working on an upgrade to our database cluster, attempting to move
>>from 8.4 to 9.2. I'm encountering the following error when I attempt the
>>upgrade (in pg_upgrade
On 1/1/14, 3:37 PM, "Tom Lane" wrote:
>"Reiser, John J." writes:
>> On 1/1/14, 12:38 PM, "Tom Lane" wrote:
>>> What this smells like is a bug in the pg_dump --binary_upgrade logic
>>>that
>>> tries to preserve type OIDs from th
Hi,
I'm trying to update a record within a for loop and at the point of
updating I get the following syntax error:
ERROR: syntax error at or near "$1"
LINE 1: update $1 set wfstatus='failed'
^
QUERY: update $1 set wfstatus='failed'
CONTEXT: SQL statement in PL/PgSQL functi
, February 28, 2012 12:24 PM
To: Lummis, Patrick J
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Stored Procedure Record Updates using For Loops -
Postgres 8.1
Hi,
instead of
update workorderRecord set wfstatus='failed';
try:
workorderRecord.wfstatus := 'failed';
Indeed there is an id field. That's the ticket!
And thanks much.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Tuesday, February 28, 2012 12:48 PM
To: pgsql-general@postgresql.org
Cc: Lummis, Patrick J; Bartosz Dmytrak
Subject: Re: [GENERAL] S
I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
streaming replication. I'm in the planning stages of upgrading to
9.1.x, and am looking into the most efficient way to do the upgrade
with the goal of minimizing downtime & risk. After googling, the only
discussion that I've found o
After reading this interesting article on shared_buffers and wal_buffers:
http://rhaas.blogspot.com/2012/03/tuning-sharedbuffers-and-walbuffers.html
it got me wondering if my settings were ideal. Is there some way to
measure wal_buffer usage in real time, so that I could simply monitor
it for som
On Fri, Mar 16, 2012 at 2:45 AM, Albe Laurenz wrote:
> Lonni J Friedman wrote:
>> After reading this interesting article on shared_buffers and wal_buffers:
>> http://rhaas.blogspot.com/2012/03/tuning-sharedbuffers-and-walbuffers.html
>>
>> it got me wondering if my set
On Mon, Mar 19, 2012 at 12:30 PM, Bruce Momjian wrote:
> On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
>> I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
>> streaming replication. I'm in the planning stages of upgrading to
>>
On Tue, Mar 20, 2012 at 11:46 AM, Bruce Momjian wrote:
> On Mon, Mar 19, 2012 at 03:07:02PM -0700, Jeff Davis wrote:
>> On Mon, 2012-03-19 at 15:30 -0400, Bruce Momjian wrote:
>> > On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
>> > > I'
Greetings,
I'm running postgresql-9.1.3 on a Linux-x86_64 (Fedora16, if it
matters) system. I noticed the existence of pg_basebackup starting in
9.1, and figured I'd try it out and see if it would simplify our
backup & management processes. I setup a test system (same OS &
postgresql version as p
On Fri, Apr 20, 2012 at 12:31 PM, Magnus Hagander wrote:
> On Fri, Apr 20, 2012 at 19:51, Lonni J Friedman wrote:
>> Anyway, lesson learned, I need to either invoke pg_basebackup as the
>> same user that runs the database (or is specified with the -U
>> parameter ?)
I am currently backing up my postgres instances using ZFS snapshots instead
of the sanctioned pg_dump utility mainly because I am running on Solaris
and it offers a copy-on-write file system. Anecdotally this has been
working fine for me. Are there any issues I should be aware of since I'm
not usin
ich db, how many times, etc.
I've used pg_fouine for doing reporting on queries, but it doesn't
really deal with tracking user/db access.
Before I try to whip up something myself with perl or something, I
wanted to see if anyone's already done something similar.
thank
Greetings,
I'm running postgresql-9.1.3 on a Linux-x86_64 (Fedora16, if it
matters) system. I noticed the existence of pg_basebackup starting in
9.1, and figured I'd try it out and see if it would simplify our
backup & management processes.
$ pg_basebackup -P -v -D /tmp/backup -x -Ft -z -U postgr
because I could not restore missing pg_clog
files. What can I do?
Thanks in advance,
Chris
[1]: http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
--
Christian J. Dietrich
Institute for Internet Security - if(is)
Westfaelische Hochschule University of Applied Sciences
https://www.in
101 - 200 of 765 matches
Mail list logo