ry (C:\Program Files\PostgreSQL\9.6\lib\plpython3.dll).
Please let us know if you have any more queries in this regards.
Vipul Shukla
EnterpriseDB Corporation
From: Alan Millington
To: EnterpriseDB Customer Support"
Sent: 25 Aug 2017, 12:12 PM
My question was concerning plpython2.dll, not plp
There were several queries in 2014 regarding the absence of plpython2.dll from
the Enterprise DB Postgres distribution for Win32. I should have thought that
this omission was simply an oversight, which would have been rectified by now.
However, I find that plpython2.dll is still missing from the
There were several queries in 2014 regarding the absence of plpython2.dll from
the Enterprise DB Postgres distribution for Win32. I should have thought that
this omission was simply an oversight, which would have been rectified by now.
However, I find that plpython2.dll is still missing from the
On Wednesday 10 May 2017 17:13:50 Ron Ben wrote:
> Not possible
> https://www.postgresql.org/download/linux/debian/
>
> To upgrade I do: apt-get install postgresql-9.3
> There is no way to "roll back" from here.
> I can not choose which version to install, it install the latest version
> packed
On Thursday 04 May 2017 14:47:54 John R Pierce wrote:
> On 5/4/2017 2:28 PM, Alan Hodgson wrote:
> > On Thursday 04 May 2017 14:21:00 John R Pierce wrote:
> >> or EBS, and I've heard from more than a few people that EBS can be
> >> something of a sand trap.
>
On Thursday 04 May 2017 14:21:00 John R Pierce wrote:
> or EBS, and I've heard from more than a few people that EBS can be
> something of a sand trap.
>
Sorry for following up off-topic, but EBS has actually improved considerably
in the last few years. You can get guaranteed (and very high) IOPS
> On Fri, Apr 21, 2017 at 12:40 PM, Edson Lidorio
>
> wrote:
> > Hi,
> > There was a disaster in my development note. I was able to recover the
> > data folder. PostgreSQL 9.6.2, was installed in Centos 7.
> >
> > Here are the procedures I'm trying to initialize Postgresql for me to do a
> > bac
On Friday 17 February 2017 18:18:20 Michael Tyson wrote:
> postgres=# \q
> pi@raspi ~ $ sudo -u postgres psql testdb
> psql: FATAL: database "testdb" does not exist
> pi@raspi ~ $ sudo -u postgres createdb testdb
> createdb: database creation failed: ERROR: duplicate key value violates
> unique c
On Tuesday 25 October 2016 17:08:26 t.dalpo...@gmail.com wrote:
> Hi,
> let's suppose I have:
> - a primary server with its own local archive location, configured for
> continuous archiving
> - a standby server without archive.
> These servers are configured for Sync streaming replication .
> L
I like this, seeing that the keys of JSON docs are replicated in every
record.
I makes my old-school DBA-Sense start to itch.
On Fri, Sep 30, 2016 at 8:58 AM, Aleksander Alekseev <
a.aleks...@postgrespro.ru> wrote:
> Hello.
>
> I've just uploaded ZSON extension on GitHub:
>
> https://github.co
On Tuesday 21 June 2016 19:34:18 Ramalingam, Sankarakumar wrote:
> Hi I have my standby (streaming replication) down due to missing wal files.
> You would see the same error in the logs stating "cannot find the wal file
> ..." What is the best way to get it going so that when we switch between
> st
On Tuesday, May 31, 2016 10:13:14 AM Jim Longwill wrote:
> I am trying to setup a 2nd, identical, db server (M2) for development
> and I've run into a problem with starting up the 2nd Postgres installation.
>
> Here's what I've done:
>1) did a 'clone' of 1st (production) machine M1 (so both ma
On Friday, May 27, 2016 05:32:08 PM Melvin Davidson wrote:
> Well, Slony certainly will do the trick.
> Keep in mind you will need to do schema only first to the slave.
> You set up replication from the old server with the db on the new server as
> the slave. Then you initiate replication. It will
On Monday, May 16, 2016 03:41:23 PM David G. Johnston wrote:
> I have a psql script that obtains data via the \copy command and loads it
> into a temporary table. Additional work is performed possibly generating
> additional temporary tables but never any "real" tables. Then the script
> outputs,
On Wednesday, April 06, 2016 10:33:16 AM Lars Arvidson wrote:
> > I'd guess it's probably more like option 3 - Glusterfs ate my database.
>
> Hi, thanks for your reply!
> We do archive logs on a distributed Glusterfs volume in case the streaming
> replication gets too far behind and the transactio
On Tuesday, April 05, 2016 12:55:04 PM Lars Arvidson wrote:
> Is there something I missed in the switchover or could this be a bug?
>
I'd guess it's probably more like option 3 - Glusterfs ate my database.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
I have removed SELECT rights from the pg_proc.prosrc column so that I
can hide
the source code of stored functions. This is working OK, however I
would really
like to just hide certain functions via RLS. I understand that great
damage could
be done to the system catalog by allowing users to
subscribe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tuesday, December 15, 2015 11:26:40 PM zh1029 wrote:
> Hi,
> It seems low performance PostgreSQL(9.3.6) while writing data to glusterFS
> distributed file system. libgfapi is provide since GlusterFS version 3.4 to
> avoid kernel visits/data copy which can improve its performance. But I
> didn'
On Wednesday, December 09, 2015 07:55:09 AM FattahRozzaq wrote:
> archive_mode = on
> archive_command = 'cp -i %p /home/postgres/archive/master/%f'
>
>
> The WAL archive folder is at /home/postgres/archive/master/, right?
> This directory consumes around 750GB of Disk-1.
> Each segment in the /ho
On Wednesday, August 26, 2015 08:25:02 PM Cory Tucker wrote:
> What settings would you recommend? Also, it just occurred to me that I
> should try to disable/drop all indexes (especially since they will be
> recreated) later so that those are not updated in the process.
Don't drop the indexes you
system level copy work? Will I
run into the same problems?
alan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thank you for that, makes sense. Another fine example of RTFM!
alan
> On Feb 27, 2015, at 10:04 AM, David G Johnston
> wrote:
>
> Alan Nilsson wrote
>> I have 4 machines in a cluster: 1 master & 2 replicates (hot standby mode)
>> on OSX, 1 replicate (hot stand
thing to Linux and this box is a test bed. Before I commit everything to
a new linux cluster I’ld like to understand what I am seeing.
thanks
alan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpr
On Wednesday, December 17, 2014 01:55:46 PM Thomas Kellerer wrote:
> Albe Laurenz schrieb am 17.12.2014 um 11:07:
> > and the performance will be worse than reading files from the file system.
>
> There is a Microsoft research [1] (from 2006) which tested this "myth" using
> SQL Server. It showed
Awesome - thanks Tom, works.
alan
> On Dec 12, 2014, at 1:06 PM, Tom Lane wrote:
>
> Alan Nilsson writes:
>> I am trying to link libuuid into a custom extension, here is my make file
>> (building PG 9.3.5 on CentOS 6.5 (GCC 4.4.7) fwiw):
>
>> MODULES = aitpow
d is not linked in.
If I make clean, make, then just execute the last gcc invocation to link the
extension then manually tack -luuid at the end, all is good.
Is there something simple I’m missing?
thanks
alan
> On Jun 19, 2013, at 6:57 AM, Peter Eisentraut wrote:
>
> On 6/6/13
On Friday, October 03, 2014 11:24:31 AM Israel Brewster wrote:
> I have a Postgresql 9.3.5 server running on CentOS 6.5. In looking at some
> stats today, I saw that it was handling about 4-5 transactions/second
> (according to the SELECT sum(xact_commit+xact_rollback) FROM
> pg_stat_database; quer
On Tuesday, September 23, 2014 02:05:48 PM Nick Guenther wrote:
> I uninstalled all the postgres subpackages and rebuilt them from
> ports, and ended up with an identical plpython2.so, which has these
> checksums:
> SHA256 (/usr/local/lib/postgresql/plpython2.so) =
> 8c7ff6358d9bf0db342e3aca1762cd7
On Monday, September 22, 2014 11:17:05 AM Luke Coldiron wrote:
> The actual size of the table is around 33 MB.
> The myFunc function is called every 2.5 seconds and the wasUpdated function
> every 2 seconds by separate processes. I realize that running a FULL VACUUM
> or CLUSTER command on the tabl
On Friday, August 29, 2014 04:14:35 AM Yogesh. Sharma wrote:
> Dear David,
>
> > Are you currently using PostgreSQL?
>
> Currently we are using PostgreSQL 8.1.18 version on RHEL 5.8.
> Now we plan to update this to PostgreSQL 9.0 version with RHEL6.5. As in
> verion 9.0 I found least Compatibili
On Monday, July 21, 2014 09:05:18 PM Karthik Iyer wrote:
> Hello,
>
> We are planning to upgrade Postgres from 9.0 to 9.3. Was wondering
> if there are any serious changes that I have to look out for
> (syntax/datatypes changes) so that my code does not break.
>
http://www.postgresql.org/do
On Thursday, June 19, 2014 10:21:56 AM Andy Colson wrote:
> On 06/16/2014 08:10 PM, sunpeng wrote:
> > We have many small size(most fixed size) images, how to store them? There
> > are two options: 1. Store images in folders, managed by os file system,
> > only store path in postgresql 2. Store ima
On Monday, June 09, 2014 08:05:41 PM Khangelani Gama wrote:
> Hi All
>
> I would like to re-post the problem we have. The secondary server ran out
> the disc space due the replication problem (Connection Time out).
The secondary server would not (could not) run out of drive space due to a
proble
On Monday, June 09, 2014 04:28:53 PM Khangelani Gama wrote:
> Please help me with this, my secondary server shows a replication problem.
> It stopped at the file called *00054BAF00AF …*then from here
> primary server kept on sending walfiles, until the walfiles used up the
> disc space
On Wednesday, June 04, 2014 10:49:18 PM sramay wrote:
> relation "public.file_attachments" does not exist
.. is almost certainly not a size problem. What does your PostgreSQL log say?
I suspect your app is connecting to the wrong database.
--
Sent via pgsql-general mailing list (pgsql-general@
Ah yes once again if I’ld just RTFM….. Thanks for pointing that out, I think I
can work with that.
alan
On May 13, 2014, at 2:59 PM, Susan Cassidy
wrote:
> You can log to syslog, and use the syslog definitions file (syslog.conf) to
> pipe the output to a program that can do whatev
All
Is there a hook that someone could direct me to that I can use to redirect
logging output? I.e. I would like to write a small module that pre loads and
substitutes the loggers file descriptor with my own to redirect that output.
Possible?
thanks
alan
--
Sent via pgsql-general
Perfect, thank you.
On Apr 16, 2014, at 9:56 PM, Michael Paquier wrote:
> On Thu, Apr 17, 2014 at 8:04 AM, Alan Nilsson wrote:
> Is it possible to allocate a small chunk of shared memory outside of any
> pools(i.e. manually alloced & de-alloced) that is visible to all processes
/API to do this?
alan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Monday, April 14, 2014 09:13:51 AM Steve Clark wrote:
> How did you deal with binaries and libraries, as well as third party apps
> like perl modules or php/apache modules?
The 8.4 library package usually ends up installed to satisfy other package
requirements.
Binaries get handled through th
On Wednesday, April 09, 2014 09:02:02 PM Brent Wood wrote:
> Given the likely respective numbers of each OS actually out there, I'd
> suggests BSD is very over-represented in the high uptime list which is
> suggestive.
Suggestive of ... sysadmins who don't do kernel updates?
--
Sent via pgsql-
On Thursday, April 03, 2014 02:48:03 PM Steven Schlansker wrote:
> On Apr 2, 2014, at 3:08 PM, Jacob Scott wrote:
> • pg_start_backup
> • Take a filesystem snapshot (of a volume containing postgres data but
> not
> pg_xlog) • pg_stop_backup
> • pg_ctl stop
> • Bring a new
On Tuesday, March 25, 2014 02:56:48 PM Frank Foerster wrote:
> Hi,
>
> we are currently in the process of upgrading a production/live 1 TB
> database from 9.2 to 9.3 via pg_dump, which is quite a lengthy process.
>
> Fortunately we have a capable spare-server so we can restore into a clean,
> fre
off and completed.
According to 24.3 in the docs, pg_start_backup() performs a checkpoint. So I
was surpassed that using the pg_baseback utility I had to manual kick a
checkpoint before the transfer would start.
Is this correct behavior?
alan
fwiw, invocation:
pg_basebackup -P --xlog —host
Thanks all
alan
On Jan 15, 2014, at 6:30 AM, Michael Paquier wrote:
>
>
>
> On Wed, Jan 15, 2014 at 8:05 PM, Sameer Kumar wrote:
> The error you are seeing is triggered because this relation file
> exceeds MAX_TAR_MEMBER_FILELEN or 8GB for a single tar member, which
>
ync->out of backup mode
dance.
thanks
alan
ly I mangle the use of libpq, it should not be sending
anything to stdout.
alan
On Oct 26, 2013, at 6:53 AM, Tom Lane wrote:
> Alan Nilsson writes:
>> I ran into something tonight that seems relevant here, or certainly related:
>> I recently updated my app(s) libpq version
, and 90300. Neither version 90102 & 90203 spewed to
stdout.
I don't know if this is causing the OP's crash, but it seems to me that there
is something going on in libpq that needs to be looked at. If nothing else
than to get rid of the spewing to stdout.
alan
On Oct 10, 20
On Thursday, October 24, 2013 11:13:34 PM Jayadevan wrote:
> Alan Hodgson wrote
>
> > That's basically what warm standby's do, isn't it? As long as they keep
> > recovery open it should work.
>
> A warn standby will be almost in sync with the primary, righ
On Thursday, October 24, 2013 11:31:38 AM John R Pierce wrote:
> On 10/24/2013 9:47 AM, Jeff Janes wrote:
> > I restore from my base backup plus WAL quite often. It is how I get a
> > fresh dev or test instance when I want one. (It is also how I have
> > confidence that everything is working well
ear);
what version did/does this come into effect?
alan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
perfect, thanks much
alan
On Jun 20, 2013, at 1:27 AM, Pavel Stehule wrote:
> Hello
>
> I wrote lot of C VARIADIC functions - some examples are in core -
> "format" function
>
> Schema | Name| Result data type |
On Thursday, June 20, 2013 07:52:21 AM Merlin Moncure wrote:
> OP needs to explore use of connection pooler, in particular pgbouncer.
> Anyways none of this explains why the server is actually crashing.
It might be hitting file descriptor limits. I didn't dig into the earlier part
of this thread
Has anyone got any pointers on implementing a C function in an extension that
takes variadic args? I would like to do something like:
select my_function(XXX,...); where XXX will be between 1 and many integers.
Possible? I didn't see any examples in the contrib directory.
--
Sent via pgsq
that was indeed the case. Did not think to look at that, thanks much for the
kick :)
alan
On May 7, 2013, at 7:30 PM, Tom Lane wrote:
> Alan Nilsson writes:
>> Could someone explain to me what I'm missing here.
>
> Probably there are some NULLs in dasp.asp_id. NOT IN c
-> Seq Scan on dasp (cost=0.00..170.32 rows=1932 width=4)
(8 rows)
I see that the first query, which returns the expected result has an additional
filter in the plan. How does that filter materially affect the outcome? Since
the filter is true for every tuple, I would expect the same result from both
queries.
thanks
alan
On Wednesday, January 23, 2013 09:10:40 AM Ian Harding wrote:
> The System:
>
> Linux beta 2.6.32-279.19.1.el6.x86_64 #1 SMP Wed Dec 19 07:05:20 UTC 2012
> x86_64 x86_64 x86_64 GNU/Linux
>
That looks like a CentOS 6 system.
Go to http://yum.postgresql.org/repopackages.php
Find the repo appropr
On Monday, January 21, 2013 08:40:05 PM bhanu udaya wrote:
> Hello,Thanks alot for all your replies. I tried all settings suggested, it
> did not work. pg_restore is very slow. It does not come out less than 1 1/2
> hour. Can you please let me know the procedure for Template. Will it
> restore the
Is there any sql/psql command to force a log roll (i.e. start a new log file)?
alan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wednesday, December 05, 2012 02:44:39 AM Edson Richter wrote:
> Sort (cost=11938.72..11938.74 rows=91 width=93)
>Sort Key: t0.nome
>-> Nested Loop (cost=0.00..11938.42 rows=91 width=93)
> -> Nested Loop (cost=0.00..11935.19 rows=91 width=85)
>-> Seq Scan on
On Monday, November 05, 2012 05:15:41 AM salah jubeh wrote:
> Hello,
>
> I have the following scenario, I would like to upgrade a database server
> from 8.3 to 9.1. The upgrade includes also a hardware upgrade.
>
>
> I would like to have the following
>
> 1. Make sure that the upgraded server a
On Monday, October 22, 2012 05:55:07 PM Nikolas Everett wrote:
> I was just looking at
> http://www.postgresql.org/docs/devel/static/release-9-2.html and it
> mentioned that a dump/reload cycle was required to upgrade from a previous
> release. I just got done telling some of my coworkers that PG
> is it that you want?
> I've come across a few mentions of Heartbeat being used for PostgreSQL
> failover, do have any links to more information about this?
If you're going to use Heartbeat on a 2-server setup, you should use DRBD for
the replication, not the PostgreSQL replication. DRBD basical
On Monday, October 01, 2012 03:10:43 PM Shaun Thomas wrote:
> I can't remember about Puppet since I haven't used it in so long, but
> bcfg2 is basically just a giant directory structure, and we put ours in
> GIT for safekeeping and to track changes. Implementing ACLs in GIT is a
> bit of a PITA, so
alan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
itor for Python, and another
for Postgres.
From: Leif Biberg Kristensen
To: Postgres general mailing list
Cc: Alan Millington
Sent: Thursday, 20 September 2012, 16:44
Subject: Re: [GENERAL] Using psql -f to load a UTF8 file
Torsdag 20. september 2012
I am running Postgres 8.4.1 on Windows XP Professional Service Pack 3. My
database is UTF8. I use psql -f to load files containing DDL and DML commands.
I discovered a long time ago that psql does not like UTF8 files: it complains
about the byte order mark on the first line. Up to now I have wor
On Thursday, September 06, 2012 05:06:27 PM Jeff Janes wrote:
> For updating 20 million out of 500 million rows, wouldn't a full table
> scan generally be preferable to an index scan anyway?
>
Not one table scan for each row updated ...
--
Sent via pgsql-general mailing list (pgsql-general@po
On Friday, August 31, 2012 12:41:42 PM fellipeh wrote:
> Here is error msg:
> http://postgresql.1045698.n5.nabble.com/file/n5722180/erro_PG.png
>
> sorry, but in portuguese..
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Tigger-after-delete-with-plpgsql-tp
On Friday, August 31, 2012 12:12:32 PM fellipeh wrote:
> Yes, the error appears when I delete "nfentrada_item" row
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Tigger-after-delete-with-plpgsql-tp
> 5722154p5722173.html Sent from the PostgreSQL - general mailing list arc
On Friday, August 31, 2012 03:14:15 PM Fellipe Henrique wrote:
> CREATE TRIGGER nfentrada_item_tr1
> BEFORE DELETE
> ON public.nfentrada_item FOR EACH ROW
> EXECUTE PROCEDURE public.nfentrada_item_ad0();
>
> here is my nfentrada_item_ad0();
>
> delete
> from MOVIMENTO
> wher
On Friday, August 31, 2012 02:10:47 PM Fellipe Henrique wrote:
> Hello, I`m try to use this code for my After Delete trigger:
>
> delete
> from MOVIMENTO
> where (IDEMPRESA = OLD.idempresa) and
> (upper(TABELA) = 'NFENTRADA_ITEM') and
> (CODIGO = OLD.idempresa_item);
>
> But
On Wednesday, August 29, 2012 12:35:32 PM Little, Douglas wrote:
> Is there a method for having unix env variables incorporated into a psql sql
> statement? Ie
> Export var='dev'
> Psql =c 'select count(*) from $var.customer;'
>
Use double-quotes, not single-quotes. Bash won't interpolate variabl
On Tuesday, August 28, 2012 11:52:26 AM Ing.Edmundo.Robles.Lopez wrote:
> Please, could you help to give peace of mind to my boss and make sure
> that the version we choose to be as smooth as possible compatible with
> version 8.3?
>
All compatibility changes are indicated in the upgrade notes fr
On Wednesday, August 22, 2012 02:43:05 PM Alan Hodgson wrote:
> The most likely way to get this done is with Slony. Setup a Slony slave,
> upgrade the slave to 9.1 with a dump/reload, run it and let Slony catch it
> up, and then promote it to be the Slony cluster master and switch your
On Wednesday, August 22, 2012 05:17:10 PM Scott Briggs wrote:
> So we have a large TB database that we need to migrate to 9.1 and I'm
> wondering if there's a way to do this process in stages.
>
> Since the date/time storage types changes between 8.3 and 8.4, I
> realize we'll have to dump the dat
On Wednesday, August 22, 2012 04:10:01 PM Andrew Hannon wrote:
> Just looking into High IO instances for a DB deployment. In order to get
> past 1TB, we are looking at RAID-0. I have heard
> (http://hackerne.ws/item?id=4266119) there might be a problem if TRIM isn't
> supported. Does anyone know if
On Friday, July 27, 2012 11:59:49 AM Ing.Edmundo.Robles.Lopez wrote:
> Hi, i have postgres 8.3 running in SCO Openserver 5.0.7
>
> today, i had problems to start psql, the error mesage was: 'FATAL
> Memory out, Detail: Failed on resqueted size ...' , and after i checked
> the process i notic
On Wednesday, July 18, 2012 12:28:00 PM Bob Pawley wrote:
> It's an insert after trigger function.
>
> The table has a column named fluid_id.
>
> Bob
Could you post the whole function? And a \d on the table?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
On Wednesday, July 18, 2012 11:07:34 AM Bob Pawley wrote:
> Hi
>
> I would appreciate some fresh eyes on this expression -
>
> update p_id.fluids
> set fluid_short =
> (select shape.text
> from shape, num_search
> where (select st_within(shape.wkb_geometry,
> st_geometryn(num_sea
On Wednesday, June 20, 2012 01:10:03 PM Sam Z J wrote:
> Hi all
>
> I'm curious how is wildcards at both ends implemented, e.g. LIKE '%str%'
> How efficient is it if that's the only search criteria against a large
> table? how much does indexing the column help and roughly how much more
> space is
On Wednesday, May 30, 2012 08:22:58 PM Bart Lateur wrote:
> Luckily this is a development machine, but as we don't know what causes
> the problem we fear we might one day face the exact same problem where
> it does matter: on a production machine. So we'd like to know exactly
> what went wrong..
C
On Tue, May 29, 2012 at 05:19:49PM -0700, Jeff Davis wrote:
> On Tue, 2012-05-29 at 18:32 -0400, Alan Gutierrez wrote:
> > Surprised that this works:
> >
> > echo ":foo" | psql --variable foo="SELECT 1 AS FOO;" template1
> >
> > W
h` so that it will escape variables and thwart SQL
injection?
--
Alan Gutierrez - @bigeasy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Saturday, May 19, 2012 04:42:16 PM Clemens Eisserer wrote:
> Hi again,
>
> We are still constantly getting postgresql processes killed by signal
> 9 from time to time, without any idea why or how.
> Syslog seems completly clean.
>
> In case a postgresql process would exceed some restricted res
On Saturday, March 31, 2012 01:52:37 AM clover white wrote:
> HI, i have a problem when using pg, thanks for help. :)
>
> I used command initdb, but nothing was created in my pgdata directory.
> however, I used command ps to list all the processes, and I found inidb
> process kept running all t
On Friday, March 30, 2012 10:00:31 AM Prashant Bharucha wrote:
> Hello All
>
> Could you help me to automatically convert all db request into UTF8 encode ?
>
Set your session client_encoding to match your data. That's about as close as
you can get to automatic.
http://www.postgresql.org/docs
On Tuesday, March 27, 2012 08:20:23 PM Akshay Joshi wrote:
> In my case I won't allow anyone to insert/modify the rows of sample_one
> table. I have already inserted some rows in sample_one table where I
> want one constraint is number of array elements of sample_one.param_names
> and sample.pa
On Thursday, February 16, 2012 09:18:34 PM Andrus wrote:
> PostgreSql 8.4 in windows crashes. After that Windows disk repairing was
> used to repair hard drive. After that Data/base directory from crashed
> server contains lot of files, all files are readable.
>
> PostgreSql 8.4 was reinstalled in
On Thursday, February 09, 2012 10:25:51 PM Daniel Vázquez wrote:
> Hi!
>
> I've set my PGDATA variable in profile
> export PGDATA=/home/mydata/pgsql/data
>
> Testing variable for correct set in enviroment
> $ echo $PGDATA
> /home/mydata/pgsql/data
>
> but when execute:
> $ sudo /etc/init.d/postg
On Wednesday, February 01, 2012 05:13:15 PM Christopher Opena wrote:
> Do you mean 6-12% of total iowait, or per cpu? Our average iowait in the
> last week is 34.31% of a total 1600% with an average idle of 1451.76%. Our
> iowait *does* spike occasionally (today it went up to 148.01%) but it
> do
On Wed, Feb 1, 2012 at 7:38 PM, Christopher Opena
wrote:
> > Hello folks,
> >
> > We've been running into some very strange issues of late with our
> > PostgreSQL database(s). We have an issue where a couple of queries
> > push high CPU on a few of our processors and the entire database locks
On Monday, January 23, 2012 07:54:16 PM Andrew Hannon wrote:
> It is worth noting that, the slave (seemingly) catches up eventually,
> recovering later log files with streaming replication current. Can I trust
> this state?
>
Should be able to. The master will also actually retry the logs and eve
On Tuesday, January 17, 2012 10:34:54 AM Tim Uckun wrote:
> http://www.drbd.org/ ??
> Built in hot standby and hand rolled scripts.
>
I have a few clusters running on EC2 using DRBD to replicate between
availability zones. It's not fast, but it works. If your write load is under
30MB/sec it's d
On Tuesday, January 17, 2012 10:34:54 AM Tim Uckun wrote:
> Hey Guys.
>
> It's been a while since I looked into this and it seems like new
> options have cropped up for postgres HA and scalability. Is there a
> consensus on the "best" way to achieve HA. My primary concern is HA
> but of course a
On Thursday, January 12, 2012 02:16:04 AM debian nick wrote:
> Any help will be really appreciate.
Check your pg_hba.conf file for any entries with "trust" or "ident". Remove
them and restart the server.
Also look for .pgpass files in the home directories of any user seeing this.
--
Sent via p
On Sunday, December 18, 2011 04:00:14 PM amit sehas wrote:
> Yes i was trying to determine how to make a View work in this situation.
> From reading the details on PostgreSQL Views are not persistent, ie they
> are just a SQL query short hand rather than actually creating any physical
> entity back
On Saturday, November 26, 2011 10:18:56 AM Carlos Henrique Reimer wrote:
> Hi,
>
> We're planning to move our postgreSQL database from one CPU box to another
> box.
>
> I'm considering an alternative procedure for the move as the standard one
> (pg_dump from the old, copy dump to the new box, psq
On November 16, 2011 05:07:05 PM hyelluas wrote:
> I see 900 queries sent by 1 client in 7 min with 1 click on the screen -
> does the log show the real thing?
The logs show the real thing. Gotta love ORMs.
>
>
> Is it possible to log the number of records returned by that query?
I doubt the
1 - 100 of 403 matches
Mail list logo
