on issue with 9.0? Do you also have advice on such
(semi) silent corruption?
Thanks,
Anthony
We're still considering this architecture - so I don't have any plans.
My question is, does the ANALYZE command, which is only executed on the
master, mean that the statistics / plans that are used on the master are
ALSO used on the slaves? OR does the slave create it's own plan?
I would an
er and slaves.
Does the ANALYZE command run on each system, and work differently on each
system, or would the slave servers use the query plans from the master
machine?
Thanks!
--
Anthony
Classification: UNCLASSIFIED
Caveats: NONE
Adrian,
Correct I have the DOD Memo and this PPT. However I am trying to validate
from the Vendor that PostgreSQL 8.2 is SHA-256 compliant or not. Does that
software utilize SHA-1/SHA-256 algorithm?
V/r,
Anthony
-Original Message-
From
validate some software with you to
ensure that all our installed PostgreSQL software meets SHA-256 compliance.
There is basically two things we are looking for:
1) Identify all COTS software purchased as part of scheduled and budgeted
technology refreshes and upgrades must be SHA-256 compliant.
2
On Thu, Aug 23, 2012 at 7:39 AM, Vincent Veyron wrote:
> Lest we ridicule ourselves publicly, I suggest we leave the discussion
> at that and wish you luck in your endeavor.
If anyone has an answer to his question, I'd appreciate hearing it,
despite any faux pas that the OP has committed.
--
S
Should now plus 157785000 seconds in text be NULL, because we don't
know how many "leap seconds" will be added?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
We found the auto vacuum would always kick in during our daily data loads
in the mornings and completely bottle neck our system, and in the end had
to turn it off and schedule our own vacuum analyze over the weekend each
week using crontab. We do a couple of gigs of inserts a week into our
postgre
Out of curiosity, what happens if you dump that database without specifying
a schema - do you get all 708 tables?
On Fri, Jun 22, 2012 at 8:45 PM, Stefan Schwarzer wrote:
> Hi there,
>
> I am pg_dump-ing all tables from schema public on the server
>
> /usr/local/pgsql/bin/pg_dump -U user m
space?
Thanks for any help people can give!
Anthony Bull
Software Architect
m2Wealth International Ltd.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
About 3 hours after the Vacuum full completed, the disk space got returned
to the OS - now Windows is reporting it has all that disk back. Must have
been waiting for something? Anyway, great news!
On Mon, May 28, 2012 at 11:23 PM, Anthony Bull wrote:
> I did not run analyze, only vacuum f
tables
in the db.
Will analyze help? I was under the impression that was more for statistics
gathering and index optimising?
On Mon, May 28, 2012 at 11:16 PM, Jens Wilke wrote:
> On Montag, 28. Mai 2012, Anthony Bull wrote:
>
> Hi,
>
> >This did not
> > work either - pos
Greetings,
I am having problems reclaiming an excessive amount of disk space used by a
database, running on Windows PostgreSQL v8.3 (unfortunately we are stuck
with this version at the moment).
The database had a 16GB table, that I deleted a lot of data from. After
deleting from this table, I ra
eir Ad-Hoc tool was pretty
impressive.
I had forgotten about Tableau, and it appears they have a server component
now. That's good to hear.
--
Anthony Presley
l-downs in.
... Was hoping this wasn't going to be 30 tools to accomplish our needs.
--
Anthony Presley
2011/10/12 Ondrej Ivanič
> Hi,
>
> On 12 October 2011 14:50, Anthony Presley wrote:
> > After a few weeks of searching around, we're running into dead-ends on
> the
> > front-end, and the back-end. PG doesn't support OLAP / MDX and the
> GUI
>
s the PG route here? Are there some secrets / tips / tricks / contrib
modules for handling this?
--
Anthony Presley
Anyone?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Jan 5, 2011 at 3:43 PM, Bill Moran wrote:
> Despite the fact that the chance of a collision is very, very small, there
> is no easy way to fix it if it happens. Zero. It can't be done without
> shutting the system down, recalling all the remote devices and manually
> reconciling the prob
On Tue, 2010-07-13 at 17:38 -0400, Tom Lane wrote:
> Anthony Presley writes:
> > Every so often (usually in the early morning), we are seeing an "
> > in transaction" show up. This appears to lock / block other statements
> > from going through, though I'm
On Wed, 2010-07-14 at 20:32 +0100, Thom Brown wrote:
> On 14 July 2010 20:23, Anthony Presley wrote:
> > Hi all,
> >
> > We tend to do a lot of lookups on our database that look something like:
> >
> > select
> >e.id
> > from
> > employe
On Wed, 2010-07-14 at 15:56 -0400, Tom Lane wrote:
> Thom Brown writes:
> > On 14 July 2010 20:23, Anthony Presley wrote:
> >> select
> >>e.id
> >> from
> >> employee e ,app_user au
> >>where
> >> au.id=user_
))
-> Index Scan using app_user_pkey on app_user au (cost=0.00..5.36
rows=1 width=8) (actual time=0.032..0.033 rows=1 loops=1)
Index Cond: (au.id = e.user_id)
Filter: (au.corporation_id = 41197)
Total runtime: 192.565 ms
(8 rows)
It would appear that almost 100% of this time is taken up by
10(50304)LOG: duration: 476.522 ms
IE, the duration ends up on a different line, and basically none of the
statements ever match in your perl script.
Any guess here?
--
Anthony
On Wed, 2010-07-14 at 14:28 +0200, hubert depesz lubaczewski wrote:
> On Tue, Jul 13, 2010 at 02:53:25PM -05
manually done
this, though we are only logging statements taking longer than 5 ms, and
there doesn't appear to be any consistency.)
Thanks!
--
Anthony
--
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, Apr 27, 2010 at 5:17 AM, Cédric Villemain <
cedric.villemain.deb...@gmail.com> wrote:
> store your files in a filesystem, and keep the path to the file (plus
> metadata, acl, etc...) in database.
>
What type of filesystem is good for this? A filesystem with support for
storing tens of th
On Wed, Dec 30, 2009 at 1:43 PM, APseudoUtopia wrote:
> You're correct to infer that DELETE does not support LIMIT clauses.
> The reason for this is there is no way to tell exactly which rows will
> be deleted (unless ORDER BY is used - but there are still other issues
> with that as well).
>
> Yo
On Tue, Dec 29, 2009 at 4:09 PM, Alvaro Herrera
wrote:
> It's expecting 85k distinct groups. If that's not accurate, then
> HashAggregate would use more memory than expected.
Great diagnosis. There are actually about 76 million distinct groups.
> See if you can make it work by setting enable
On Tue, Dec 29, 2009 at 3:41 PM, Anthony wrote:
> I'm running a group by query on a table with over a billion rows and my
> memory usage is seemingly growing without bounds. Eventually the mem usage
> exceeds my physical memory and everything starts swapping.
>
I guess I didn&
Hi all,
I'm running a group by query on a table with over a billion rows and my
memory usage is seemingly growing without bounds. Eventually the mem usage
exceeds my physical memory and everything starts swapping. Here is what I
gather to be the relevant info:
My machine has 768 megs of ram.
s
I am looking for something similar to:
http://www.arcanadev.com/adtempus/ but without the MS SQL server
dependency.
Thanks,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks to all those who chimed in to help. My Linux box is a personal pc
and I have been thinking about upgrading. At that point I will also upgrade
to PostgreSQL v8.2.5.
Happy New Year to all!
Tony
> Is it advisable or ok to install v8.2.5 to a Red Hat 9 configuration? I
> tried it and there
Is it advisable or ok to install v8.2.5 to a Red Hat 9 configuration? I
tried it and there are a lot of libraries that I need get and install (e.g.
libc). I am wondering if it is worth it (or dangerous) or am I better off
upgrading my system?
Thanks
Tony
Onward & Upward!
--
I am getting an error trying to connect to PostgreSQL db using Visual
Basic.NET 2005. The error message is "FATAL: invalid command-line
arguments for server process. HINT: Try "postgres --help" for more
information."
Here is a the snippet of code to create connection. Looking for
suggestions
I am getting an error trying to connect to PostgreSQL db using Visual
Basic.NET 2005. The error message is "FATAL: invalid command-line
arguments for server process. HINT: Try "postgres --help" for more
information."
Here is a the snippet of code to create connection. Looking for
suggestions
of the
wills (i.e. the unique identifying number of each) from that city.
Is this possible and if so, how?
Thanks!
-- Anthony Masinton
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
derings tuple (with ordering = 0)
and sets up the association in the junctions table. Hence the use
of UPDATE in the insert_display_orderings rule.
--
Anthony Chavez http://anthonychavez.org/
mailto:[EMAIL PROTECTED] jabber:[EMAIL PROTECTED]
CREA
Chris Browne <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> [EMAIL PROTECTED] (Anthony) writes:
> > Our Database is having errors. We are currently using PostgreSQL to
> > store 2.5 Million records per day. The average addition to our primary
&g
r ver2
etc...
I could have one sequence for all keyword which would be 1,3, etc... I
would be prefer to have them in sequence. I'm sure someone has ran into
this before, any ideas?
Anthony.
---(end of broadcast)---
TIP 1: subscribe and unsub
Stephan Szabo wrote:
On Fri, 8 Aug 2003, Anthony Best wrote:
I've noticed that the SUM() seems to overflow under some situations.
The only difference is the order that the data is retrived from the
database.
Is amount a float type column (float4 or float8)? If so, you're pro
On Sat, 06 Feb 1999 04:00:26 KoPra Workshop wrote:
>I'm newbie, and confuse on configuration
Your system clock is not correct.
--
Anthony E. Greene <[EMAIL PROTECTED]> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 2
Hi,
When I 'CREATE USER testuser WITH PASSWORD 'mypassword';
I see an entry in PG_PWD with the password 'mypassword' in plaintext.
In my pg_hba.conf I have all hosts using 'password' authentication with no
file argument. Is there any way to keep postgres from saving the passwords
in PG_PWD? I t
]]
Sent: Thursday, March 01, 2001 11:06 AM
To: Anthony Metzidis
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG_PWD and PG_PASSWORD Security
Anthony Metzidis writes:
> Is there any way to keep postgres from saving the passwords in plain
> text?
No.
> This seems to be a huge security
e variations of "American"
addresses. Some things really are a fixed length of 2 (the number of digits
needed to specify hour of day, day of month, or month of year).
As for the state code, it wasn't political correctness, it was a valid
point.
Tony
--
Anthony E. Greene <[EMAIL PRO
on my
RH6.2 machine with PG 6.5.3 and it works fine. I made a few changes in the
Makefile:
PGSQLIBS= -L/usr/lib/pgsql -lpq
PGSQLCFLAGS = -I/usr/include/pgsql -DUSE_POSTGRESQL
PGSQLOBJS = postgres.o
I also commented out the MySQL section, since I don't have that on my
machine
e the script check for the existence of the dump file and that
it has a non-zero size. To dump my personal database, I could use this:
#!/bin/bash
dumpfile=$HOME/mydatabase.dump
pg_dump -d $LOGNAME > $dumpfile
if [ -s $dumpfile ] ; then
echo 'Dump succeeded'
else
echo 'Dump
Mark,
The error you are experiencing was discussed on the hacker's list
last week. Oliver Elphick and Tom Good worked out a patch for SQL to
solve the problem. You're right that the pg_vlock is getting created and
then getting deleted during the vacuuming of the last table. This ends
up boink
memCreate: cannot create region
>
>Does anyone have some pointers on how to fix this? Or any idea what the
>problem is? Thanks in advance,
>
>Tony
******
* Anthony Brock
r ICQ#7615664 IRC Nick:
>Scrappy
>> > Systems Administrator @ hub.org
>> > primary: [EMAIL PROTECTED] secondary:
>scrappy@{freebsd|postgresql}.org
>>
>>
>
>Marc G. Fournier ICQ#7615664
49 matches
Mail list logo
