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/
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 = '
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
---+-
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
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
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
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_
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 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
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_
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 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
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: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();"
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 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
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 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,
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 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
Hi,
Did any of here use EMC SRDF technology for creating replication with
Postgresql?
Thanks.
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
>
>
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
> ---+-
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
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
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...
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,
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
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
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
"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
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
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
36 matches
Mail list logo
