We first noticed the issue after running the generated analyze script, in
subsequent tests it shows up before the analyze though.
Ran thru the process as a test monday night and it worked. This time however,
I deleted the complete 9.2 data directory before running our rsync scripts that
refre
after a brainstorming session here. We are going
to attempt another test this evening with all crons disabled and monitoring
disabled.
Pete Fuller, Tracking Server Systems Administrator
2055 North Brown Road, Suite 225, Lawrenceville, GA 30043
M: 678.677.5864
[email protected]
hardware and setup with
same install scripts.
> On Aug 15, 2016, at 10:55 AM, Adrian Klaver wrote:
>
> On 08/15/2016 07:40 AM, Pete Fuller wrote:
>> Directories are correct. We do not utilize tablespaces.
>
> Anything obviously different in the setup between your producti
Directories are correct. We do not utilize tablespaces.
> On Aug 15, 2016, at 10:06 AM, Adrian Klaver wrote:
>
> On 08/15/2016 06:20 AM, Pete Fuller wrote:
>> Hello all,
>>
>> We are attempting to upgrade a production 9.2 postgres cluster to 9.5. The
>>
Hello all,
We are attempting to upgrade a production 9.2 postgres cluster to 9.5. The
server is running Centos 7 with the Centos version - currently 9.2.15 We are
installing the postgresql provided rpm of postgresql9.5 from the postgresql
repo, currently 9.5.4. In testing and on our development
On 27 May 2015 at 09:57, Albe Laurenz wrote:
>
> Mitu Verma wrote:
> > Following error is continuously seen with the postgreSQL database which
we are using at customer site.
> >
> > Current Errors observed:
./fm_db_VoiceReprocessing1/data/pg_log/postgresql-04.log:2015-04-04 01:00:16
> > CESTERROR:
On 11 May 2015 at 19:01, Daniel Begin wrote:
> Interesting,
>
> The symbolic links on the old drive -still used by the DB- look like
> windows' shortcuts to parent folder, while they are empty folders in the
> copy of the database I have on the new drive...
>
> When I do a plane copy of those link
I wrote a few notes on doing this here:
http://hollobon.com/_pgblog/clear_shared_buffers.html
Thanks,
Pete.
On 13 May 2015 at 09:13, Ravi Krishna wrote:
> I am writing bench mark scripts and as part of it would like to clear the
> cache
> programmatically. This is to ensure that wh
On 14 September 2014 22:01, cowwoc wrote:
> Hi,
>
> I'd like to propose the ability to create temporary schemas.
>
> Unlike temporary tables, this feature would enable developers to create a
> temporary schema once and execute CREATE TABLE statements without the
> TEMPORARY parameter.
>
I think
On 14 September 2014 22:01, cowwoc wrote:
> Hi,
>
> I'd like to propose the ability to create temporary schemas.
>
> Unlike temporary tables, this feature would enable developers to create a
> temporary schema once and execute CREATE TABLE statements without the
> TEMPORARY parameter.
>
>
> I thi
Would a simple multi-column index be considered an 'expression' in this
context, meaning that an ANALYZE should be issued after the creation of such an
index?
---
Pete Yunker
Vice President of Data Products
Home Junction, Inc.
On Oct 18, 2013, at 11:42 AM, Tom Lane wrote:
>
All tables and rules would be the same. I assume with the -a flag, we'd
need to create the database and relations beforehand, but that shouldn't
be too much trouble.
Thanks again,
-Pete
On 4/8/13 8:46 AM, "Adrian Klaver" wrote:
>On 04/08/2013 06:41 AM, Pete Wall wr
ommands instead of using pg_dump/pg_dumpall.
Thanks, Adrian.
On 4/5/13 6:35 PM, "Adrian Klaver" wrote:
>On 04/05/2013 03:33 PM, Pete Wall wrote:
>> Is it possible to downgrade PostgreSQL by a major version?
>>
>> If I want to upgrade a PG database from 8.x to
tgreSQL by major versions?
Thank you,
-Pete
COALESCE(x.c,'junk') = COALESCE(y.c,'junk')
AND COALESCE(x.d,'junk') = COALESCE(y.d,'junk')
AND x.a <> y.a
---
Pete Yunker
Vice President of Data Products
Home Junction, Inc.
On Nov 21, 2011, at 5:23 PM, jeffrey wrote:
> Lets say that the primar
As an update, we found a 2008 box that had the same problem as below, so it
doesn't seem to be a problem with Windows 2003.
From: [email protected]
[mailto:[email protected]] On Behalf Of Pete Wall
Sent: Wednesday, August 24, 2011 2:54 PM
To: pgsql-ge
Any ideas? Has anybody else had luck or problems with the new versions on
Windows Server 2003?
Thanks,
-Pete
From: [email protected]
[mailto:[email protected]] On Behalf Of Pete Wall
Sent: Thursday, August 18, 2011 4:58 PM
To: [email protected]
mprove build support
for Windows version" here
http://archives.postgresql.org/pgsql-announce/2011-02/msg0.php. Maybe that
had something to do with it.
Thanks,
-Pete
t about it and try to think of something else. :-)
Pete
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d I hope I've managed to explain
a complicated problem clearly!
Pete
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
sorry my mistake. It is 8.4.
On Tue, Aug 10, 2010 at 10:27 PM, Thom Brown wrote:
> On 10 August 2010 15:21, Pete Kay wrote:
>> Hi,
>>
>> I am getting the following errors while trying to get plphp installed
>> on postgres 8.5:
>>
>> ERROR: could not load
Hi,
I am getting the following errors while trying to get plphp installed
on postgres 8.5:
ERROR: could not load library "/usr/local/pgsql/lib/plphp.so":
/usr/local/pgsql/lib/plphp.so: undefined symbol: sapi_globals
** Error **
ERROR: could not load library "/usr/local/pgsql/li
Hi,
I am setting up a connection pooling obj to pool a bunch of
PGConnection object. That is why I am not closing the PGConn object
when the query is done.
Is that the right way to do it?
thanks,
Pete
On Fri, Mar 26, 2010 at 10:54 AM, Tom Lane wrote:
> Pete Kay writes:
>> I am havi
Hi
I am having memory leaking problem and here is the result shown from valgrind:
==1706== 1,270 bytes in 5 blocks are still reachable in loss record 353 of 426
==1706==at 0x4C20809: malloc (vg_replace_malloc.c:149)
==1706==by 0x5D3F431: strdup (in /lib64/libc-2.5.so)
==1706==by 0x10
, and Postgresql 8.4. The database is
running pgsql 8.4 on a FreeBSD 8.0 box with approximately 16GB or
memory. I've been searching on Google and the mailing list archives
for the past couple days trying to find an answer with no success.
Any help is greatly appreciated. Thanks in a
this from inside my original function?
thanks
Pete
FYI What I have so far...
CREATE OR REPLACE FUNCTION adempiere.productAttribute
(
p_M_AttributeSetInstance_ID IN INTEGER
)
RETURNS TEXT
AS $$
DECLARE
v_Name TEXT := NULL;
v_NameAddTEXT := '';
v_Lot
Hi
I am trying to do an upgrade on an open source app called adempiere The problem
I have is that the
original scripts are for Oracle and I am trying to run it on a PostgreSQLl data
base
I am having a problem converting the 007_ProductAttribute.sql script. See below
I am getting the followin
s there an easy way to remove the privileges, either at the same time a user is dropped, or afterwards?
Pete
Hi,
Can anyone point me toward an SQL function (whether built-in or an
add-on) that will allow me to sort the contents of an array datatype in
an SQL query?
Something like this:
select sort(my_array_field) from my_table;
Thanks!
Pete
Has anyone out there succeeded in installing Postgres 7.1.3 on an
x86-based OpenBSD 2.9 install?
My setup -
x86 OpenBSD 2.9, out-of-the-box (no patches).
Unpacked the Postgres 7.1.3 tarball. Configure, make, make check all
pass. Installed cleanly. Updated /var/run/ld.so.hints to include
/u
ables, and then returns nothing. CPU
is pegged at 100%. No reporting, no information as to what's happening.
Solutions? It the DB corrupted badly? Where do I go from here?
thanks,
--pete
---(end of broadcast)---
TIP 3: if posting/
As a followup -
No, I haven't applied the patch Tom posted yesterday to 7.1.2 - I'm trying
to get one of the admins here to take care of that - but I was curious as
to whether the patch fixed the example below.
thanks,
--pete
On Wed, 13 Jun 2001, Pete Leonard wrot
* Allow ANALYZE to process a certain random precentage of
> rows
Does this reduced analysis need to be random? Why not allow the DBA
to specify what rows or blocks to do in some way.
--
Pete Forman -./\.- Disclaimer: This post is originated
WesternGeco
the comments with
sed 's/^#/--/' /home/dir/database.sql | psql -e database
or ignore them with
grep -v '^#' /home/dir/database.sql | psql -e database
--
Pete Forman -./\.- Disclaimer: This post is originated
WesternGeco -./\.-
=> select sum(P.price), P.product_id, S.sid, S.product_id from products P,
shoppers S
-> where S.sid='0319199910043810.3.0.12'
-> group by P.product_id, S.sid;
ERROR: parser: illegal use of aggregates or non-group column in target list
no luck
i wont let me combine sum(P.price) with the other
35 matches
Mail list logo
