| 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 12GB
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 upgr
> 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 rest
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 ,
rStartup = 0x459550 ,
rShutdown = 0x458a20 ,
rDestroy = 0x458a10 , mydest = DestRemoteExec
> 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) p
> 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,
complet
Hi Andres!
On Wed, Apr 10, 2013 at 4:49 PM, Andres Freund wrote:
> 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 < owner->maxcatrefs)
(gdb) bt
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 12
sed? Are the caveats to dangerous to deal with that I
should not consider it? In general, the only changes I've been making are to
add columns, which would not actually modify the result sets that the
cursors are selecting anyway. Thanks for any thoughts/suggestions. I'm
running PG 8.4.
Hi Andrus,
2010/10/13 Andrus
> 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 example se
On Thu, Aug 26, 2010 at 2:51 AM, Wappler, Robert wrote:
> 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 user interface?
On Wed, Aug 25, 2010 at 10:40 AM, Wappler, Robert wrote:
> 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 j
USING btree
(companycode, job, lab);
CREATE INDEX analysis_job_lab
ON analysis
USING btree
(job, lab);
Thanks for any insights and tips you can provide!
Kind Regards,
-Joshua Berry
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
parallels/fu
On Tue, Mar 30, 2010 at 4:46 PM, Scott Marlowe wrote:
> On Tue, Mar 30, 2010 at 1:57 PM, John Gage 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?
>
> Assuming both virtual machines (or
On Tue, Mar 30, 2010 at 10:46 AM, Andy Colson 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 an ODBC connection
queries! Please feel free to reply with
a helpful search query or URL.
Kind Regards,
-Joshua
Joshua Berry
On Tue, Oct 27, 2009 at 1:35 PM, Pavel Stehule wrote:
|
| 2009/10/27 Joshua Berry :
| > Greetings,
| >
| > It seems that in Postgresql 8.2 less casting was necessary to coax the
| > backend to execute queries.
| > For example:
| > * Comparing a varchar with a numeric
| >
|
PS (e.fecha, e.fecha);
If such an operator doesn't exist yet, I'm keen to try to generate a
patch and tests; 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
enced to check for such conflicts?
Thus far we exclusively use plpgsql.
Regards,
-Joshua Berry
the view was dropped, I was able 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
led on
April 1. 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.
o see if the error goes 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?
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 pr
;); --{t,f,t,t}
select m_bx('{1,2,5,4}','{5}'); --{f,f,t,f}
select m_bx('{1,2,5,4}','{}'); --{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
8.3/interactive/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@pos
to UNIX environments like Linux or MacOS X.
HTH,
-Joshua
Joshua Berry
no result, so in the "NO" case, NULL is
returned.
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
ome
results that appear to be mssql specific. On Stackoverflow 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
g that executes once
per day?
If no, why? 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