| I'm using PG 9.1.9 with a client application using various versions of
the
| pgsqlODBC driver on Windows. Cursors are used heavily, as well as some
pretty
| heavy trigger queries on db writes which update several materialized
views.
|
| The server has 48GB RAM installed, PG is configured for
Am 11.04.2013 10:29, schrieb jpui:
Hi,
I'm running a server using postgres 8.3 and i was adviced to update it...
what i have to do in order to update it and don't stop the service?
8.3 is out of support so you will need to at a very minimum 8.4. This
cannot be done without restarting.
Hi Ascot,
I am new to Postgresql, I have installed the Postgresql 9.1.8 in my ubuntu
12.04 machine and I found 9.1.9 was released last week, can someone advise
me how to upgrade pg from 9.1.8 to 9.1.9?
or, are the following commands correct for this upgrade?
apt-get update
apt-get upgrade
Hi Group,
I'm using PG 9.1.9 with a client application using various versions of the
pgsqlODBC driver on Windows. Cursors are used heavily, as well as some
pretty heavy trigger queries on db writes which update several materialized
views.
The server has 48GB RAM installed, PG is configured for
Hi Andres!
On Wed, Apr 10, 2013 at 4:49 PM, Andres Freund and...@2ndquadrant.comwrote:
Could you show the output of 'bt full'?
Program terminated with signal 11, Segmentation fault.
#0 ResourceOwnerEnlargeCatCacheRefs (owner=0x0) at resowner.c:605
605 if (owner-ncatrefs
Ok, so while we have a valid resource owner up to here, portal-resonwer
is NULL.
Could you 'up' until youre in this frame and then do 'print *portal'?
#7 0x00638c78 in PortalRun (portal=0x2aa9360, count=10,
isTopLevel=1 '\001', dest=0x2a50c40, altdest=0x2a50c40,
Ok, I might be seeing whats going on here. Could you go to 'printtup'
and print *myState, *myState-attrinfo, *typpeinfo?
#4 0x004593c4 in printtup (slot=0x2d14618, self=0x2a50c40)
at printtup.c:297
297 printtup_prepare_info(myState, typeinfo, natts);
(gdb)
Hm. Make that a
print *(DR_printtup *) self
print *((DR_printtup *) self)-attrinfo
print *slot-tts_tupleDescriptor
(gdb) print *(DR_printtup *) self
$2 = {pub = {receiveSlot = 0x459390 printtup,
rStartup = 0x459550 printtup_startup,
rShutdown = 0x458a20 printtup_shutdown,
rDestroy
Joshua Berry
Hi Andrus,
2010/10/13 Andrus kobrule...@hot.ee
CHAR(20) columns in 8.4 database may contains spaces and - signs like
13-333-333
12 3-44
33 33 333
12345
User enters code to search without spaces and - signs, like 12344
How to search for product code ignoring spaces and - signs?
For
On Thu, Aug 26, 2010 at 2:51 AM, Wappler, Robert rwapp...@ophardt.comwrote:
Do you really have the requirement to sort anything? Or let me ask it
the other way round: Assuming you have too much data, to sort it on the
application side, which user can read all this from one single table in
the
ON analysis
USING btree
(job, lab);
Thanks for any insights and tips you can provide!
Kind Regards,
-Joshua Berry
On Wed, Aug 25, 2010 at 10:40 AM, Wappler, Robert rwapp...@ophardt.comwrote:
On 2010-08-25, Joshua Berry wrote:
Here's my latest culprit:
select Anl.Priority, Anl.Lab, Anl.Job, JOB.DateIn,
JOB.CompanyCode, Anl.SampleName
from analysis anl join job on anl.job = job.job
order
My vote would be to follow Craig Ringer's advice to run the pg server in a
virtual machine. I'd choose something like vmware/fusion or if you want
license free options, I think they exist that can run hosts on win32 and
BSD/MacOS.
But if you wanted to avoid dual booting altogether and
with
a helpful search query or URL.
Kind Regards,
-Joshua
Joshua Berry
On Tue, Mar 30, 2010 at 10:46 AM, Andy Colson a...@squeakycode.net wrote:
When your app/users connect to the db, do they connect as the same user, or
each with a different username?
The application instances each connect to the database with the same
username. The application currently uses
On Tue, Mar 30, 2010 at 4:46 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Tue, Mar 30, 2010 at 1:57 PM, John Gage jsmg...@numericable.fr wrote:
I just wondered if I could access the same 8.4.2 server from the Windows
partition (XP via Bootcamp) as I do from the Mac partition on my Mac?
for such conflicts?
Thus far we exclusively use plpgsql.
Regards,
-Joshua Berry
; but I could use some pointers as to which project
files that should be related to such a change.
Regards,
-Joshua Berry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Oct 27, 2009 at 1:35 PM, Pavel Stehule pavel.steh...@gmail.com wrote:
|
| 2009/10/27 Joshua Berry yob...@gmail.com:
| Greetings,
|
| It seems that in Postgresql 8.2 less casting was necessary to coax the
| backend to execute queries.
| For example:
| * Comparing a varchar
away: I don't want us to be left with a dead
database and no backup with the latest data.
So, is this expected behavior when you fail to restart after a minor
version upgrade, or is this a sign of hardware failure and we should
try dumping relations one at a time?
Regards,
-Joshua Berry
--
Sent
. The current instance postmaster has been running 32 days.
How can I assess the situation? What procedure would you recommend?
Regards,
-Joshua Berry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
to perform a database
dump. Any ideas how this can happen, and how to avoid? Should I assume
that there are more problems and recreate the database from a fresh
dump? Or will the system suffice in it's current state?
Regards,
-Joshua Berry
--
Sent via pgsql-general mailing list (pgsql-general
Our shop uses postgres for a dozen installations. The applications
have some realtime performance requirements, and are just good enough
to function properly. The problem is that the clients (owners of the
production servers) are using the same server/database for
customizations that are causing
}','{}'); --{f,f,f,f}
select m_bx('{}'::int[],'{}'); --{}::bool
Regards,
Joshua Berry
On May 18, 2009, at 10:00 PM, Nagy Zoltan wrote:
create or replace function m_bx(a integer[],b integer[])
returns boolean[]
as
$BODY$
declare res boolean[];
declare i integer
.
Any hints/tips? Is our original solution okay, or is there something
we can do to improve things?
Thanks,
Joshua Berry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Linux or MacOS X.
HTH,
-Joshua
Joshua Berry
/plpgsql-control-structures.html
but still not sure how to apply the grammar to arrays data types.
If there is a builtin array function that achieves this, that would be
good to know as well.
Cheers,
-Joshua
Joshua Berry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
there is an
example of how to convert columns to rows using UNION, but not visa
versa.
Thanks in advance!
Joshua
Joshua Berry
Software Engineer
Opentech, S.A.
+(595 21) 282557 Work
+(595) 981 330 701 Mobile
? Should the external scripts/code that puts the data into the
database be responsible for removing the old data?
Thanks in advance for any/all pointers!
-Joshua
--
Joshua Berry
Software Engineer
Opentech, S.A.
+(595 21) 282557 Work
+(595) 981 330 701 Mobile
30 matches
Mail list logo