On Wed, Apr 18, 2012 at 6:51 PM, hubert depesz lubaczewski <
dep...@depesz.com> wrote:
> On Wed, Apr 18, 2012 at 01:25:14PM +0900, Michael Paquier wrote:
> > Hi all,
> >
> > Under Arch, I am not able to compile Postgres docs.
> >
> > By having a look at config.log, it cannot find the docbook folde
I have same problem too.
Tuan Hoang Anh
On Thu, Apr 19, 2012 at 10:43 PM, Efraín Déctor
wrote:
> Any help will be appreciated.
>
> Thanks.
>
> *From:* Efraín Déctor
> *Sent:* Wednesday, April 18, 2012 1:32 PM
> *To:* pgsql-general@postgresql.org
> *Subject:* pgstat wait timeout
>
> Hello l
On 04/17/12 7:10 AM, Videanu Adrian wrote:
i try to build a postgresql cluster using postgresql 9.1.3 and pgpool2 3.1.2.
I want to setup this cluster as a master/slave with streaming copy. Everything
is ok execept the case when the masters fails, and i try to recover it, because
the old master
> Hi all,
> i try to build a postgresql cluster using postgresql 9.1.3 and pgpool2 3.1.2.
> I want to setup this cluster as a master/slave with streaming copy.
> Everything is ok execept the case when the masters fails, and i try to
> recover it, because the old master recovers as master instead
On Fri, Apr 20, 2012 at 5:33 AM, Raymond O'Donnell wrote:
> Yep - no need to worry about quoting if you use parameters - it's all
> done for you. It's also MUCH safer, as it makes SQL injection attacks
> much harder (if not impossible).
And in some cases, it can even be more bandwidth-efficient.
2012/4/19 Raymond O'Donnell
>
>
> Yep - no need to worry about quoting if you use parameters - it's all
> done for you. It's also MUCH safer, as it makes SQL injection attacks
> much harder (if not impossible).
>
> Ray.
>
>
fine, thanks !
--
Yvon
On 19/04/2012 20:30, Yvon Thoraval wrote:
>
>
> 2012/4/19 Raymond O'Donnell mailto:r...@iol.ie>>
>
> Or better still - and easier - use parametrised queries.
>
>
>
> Right it is easier something like :
> $sql = "categories (idx, ctime, mtime, name) VALUES ( :idx, :ctime,
> :mtime, :name);
2012/4/19 Raymond O'Donnell
> Or better still - and easier - use parametrised queries.
>
Right it is easier something like :
$sql = "categories (idx, ctime, mtime, name) VALUES ( :idx, :ctime, :mtime,
:name);";
$prep = $db->prepare($sql);
$prep->execute( array(':idx' => $_GET['idx'], ':ctime' =
On 19/04/2012 17:12, Chris Angelico wrote:
> On Fri, Apr 20, 2012 at 2:03 AM, Yvon Thoraval
> wrote:
>> function quoteAsAre($string){
>> return preg_replace('/\\\"/', '"', preg_replace("/\\\'/", "'",
>> $string));
>> }
>> function sql2str($string){
>> return preg_replace('/\'\'/', "
2012/4/19 Chris Angelico
>
> No; ditch them. I mean no offense to you personally, but these
> functions are not worth keeping. Every SQL API includes a function for
> quoting something as a literal string. With PDO, it's this one:
>
> http://www.php.net/manual/en/pdo.quote.php
>
> I don't know wh
On ons, 2012-04-18 at 10:08 -0400, Tom Lane wrote:
> Now having said that, you could certainly try adjusting the
> DOCTYPE declaration in the docs and seeing if they'd build with 4.5.
It should work.
The problem, as I recall it, with DocBook 4.5 was that the are some
problems in the source packag
On Thu, Apr 19, 2012 at 1:07 PM, Michael Nolan wrote:
>
>
> On Thu, Apr 19, 2012 at 12:46 PM, Jen wrote:
>
>> I have been working on a hot backup for Postgres 9.1 for awhile and have
>> run
>> into a consistent issue.
>>
>
> The instructions in the Binary Replication Tutorial work well for me, I
On Thu, Apr 19, 2012 at 12:46 PM, Jen wrote:
> I have been working on a hot backup for Postgres 9.1 for awhile and have
> run
> into a consistent issue.
>
The instructions in the Binary Replication Tutorial work well for me, I
suggest you read through the '10 minute' version.
Specifically, look
That's a great idea Alban. I think that between your suggestion and
looking into memory & swap, we may be on to something. I'll post back with
more details (per the wiki suggestions) if I'm not able to get this
resolved.
Thanks!
On Thu, Apr 19, 2012 at 9:40 AM, Alban Hertroys wrote:
> On 19 Apr
Hi Andy,
Thanks for your reply. I don't know the answers to your questions off the
top of my head, so you have given me some things to look into (open
transactions, memory swap, etc).
Now I am suspecting that memory is a partial culprit as I just discovered
that rebooting (hadn't had the opportunit
I have been working on a hot backup for Postgres 9.1 for awhile and have run
into a consistent issue. After restarting Postgres on the slave server the
pgstartup log file and the daily log file under the pg_log directory reads
with no errors. However, when I try to enter into the database using the
On Fri, Apr 20, 2012 at 2:03 AM, Yvon Thoraval wrote:
> function quoteAsAre($string){
> return preg_replace('/\\\"/', '"', preg_replace("/\\\'/", "'",
> $string));
> }
> function sql2str($string){
> return preg_replace('/\'\'/', "'", $string);
> }
> function str2sql($string){
>
2012/4/19 Chris Angelico
> On Fri, Apr 20, 2012 at 1:20 AM, Adrian Klaver
> wrote:
> > Am CCing list so more eyes can see this and because I don't use PHP.
> >
> > On 04/19/2012 07:59 AM, Yvon Thoraval wrote:
> >> Fatal error: Call to a member function fetch() on a non-object in
> >> /home/yt/Si
Any help will be appreciated.
Thanks.
From: Efraín Déctor
Sent: Wednesday, April 18, 2012 1:32 PM
To: pgsql-general@postgresql.org
Subject: pgstat wait timeout
Hello list:
Today I started to see this messages on the PostgreSQL log:
2012-04-18 00:01:05 UTC : @ :WARNING: 01000: pgstat wait t
Read these two wiki pages and then include more info.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
http://wiki.postgresql.org/wiki/SlowQueryQuestions
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
I have a question involving money data stored in a numeric(9,2) field,
and posible errors with there manipulation.
in short, the table has these columns:
store: int
amount: int2
cost: numeric(9,2)
What I need to find is the total amount of money spent in a particular
store, so I do something lik
On 19 April 2012 16:09, Chris wrote:
> Hi Chris,
> It is postgres 9.1, with default settings. The autovacuum settings are all
> commented out, I have not change dthem. My understanding is that analyze is
> also run automatically by default.
>
> So, I believe the answer to both questions is 'Yes'.
On Fri, Apr 20, 2012 at 1:20 AM, Adrian Klaver wrote:
> Am CCing list so more eyes can see this and because I don't use PHP.
>
> On 04/19/2012 07:59 AM, Yvon Thoraval wrote:
>> Fatal error: Call to a member function fetch() on a non-object in
>> /home/yt/Sites/landp_public/landp.php on line 500
>>
On 4/19/2012 1:35 AM, Chris wrote:
Hello,
I'm using PG 9.1. Data is streaming into one particularly large table
(at 11 million rows currently) on a constant basis. It is pretty much
all inserts, very little updates or deletes (if any).
After a week or so, query performance on this table turns a
2012/4/19 Chris Angelico
>
> If all your inserts make use of the sequence, and you never alter the
> sequence, then this should never happen (unless, that is, 34 other
> inserts happened between when you inserted and when you checked the
> max). Be extremely careful of selecting max(rowid) when y
Am CCing list so more eyes can see this and because I don't use PHP.
On 04/19/2012 07:59 AM, Yvon Thoraval wrote:
What does the error say?
Fatal error: Call to a member function fetch() on a non-object in
/home/yt/Sites/landp_public/landp.php on line 500
This is PHP/PDO error message
On Fri, Apr 20, 2012 at 1:05 AM, Yvon Thoraval wrote:
> 2012/4/19 Chris Angelico
>> As a side point, I would recommend against doing this. Once you've
>> "used" a rowid, it's not worth reusing it. You'll save yourself some
>> headaches down the track if you simply ignore those odd gaps (ditto
>>
2012/4/19 Chris Angelico
>
> As a side point, I would recommend against doing this. Once you've
> "used" a rowid, it's not worth reusing it. You'll save yourself some
> headaches down the track if you simply ignore those odd gaps (ditto
> the gaps that result from rolled-back transactions) and ju
On Fri, Apr 20, 2012 at 12:19 AM, Yvon Thoraval wrote:
> even if i rearrange de sequence by :
>
> "SELECT MAX(rowid) FROM items;";
> "SELECT last_value FROM items_rowid_seq;";
> then if last_value is lower than MAX(rowid) i set it to MAX(rowid) :
> "SELECT setval('items_rowid_seq', max(rowid)) FRO
Laurenz, thank you so much for your help. I had a hard time getting the
es_MX locale installed on my freebsd system, but once I did it worked
perfectly. Thanks for your help again.
- Jose
On Thu, Apr 19, 2012 at 2:30 AM, Albe Laurenz wrote:
> jbiskofski wrote:
> > I have a lc_collate problem. Im
On 19 April 2012 16:19, Yvon Thoraval wrote:
> why ?
Because you're doing it wrong, apparently. However, since you left out
all the relevant information that could have helped determining what
you're doing and what errors you got, we can't help you.
Please provide the entire insert statement and
On 04/19/2012 07:19 AM, Yvon Thoraval wrote:
i do have a serial named 'rowid' it is of "SERIAL PRIMARY KEY" in a
table 'items'.
if i delete some of the rows i can't anymore insert afterwards.
even if i rearrange de sequence by :
"SELECT MAX(rowid) FROM items;";
"SELECT last_value FROM items_ro
i do have a serial named 'rowid' it is of "SERIAL PRIMARY KEY" in a table
'items'.
if i delete some of the rows i can't anymore insert afterwards.
even if i rearrange de sequence by :
"SELECT MAX(rowid) FROM items;";
"SELECT last_value FROM items_rowid_seq;";
then if last_value is lower than MAX
Hi Chris,
It is postgres 9.1, with default settings. The autovacuum settings are all
commented out, I have not change dthem. My understanding is that analyze is
also run automatically by default.
So, I believe the answer to both questions is 'Yes'.
On Thu, Apr 19, 2012 at 12:47 AM, Chris Traver
Hi all,
I have a program which replaces (DROP + CREATE) some frequently-used table.
Sometimes, just after the table is replaced, I get "ERROR: could not
open relation with OID xyz" from concurrent clients accessing the
table.
One could say this behaviour breaks transaction isolation... Does it?
you might want to log any errors resulting from pg_dump and then grep
through them to verify. or you could record the exit status ( $? ) for each
pg_dump command.
I was also thinking about how to check if something malformed your data on
disk. I could think of some ways to do that, but it doesn't
jbiskofski wrote:
> I have a lc_collate problem. Im in Mexico and I need the following three
> lastnames to be sorted this
> way :
>
> álvarez ( accent on first a )
> chavez
> cota
>
> Using the default locale on my mac ( en_US ) I end up with :
>
> chavez
> cota
> álvarez
>
> So I switched to
On 19 Apr 2012, at 6:26, Ondrej Ivanič wrote:
> I have query which does everything but I have mixed feelings about it:
> select
>b1.org_id, b1.contract_name, coalesce(b2.count, b1.count) as count
> from (select * from billing where org_specific_rule = false) as b1
> left join billing b2 on
>
should work. you could move b1 out of the sub query and add a normal where
clause to make the syntax nicer. Might also matter for the query plan.
other than that i don't see any bumps. It's good that you placed
"b2.org_specific_rule = true" in the join clause so that the left join
works properly.
w
39 matches
Mail list logo
