On Mon, Jan 6, 2014 at 9:22 PM, Andy Colson wrote:
> Here's an odd question. Kind of an in the future thing.
>
> I have two db's on two smaller boxes I'd like to combine to one big box.
> But one db is replicated and the other doesn't need it.
>
> I know currently you must replicate the entire
On 1/6/2014 5:06 PM, Anand Kumar, Karthik wrote:
We run postgres 9.1.11, on Centos 6.3, and an ext2 filesystem
also, centos 6.3 is a couple year old release, you really should `yum
update` and get the latest centos 6.everything. been lots and lots of
fixes between 6.3 and now (6.5 was the l
"Anand Kumar, Karthik" writes:
> We run postgres 9.1.11, on Centos 6.3, and an ext2 filesystem
> Everything will run along okay, and every few hours, for about a couple of
> minutes, postgres will slow way down. A "select 1" query takes between 10 and
> 15 seconds to run, and the box in general
Here's an odd question. Kind of an in the future thing.
I have two db's on two smaller boxes I'd like to combine to one big box. But
one db is replicated and the other doesn't need it.
I know currently you must replicate the entire cluster. I was just wondering,
would it be a possible way f
On 1/6/2014 5:06 PM, Anand Kumar, Karthik wrote:
We run postgres 9.1.11, on Centos 6.3, and an ext2 filesystem
please tell me thats a typo, and you're using ext4, or at least ext3.
We do typically have a lot of idle connections (1500 connections
total, over a 1000 idle at any given time). We
Hi,
We run postgres 9.1.11, on Centos 6.3, and an ext2 filesystem
Everything will run along okay, and every few hours, for about a couple of
minutes, postgres will slow way down. A "select 1" query takes between 10 and
15 seconds to run, and the box in general gets lethargic.
This causes a pil
CS DBA wrote on 06.01.2014 23:30:
We have a few very large tables with unique indexes on a column but
the column is not defined as the Primary Key. Can we add a PK
constraint via updates to the system catalogs so we can avoid the
lengthy checks that would take place if we ran "alter table add
co
Hi All;
We have a few very large tables with unique indexes on a column but the
column is not defined as the Primary Key. Can we add a PK constraint
via updates to the system catalogs so we can avoid the lengthy checks
that would take place if we ran "alter table add constraint primary key...
On 01/06/2014 02:42 PM, Tom Lane wrote:
Jayadevan M writes:
I am able to login as postgres with password from the same machine. So it
is not an expiry issue (as you too concluded). Output from strace is about
500 lines. I am pasting what I feel may be relevant. I hope this will be
useful.
Wel
Jayadevan M writes:
> I am able to login as postgres with password from the same machine. So it
> is not an expiry issue (as you too concluded). Output from strace is about
> 500 lines. I am pasting what I feel may be relevant. I hope this will be
> useful.
Well, this is pretty interesting:
> o
Le dimanche 05 janvier 2014 à 19:32 -0800, gromitracer a écrit :
> Below are my roles/users and their attributes. Posgresql version: 9.2
>
>Role name |Attributes
>
> | Member of
> ---+-
On Sun, Jan 5, 2014 at 7:32 PM, gromitracer wrote:
> Hello all. I am more accustomed in doing things the Oracle way and I am
> trying to get a hold postgres :)
>
> Below are my roles/users and their attributes. Posgresql version: 9.2
>
>Role name |Attributes
> | Member of
>
>
Hi,
Did any of here use EMC SRDF technology for creating replication with
Postgresql?
Thanks.
On Sat, Jan 4, 2014 at 1:44 AM, David Johnston wrote:
> john.tiger wrote
>> select * from users where jsondata->>'username' = 'jdoe' works but
>> returns field names, etc besides the data row.how can we get json
>> data back ?
>>
>> select row_to_json from users where jsondata->>'username'='jd
Stephen Woodbridge writes:
> On 1/6/2014 10:32 AM, Tom Lane wrote:
>> Put "CHECK_FOR_INTERRUPTS();" in some suitably safe place.
> So if I need to clean up then I should check do something like:
> if (InterruptPending) {
> /* cleanup here */
> ProcessInterrupts();
> }
Uh, no, you shou
On 01/06/2014 08:45 AM, Martijn van Oosterhout wrote:
On Mon, Jan 06, 2014 at 08:17:37AM -0800, Adrian Klaver wrote:
On 01/06/2014 07:35 AM, Martijn van Oosterhout wrote:
On Mon, Jan 06, 2014 at 07:16:25AM -0800, Adrian Klaver wrote:
On 01/06/2014 03:18 AM, Martijn van Oosterhout wrote:
Hoi,
On Mon, Jan 06, 2014 at 08:17:37AM -0800, Adrian Klaver wrote:
> On 01/06/2014 07:35 AM, Martijn van Oosterhout wrote:
> >On Mon, Jan 06, 2014 at 07:16:25AM -0800, Adrian Klaver wrote:
> >>On 01/06/2014 03:18 AM, Martijn van Oosterhout wrote:
> >>>Hoi,
> >>>
> >>>
> >
> >I'm not sure what you mean,
On 1/6/2014 10:32 AM, Tom Lane wrote:
Stephen Woodbridge writes:
I writing some functions for postgresql extension in C/C++ and I would
like to be able to check for a pending CancelRequest from the frontend
so I can take appropriate action to honor this request.
Put "CHECK_FOR_INTERRUPTS();"
David,
That seems to have fixed it! I was going down a path of grabbing the
column's type from pg_attribute and trying to work from there, but was
still having some of the same issues.
Thanks everyone else that replied as well!
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, In
Hi all,
I writing some functions for postgresql extension in C/C++ and I would
like to be able to check for a pending CancelRequest from the frontend
so I can take appropriate action to honor this request.
1. How to I check if a request is pending?
2. What is the appropriate action?
I assu
On 01/06/2014 07:03 AM, zach cruise wrote:
I am not sure if you have already answered it and I have somehow missed it:
- Are these 'a' and 'b' on two different servers? ( I think they are on
different servers)
> yes
- Did you stop the server on 'b' before you replaced the files and
attempted a
On 01/06/2014 07:35 AM, Martijn van Oosterhout wrote:
On Mon, Jan 06, 2014 at 07:16:25AM -0800, Adrian Klaver wrote:
On 01/06/2014 03:18 AM, Martijn van Oosterhout wrote:
Hoi,
I'm not sure what you mean, isn't this the recommended way of doing
things? The configuration comes from here:
htt
On 01/06/2014 07:42 AM, David Johnston wrote:
Adrian Klaver-3 wrote
In the real function I'm writing, the columns to be used in the string
being created are pulled from a configuration table, so their types
could be anything. So casting the quote_literal() calls is not really an
option here.
On 1/6/2014 10:00 AM, Pfuntner, John wrote:
If I've done a palloc() to get storage inside a user-defined function and raise
an error using ereport(), should I be using pfree() to release the storage
before the ereport()?
Consider this example in C:
PG_FUNCTION_INFO_V1(Example);
Datum
Adrian Klaver-3 wrote
>>
>>
>> In the real function I'm writing, the columns to be used in the string
>> being created are pulled from a configuration table, so their types
>> could be anything. So casting the quote_literal() calls is not really an
>> option here.
>>
>> Any help would be appreciate
On 01/06/2014 03:18 AM, Martijn van Oosterhout wrote:
Hoi,
I've setup a up WAL shipping configuration as described in the wiki. On
the master I have:
archive_mode= on
archive_command = 'cp %p /path_to/archive/%f'
and on the slave in the recovery.conf I have:
archive_cleanup_command = 'pg_
On Mon, Jan 06, 2014 at 07:16:25AM -0800, Adrian Klaver wrote:
> On 01/06/2014 03:18 AM, Martijn van Oosterhout wrote:
> >Hoi,
> >
> >I've setup a up WAL shipping configuration as described in the wiki. On
> >the master I have:
> >
> >archive_mode= on
> >archive_command = 'cp %p /path_to/archiv
Stephen Woodbridge writes:
> I writing some functions for postgresql extension in C/C++ and I would
> like to be able to check for a pending CancelRequest from the frontend
> so I can take appropriate action to honor this request.
Put "CHECK_FOR_INTERRUPTS();" in some suitably safe place.
On 01/06/2014 03:18 AM, Martijn van Oosterhout wrote:
Hoi,
I've setup a up WAL shipping configuration as described in the wiki. On
the master I have:
archive_mode= on
archive_command = 'cp %p /path_to/archive/%f'
and on the slave in the recovery.conf I have:
archive_cleanup_command = 'pg_
I am not sure if you have already answered it and I have somehow missed it:
- Are these 'a' and 'b' on two different servers? ( I think they are on
different servers)
> yes
- Did you stop the server on 'b' before you replaced the files and
attempted a startup?
> yes
> thanks. it doesn't help. i
If I've done a palloc() to get storage inside a user-defined function and raise
an error using ereport(), should I be using pfree() to release the storage
before the ereport()?
Consider this example in C:
PG_FUNCTION_INFO_V1(Example);
Datum
Example(PG_FUNCTION_ARGS) {
VarChar* pstrin
Thank you Pavel. That's exactly what I needed to get started.
On Jan 6, 2014 3:25 AM, "Pavel Stehule" wrote:
> Hello
>
>
>
> 2014/1/6 Erik Darling
>
>> Hi,
>>
>> I've been developing for MS SQL around four years. I'm starting out with
>> some work in Postgresql next week, and I'd like to know i
We have client databases in 3 different region in the world, namely:
cr_master, mx_master & mlt_master db. These 3 databases have exactly the
same structure, with different subset of client data.
For reporting purpose, we aggregate these 3 db to single collector, using
Bucardo replication. Recentl
Hello all. I am more accustomed in doing things the Oracle way and I am
trying to get a hold postgres :)
Below are my roles/users and their attributes. Posgresql version: 9.2
Role name |Attributes
| Member of
---+-
Hoi,
I've setup a up WAL shipping configuration as described in the wiki. On
the master I have:
archive_mode= on
archive_command = 'cp %p /path_to/archive/%f'
and on the slave in the recovery.conf I have:
archive_cleanup_command = 'pg_archivecleanup /path/to/archive/ %r'
restore_command = '
Hello
2014/1/6 Erik Darling
> Hi,
>
> I've been developing for MS SQL around four years. I'm starting out with
> some work in Postgresql next week, and I'd like to know if there's any
> equivalent way to do something like this (from my word press)
>
> http://sqldriver.wordpress.com/2013/12/09/
36 matches
Mail list logo
