On Thu, Nov 20, 2014 at 5:09 AM, Josh Berkus wrote:
> On 11/19/2014 11:57 AM, Adrian Klaver wrote:
>>
>> So as not to have lost souls wandering around Seattle in April, LFNW is
>> actually in Bellingham(about 90 miles N):)
>
> I'm now imagining geeks wandering around Pike Place Market with posters
On Wed, Nov 19, 2014 at 12:09 PM, Josh Berkus wrote:
> On 11/19/2014 11:57 AM, Adrian Klaver wrote:
> >
> > So as not to have lost souls wandering around Seattle in April, LFNW is
> > actually in Bellingham(about 90 miles N):)
>
> I'm now imagining geeks wandering around Pike Place Market with po
On 20 Nov 2014 06:11, "John Smith" wrote:
>
> On 11/19/14, Michael Paquier wrote:
> > On Wed, Nov 19, 2014 at 8:37 AM, John Smith
wrote:
> >>
> >> i want to setup a standby slave that listens 24/7 but only syncs when
told
> >> to.
> >>
> >> setting "pause_at_recovery_target (boolean)" in recover
i need some advice:
1. for our small business, i have a master (dev) - slave (prod) setup.
i develop using the master. i get data from other people's dev
(mssql) databases. i also get data from their prod (mssql) databases. i
replicate everything on slave.
apps using the master can connect only t
On 11/19/14, Michael Paquier wrote:
> On Wed, Nov 19, 2014 at 8:37 AM, John Smith wrote:
>>
>> i want to setup a standby slave that listens 24/7 but only syncs when told
>> to.
>>
>> setting "pause_at_recovery_target (boolean)" in recovery.conf on slave
>> doesn't help since docs say it only "spe
On 11/19/2014 12:09 PM, Josh Berkus wrote:
On 11/19/2014 11:57 AM, Adrian Klaver wrote:
So as not to have lost souls wandering around Seattle in April, LFNW is
actually in Bellingham(about 90 miles N):)
I'm now imagining geeks wandering around Pike Place Market with posters
of the Postgres el
All:
We will be having a full day of PostgreSQL talks on March 10th, in
Burlingame CA. This event is co-hosted with FOSS4G-NA, so you can get
your full PostGIS fix.
We are curently looking for both speakers, and sponsors of the event.
More information here:
http://sfpostgres.org/pgday-sf-2015-c
On 11/19/2014 12:57 PM, Adrian Klaver wrote:
On 11/19/2014 11:47 AM, Josh Berkus wrote:
On 11/18/2014 04:23 PM, Joshua D. Drake wrote:
Forwarding this because they are having a dedicated PostgreSQL track
put
on by PgUS. I hope all will submit papers. This is a great
conference of
about 1500. I
On 11/19/2014 11:57 AM, Adrian Klaver wrote:
>
> So as not to have lost souls wandering around Seattle in April, LFNW is
> actually in Bellingham(about 90 miles N):)
I'm now imagining geeks wandering around Pike Place Market with posters
of the Postgres elephant that say "Have You Seen Me?"
;-)
On 11/19/2014 11:47 AM, Josh Berkus wrote:
On 11/18/2014 04:23 PM, Joshua D. Drake wrote:
Forwarding this because they are having a dedicated PostgreSQL track put
on by PgUS. I hope all will submit papers. This is a great conference of
about 1500. It is 100% non-profit and is a great opportunity
On 11/18/2014 04:23 PM, Joshua D. Drake wrote:
> Forwarding this because they are having a dedicated PostgreSQL track put
> on by PgUS. I hope all will submit papers. This is a great conference of
> about 1500. It is 100% non-profit and is a great opportunity to reach out!
Wow, LA in February, SF
On 11/19/2014 08:26 AM, Anil Menon wrote:
Hello,
I would like to ask from your experience which would be the best
"generic" method for checking if row sets of a certain condition exists
in a PLPGSQL function.
I know of 4 methods so far (please feel free to add if I missed out any
others)
1) ge
Hi Anil:
On Wed, Nov 19, 2014 at 5:26 PM, Anil Menon wrote:
> Cons : It seems doing a count(*) is not the best option for PG
>
For this and some of the following options, if you are going to just test
for existence, I would consider adding a limit 1 somewehere on the query,
to let the optimize
Hello,
I would like to ask from your experience which would be the best "generic"
method for checking if row sets of a certain condition exists in a PLPGSQL
function.
I know of 4 methods so far (please feel free to add if I missed out any
others)
1) get a count (my previous experience with ORCL
Hello,
I am trying to build postgresql (and to be more specific, the libraries libpq,
libpgtypes and libecpg) with MSVC 2013 for using them in a 64bit application. I
downloaded the source code (v9.3.5), unzipped the file and run 'build DEBUG
libpq', as nicely described here:
http://www.postgre
On Wed, Nov 19, 2014 at 2:49 AM, VENKTESH GUTTEDAR <
venkteshgutte...@gmail.com> wrote:
>
> i am getting this error
>
> ERROR: function pgp_sym_decrypt(character varying, text) does not
> exist
> LINE 1: SELECT pgp_sym_decrypt(phone_no, keys.privkey),
> pgp_sym_decrypt(us...
>
The en
I re-ran the query in multiple forms, and included it below (I regexed it to
become 'foo2bar' so it's more generic to others).
I also uploaded it as a public spreadsheet to google, because I think that is a
bit easier to look at:
https://docs.google.com/spreadsheets/d/1w9HM8w9YUpu
On 11/19/2014 03:54 AM, Ernesto Quiñones wrote:
Hi friends
I am looking for a postgresql solution in an "appliance" for small business
Appliance has multiple meanings these days. Are you looking for a
software 'appliance' or a complete hardware solution?
What do you want this appliance to d
On Mon, Nov 17, 2014 at 4:27 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Thu, Nov 13, 2014 at 7:34 PM, Tom Lane wrote:
>>> One thing that occurs to me is that if the generic plan estimate comes
>>> out much cheaper than the custom one, maybe we should assume that the
>>> generic's cost estim
On 11/19/14, 6:54 AM, "Ernesto Quiñones" wrote:
>Hi friends
>
>I am looking for a postgresql solution in an "appliance" for small
>business
>
>know somebody who is selling this kind of solutions?
>
>thanks
>
>--
If you are OK with a cloud based solution, Amazon RDS might be a decent
fit for yo
On Wed, 19 Nov 2014 06:54:46 -0500
Ernesto Quiñones wrote:
> Hi friends
>
> I am looking for a postgresql solution in an "appliance" for small business
I guess something like Fujitsu SX2 HA DB is beyond the budget of a small
business, but usually this is the case with an appliance which include
Hi friends
I am looking for a postgresql solution in an "appliance" for small business
know somebody who is selling this kind of solutions?
thanks
--
--
Visita : http://www.eqsoft.net
--
Hello,
I am running postgresql 9.3.5 on Ubuntu14.04.
i have the table two fields of varchar type. while inserting the data
in the following way.
INSERT INTO testusers(username, phone_no)
SELECT pgp_sym_encrypt(test.username, keys.pubkey),
pgp_sym_encrypt(test.phone_no, keys.p
Hi Yanrui:
On Wed, Nov 19, 2014 at 2:48 AM, Yanrui Hu wrote:
> I am partly understanding your explain.
>
Enough for me, it isn't a simple thing to write :)
> the "including connection establish" case means the db connection not only
> socket connection, the "excluding connection establish" ca
24 matches
Mail list logo