Arthur Silva wrote on Monday, June 29, 2015 5:23 PM:
> Therefore, I'm asking if it's possible to duplicate my main database on a
> slave server in order to run these cron on this second server... then,
> replicate these changes on the main database (master).
> http://www.postgresql.org/docs/9.3/st
Tim Smith wrote on Friday, June 26, 2015 5:38 PM:
> ERROR: cannot begin/end transactions in PL/pgSQL
> HINT: Use a BEGIN block with an EXCEPTION clause instead.
> CONTEXT: PL/pgSQL function
> app_security.validatesession(app_domains.app_uuid,inet,text,bigint,bigint)
> line 16 at SQL statement
>
John Bleichert wrote on Wednesday, June 24, 2015 4:21 PM:
Ø Would I then configure that new server instance as a standby server as per
doc section 18.6?
Ø Or should I just setup the standby server first? Having re-read 18.6 I think
this is what I want.
I may be wrong but I’m not sure a maste
Hello John,
Since you mentioned a different OS and want to copy the entire instance it
would seem that pg_dumpall is the way to go.
You would then import the dump into the new instance using psql.
See:
http://www.postgresql.org/docs/9.4/static/app-pg-dumpall.html
http://www.postgresql.org/docs/
Albe Laurenz wrote on Friday, June 19, 2015 12:56 PM:
> Holger Friedrich wrote:
> > So how do I craft a query that actually does use lots of memory?
> You increase the parameter "work_mem".
> You can do that globally in postgresql.conf or with SET for one session or
> with SET LOCAL for one tran
Hello list,
What would be the best way of setting up a query that uses lots of memory, in
order to study the effects of resource usage parameters on the performance of
the query?
I thought that a query on a large table involving JOINs would be a way, but
while the backend initially used 1.7 gi
Melvin Davidson wrote on Friday, June 12, 2015 5:10 PM:
> To allow external ip access, you need to specifcally add the ip's to the
> pg_hba.conf on the PostgreSQL server
> and then reload the PostgreSQL cluster. IE: pg_ctl reload
Generally, yes. But the original poster’s error message said “No
You probably mean ts2.user_id not ts2, user_id, right?
Best regards
Holger Friedrich
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Greg Spiegelberg
Sent: Friday, April 24, 2015 3:07 PM
To: pgsql-general@postgresql.org >> PG-General Mailing List
On Tuesday, April 21, 2015 7:43 PM, Andy Colson wrote:
> On 4/21/2015 9:21 AM, holger.friedrich-fa-triva...@it.nrw.de wrote:
>> Exactly what constitutes "reproducible" values from pgbench? I keep
>> getting a range between 340 tps and 440 tps or something like that
> I think its common to get di
Hello list,
Exactly what constitutes "reproducible" values from pgbench? I keep getting a
range between 340 tps and 440 tps or something like that using the same command
line on the same machine. Is that reproducible enough?
The docs state that one should verify that the numbers are reproduci
On Tuesday, February 03, 2015 3:58 AM, Jim Nasby wrote:
> Note that the recursive grep starts at the current directory, so make sure
> you're actually in the pgsql source code when you use it.
> cat ~/bin/pg_grep
> #!/bin/sh
>
> grep -r "$*" * | grep -iv TAGS: | grep -v 'Binary file' | grep -v '.
On Thursday, January 29, 2015 10:14 PM, Adrian Klaver wrote:
> On 01/29/2015 04:36 AM, holger.friedrich-fa-triva...@it.nrw.de wrote:
>> Hello list,
>> What are your experiences with OpenSCG's RPM packages?
[deletia]
> From what I gather it is static binary package built against libraries at a
>
Hello list,
What are your experiences with OpenSCG's RPM packages? It is my impression
that those packages allow vanilla PostgreSQL to run, but trying to build
extensions such as PostGIS against them fails in most (two out of three) cases
due to problems with the included shared libraries.
Th
Adrian Klaver wrote:
> Library mismatch. Looks like rtpostgis-2.0.so is looking for something that
> /lib64/libldap_r-2.4.so.2 is not providing. So, if I am following correctly
> that would be the OpenSCG version. From the looks of it, that library is not
> recent enough.
For the record: Appar
Sorry for misquoting, the command line that reportedly worked had
--encoding=UTF8 not --encoding=UTF-8. I apologize for not paying more
attention.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of
holger.friedrich-fa-
What about taking a cue from the link provided by Adrian,
http://www.g-loaded.eu/2011/02/27/locale-windows/, and initdb a new empty
database cluster not like
initdb.exe --locale=German_Germany.UTF-8
which you say does not work, but rather like
initdb.exe --locale=German_Germany --encoding=UTF
➢ Yeah, more digging on my part seems to indicate that no matter what you
➢ do Windows is going to set the locale to some variety of a codepage.
➢ Unfortunately, I do not use Windows enough to go much further with this.
➢ Hopefully someone more Microsoft fluent can weigh in on this, as this
➢ i
17 matches
Mail list logo
