I tried several times to visit the site recently but the domain always
can not be resolved. is there something wrong?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Jul 26, 2011 at 8:13 PM, Karl Nack wrote:
>> The current svn trunk (to be 1.3) does.
>
> So how far do you take this? I've been playing around with plpgsql a bit
> and am pretty encouraged by what I'm discovering; now I'm at a point
> where I'm thinking, "how far do/can I go with this?"
H
On 07/26/11 11:35 PM, Yan Chunlu wrote:
I tried several times to visit the site recently but the domain always
can not be resolved. is there something wrong?
per the guys on the IRC channel, there was a DNS server issue a little
while ago, hopefully its reserved, but if your server has cached
On 07/27/11 12:48 AM, John R Pierce wrote:
...hopefully its reserved...
errr. i meant to type RESOLVED. hah.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
thx a lot for your answer. i have already bought your book and have read most
of the chapters.
(in the near future i will study it more thoroughly)
i asked here for tips in case there was something i had missed and there was
a "magic" way to improve the perfomance even a little.
as far as the
Le mardi 26 juillet 2011 à 11:23 -0500, Merlin Moncure a écrit :
> I think I've been cursed due
> to have discovered the secret to fast, efficient programming while
> continually being constrained from developing that way. Then again,
> most programmers probably feel like that :-).
>
I think
Alternatively you can get the 'server' package from app store, it has
postgresql already in it :) (9.0)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> The current svn trunk (to be 1.3) does.
So how far do you take this? I've been playing around with plpgsql a bit
and am pretty encouraged by what I'm discovering; now I'm at a point
where I'm thinking, "how far do/can I go with this?"
Probably the best example is input validation. Constraints a
Hi,
I have repmgr working to some degree on a couple of servers, but am
having trouble with the "register" part on the slave.
On the master, I run:
# repmgr -f /etc/repmgr/validator/repmgr.conf \
--verbose --force master register
Opening configuration file: /etc/repmgr/validator/repmgr.conf
Thanks for the help, and for different design options it really helped me. I
had
a look on vertical design and horizontal design and this is some cons and pros
in general for vertical design
Advantages:
•Avoid null values and utilize storage
•Avoid constant schema changes due to adding
On Wed, Jul 27, 2011 at 10:36 AM, Toby Corkindale
wrote:
> Hi,
> I have repmgr working to some degree on a couple of servers, but am having
> trouble with the "register" part on the slave.
>
> On the master, I run:
> # repmgr -f /etc/repmgr/validator/repmgr.conf \
> --verbose --force master regis
thanks! working now
On Wed, Jul 27, 2011 at 3:54 PM, John R Pierce wrote:
> On 07/27/11 12:48 AM, John R Pierce wrote:
>>
>> ...hopefully its reserved...
>
> errr. i meant to type RESOLVED. hah.
>
> --
> john r pierce N 37, W 122
> santa cruz ca
Dear all,
I take backup of postgres databases with pg_dump command.
But it didn't take backup of all sequences,views & functions in
different databases.
I want to know how we can complete backup so we can get complete data
after restoring from a single file.
I faced errors when dumping data
On 27/07/2011 10:51, Adarsh Sharma wrote:
> Dear all,
>
> I take backup of postgres databases with pg_dump command.
> But it didn't take backup of all sequences,views & functions in
> different databases.
That's because you told it to backup only the postgres database. pg_dump
only dumps a single
Raymond O'Donnell wrote:
On 27/07/2011 10:51, Adarsh Sharma wrote:
Dear all,
I take backup of postgres databases with pg_dump command.
But it didn't take backup of all sequences,views & functions in
different databases.
That's because you told it to backup only the postgres database.
> I take backup of postgres databases with pg_dump command.
> But it didn't take backup of all sequences,views & functions in
> different databases.
>
> I want to know how we can complete backup so we can get complete data
> after restoring from a single file.
>
> I faced errors when dumping data
On 27/07/2011 11:31, Adarsh Sharma wrote:
> Raymond O'Donnell wrote:
>> On 27/07/2011 10:51, Adarsh Sharma wrote:
>>
>>> Dear all,
>>>
>>> I take backup of postgres databases with pg_dump command.
>>> But it didn't take backup of all sequences,views & functions in
>>> different databases.
>>>
I am pleased to announce the release of ODB 1.5.0 with support for
PostgreSQL.
ODB is an open-source object-relational mapping (ORM) system for C++. It
allows you to persist C++ objects to a relational database without having
to deal with tables, columns, or SQL and without manually writing any of
On Wed, Jul 27, 2011 at 1:41 AM, Chris Travers wrote:
> On Tue, Jul 26, 2011 at 8:13 PM, Karl Nack wrote:
>>> The current svn trunk (to be 1.3) does.
>>
>> So how far do you take this? I've been playing around with plpgsql a bit
>> and am pretty encouraged by what I'm discovering; now I'm at a po
Hi,
Does slony use work_mem?
We are considering to limit work_mem on a per task basis so that
demanding tasks can get more with a low risk of entering SWAP.
(work_mem is used for:
ORDER BY, DISTINCT, merge joins, hash joins, hash-based aggregation,
and hash-based processing of IN subqueries. )
C
On Wed, Jul 27, 2011 at 7:01 AM, Merlin Moncure wrote:
> Note, we wrote libpqtypes (http://libpqtypes.esilo.com/) precisely to
> deal with this problem -- first class handling of arrays and
> composites in the client. It's not much help for a perl client, but I
> think similar methodologies can
> I wonder which other languages have first class support for these areas of
> Pg?
While already supporting most if not all standard PG datatypes the
psycopg2 interface lets you write in/out wrappers of arbitray
complexity mapping PG <-> Python datatypes and insert them into
the driver at runtime.
- Original Message -
> On Wed, Jul 27, 2011 at 10:36 AM, Toby Corkindale wrote:
> > Hi,
> > I have repmgr working to some degree on a couple of servers, but am
> > having
> > trouble with the "register" part on the slave.
> >
> > On the master, I run:
> > # repmgr -f /etc/repmgr/validator/r
On 07/27/2011 04:37 AM, Filippos wrote:
P.S i will send a message to the admins, to ask them to move the topic to
the sub-forum of perfomance
Don't do that; will just waste their time. pgsql-general is a mailing
list, and the "forum" view you're seeing at Nabble is just a web
interface t
On Tue, Jul 26, 2011 at 6:10 PM, Chris Travers wrote:
> On Tue, Jul 26, 2011 at 3:48 PM, Michael Nolan wrote:
> > I suggest adding the following parameter to pg_restore:
> >
> > --rename-table=
> >
> > When used in conjunction with the --data-only, --schema and -t options
> (all
> > three of
> I wonder which other languages have first class support for these areas
> of Pg?
It'd be nice if PHP could get there. :p Maybe it's time to look at some
of these other languages. Or finally learn C and try hacking on the
extension myself.
Karl Nack
Futurity, Inc
5121 N Ravenswood Ave
Chicago,
On Wed, Jul 27, 2011 at 04:35:45PM +0200, Karsten Hilbert wrote:
> > I wonder which other languages have first class support for these areas of
> > Pg?
>
> While already supporting most if not all standard PG datatypes the
> psycopg2 interface lets you write in/out wrappers of arbitray
> complexit
> The best option is to use exceptions to communicate to the application
> what went wrong and then allow the application to handle those
> exceptions in many cases. In other cases, the application may need to
> know which inputs are mandatory.
So other than sanitizing input and making sure it's
Hello,
I built a c function that exports data from various tables into a text file but
when I compile the function I get this error:
In file included from /usr/include/pgsql/server/postgres.h:48,
from myfile.c:1:
/usr/include/pgsql/server/utils/elog.h:69:28: error: utils/errcode
Hi,
Some of my users are using sqldbx and it's not working due to a dependence on
displaying the content of information_schema.schemata
When I query the view I see content. When they do it, nothing - 0 rows - from
sqldbx, pgadmin or other client.
I suspect that they don't have access to a cata
On Wed, Jul 27, 2011 at 4:36 AM, Toby Corkindale
wrote:
>
> So that looks good, but then I try this on the slave:
> # repmgr -f /etc/repmgr/validator/repmgr.conf \
> --verbose standby register
>
can you show the content of /etc/repmgr/validator/repmgr.conf?
[...]
>
> I can query the database li
On Wed, Jul 27, 2011 at 09:34:20AM -0700, Ioana Danes wrote:
[..]
> #include "/usr/include/pgsql/server/postgres.h"
> #include "/usr/include/pgsql/server/fmgr.h"
#include "postgres.h"
#include "fmgr.h"
> #ifdef PG_MODULE_MAGIC
#ifndef
> PG_MODULE_MAGIC;
> #endif
...and compile with -I`pg_confi
Thanks a lot Sebastian
--- On Wed, 7/27/11, Sebastian Jaenicke
wrote:
> From: Sebastian Jaenicke
> Subject: Re: [GENERAL] error when compiling a c function
> To: "Ioana Danes"
> Cc: "PostgreSQL General"
> Received: Wednesday, July 27, 2011, 2:12 PM
> On Wed, Jul 27, 2011 at 09:34:20AM
> -070
On 07/27/2011 12:38 PM, Ioana Danes wrote:
> Thanks a lot Sebastian
>
> --- On Wed, 7/27/11, Sebastian Jaenicke
> wrote:
>
>> From: Sebastian Jaenicke
>> Subject: Re: [GENERAL] error when compiling a c function
>> To: "Ioana Danes"
>> Cc: "PostgreSQL General"
>> Received: Wednesday, July 27,
Sorry about the long wait between reply.
On Sat, May 7, 2011 at 2:36 PM, Tomas Vondra wrote:
> Resource usually means there's too much I/O so the query is slow, but
> when you try it later the drives are idle and query runs much faster.
> Run some monitoring, e.g. even a simple 'iostat -x' or 'd
Hello all,
I am trying out PostgreSQL 9.1 Beta 3. In particular, I am very interested in
WITH x AS (...) construction.
drop table if exists t;
create table t
(
identifier serial,
title text
);
with c as
(
insert into t (title) values ('old') returning *
)
update t set titl
On Wed, Jul 27, 2011 at 3:18 PM, Peter V wrote:
>
> Hello all,
>
> I am trying out PostgreSQL 9.1 Beta 3. In particular, I am very interested in
> WITH x AS (...) construction.
>
> drop table if exists t;
> create table t
> (
> identifier serial,
> title text
> );
>
> with c as
>
On Wed, Jul 27, 2011 at 2:12 PM, Sebastian Jaenicke
wrote:
> On Wed, Jul 27, 2011 at 09:34:20AM -0700, Ioana Danes wrote:
>
>> #ifdef PG_MODULE_MAGIC
>
> #ifndef
Just to avoid confusion... #ifdef *is* correct. See:
http://www.postgresql.org/docs/current/static/xfunc-c.html
(I can't commen
> Date: Wed, 27 Jul 2011 15:58:04 -0500
> Subject: Re: [GENERAL] WITH x AS (...) and visibility in UPDATE
> From: mmonc...@gmail.com
> To: peterv861...@hotmail.com
> CC: pgsql-general@postgresql.org
>
> On Wed, Jul 27, 2011 at 3:18 PM, Peter V wrote:
> >
On Wed, Jul 27, 2011 at 4:03 PM, Peter V wrote:
>> On Wed, Jul 27, 2011 at 3:18 PM, Peter V wrote:
>> >
>> > Hello all,
>> >
>> > I am trying out PostgreSQL 9.1 Beta 3. In particular, I am very interested
>> > in WITH x AS (...) construction.
>> >
>> > drop table if exists t;
>> > create table t
> Date: Wed, 27 Jul 2011 16:16:48 -0500
> Subject: Re: [GENERAL] WITH x AS (...) and visibility in UPDATE
> From: mmonc...@gmail.com
> To: peterv861...@hotmail.com
> CC: pgsql-general@postgresql.org
>
> On Wed, Jul 27, 2011 at 4:03 PM, Peter V wrote:
> >
On 7/27/2011 4:22 PM, Peter V wrote:
I want to apply updates on a copy of a row, instead on the row itself.
The queries are above were simplied to demonstrate the problem.
So basically I want to do:
1) create the copy of the row and return the identifier
2) apply updates on the new row identifi
On 28/07/11 03:47, Jaime Casanova wrote:
On Wed, Jul 27, 2011 at 4:36 AM, Toby Corkindale
wrote:
So that looks good, but then I try this on the slave:
# repmgr -f /etc/repmgr/validator/repmgr.conf \
--verbose standby register
can you show the content of /etc/repmgr/validator/repmgr.conf?
I did investigate this issue and the problem is pg_has_role function.
Take a look at information_schema.schemata definition below
SELECT (current_database ()) ::information_schema.sql_identifier AS
catalog_name
, (n.nspname) ::information_schema.sql_identifier AS schema_name
, (u.rolname)
> 1) create the copy of the row and return the identifier
> 2) apply updates on the new row identified by the identifier returned in step
> 1
>
> If possible, I want to write this in a single command, to avoid overhead and
> mistakes.
>
> I tried writing a rewrite rule or before trigger, but i
Hi list,
I'm trying to restore a backup into a database with a new name
the dump was done on a 8.4 server with:
pg_dump -F c -f bakfile olddb
i'm trying to restore it with:
createdb newdb; pg_restore -v --jobs=4 --disable-triggers
--no-tablespaces --dbname=newdb bakfile
or even just:
createdb
On 07/27/2011 07:18 PM, Karl Nack wrote:
The best option is to use exceptions to communicate to the application
what went wrong and then allow the application to handle those
exceptions in many cases. In other cases, the application may need to
know which inputs are mandatory.
So other than sa
Hi all,
I have done a MASTER/SLAVE setup. In that I have to do the Incremental
Backup.
Without affecting the existing master/slave setup, how to do the incremental
backup?
Please anyone help on this?
Thanks and Regards
Nithya R
::DISCLAIMER::
---
48 matches
Mail list logo
