What version of PostgreSQL did you install and how did you install it? I
have 9.2.1 and it installed createdb into the default /usr/bin/ path, as
did 9.1 and 9.0 before it (installed via yum in my case).
On Thu, Nov 1, 2012 at 8:32 AM, Kevin Burton wrote:
> This is probably a question for the au
You're using find in your current working directory. It seems you may need
an introduction to find for Ubuntu (based on your other thread it seems
you're using PostgreSQL 9.1 on Ubuntu):
https://help.ubuntu.com/community/find
On Thu, Nov 1, 2012 at 8:41 AM, Kevin Burton wrote:
> I type ‘find cr
Merlin, thanks for the response. My comments below, but firstly, does
anyone know if autovacuum is affected by setting a statement_timeout?
There was a long thread here from 2007'ish:
http://thread.gmane.org/gmane.comp.db.postgresql.devel.general/80044/focus=93847
But it's unclear to me which w
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%
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
doesn't coincide with the lock happening. At the time of the lock we were
at 1
It was installed from pgrpms.org's repository.
On Wed, Feb 1, 2012 at 4:55 PM, Carlos Mennens wrote:
> On Wed, Feb 1, 2012 at 7:51 PM, Christopher Opena
> wrote:
> > It's CentOS 5.5, PostgreSQL version 9.0.4 (x86_64).
>
> That seems extremely bleeding edge for
It's CentOS 5.5, PostgreSQL version 9.0.4 (x86_64).
On Wed, Feb 1, 2012 at 4:44 PM, Carlos Mennens wrote:
> 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
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 (reads,
writes, console cannot be achieved unless the high CPU query procs are
k
Ah - my apologies, I realized you will need to add a function for exec
(which may also require plpgsql language added to your database).
On Tue, May 17, 2011 at 12:00 AM, Christopher Opena
wrote:
> Per 8.0 documentation, in order to ALTER a table (including rename), you
> have to be the ow
Per 8.0 documentation, in order to ALTER a table (including rename), you
have to be the owner of a table:
"You must own the table to use ALTER TABLE; except for ALTER TABLE OWNER,
which may only be executed by a superuser."
http://www.postgresql.org/docs/8.0/static/sql-altertable.html
If you want
ation.
Cheers,
-Chris.
On Mon, May 16, 2011 at 1:04 PM, Tom Lane wrote:
> Christopher Opena writes:
> > Hello all,
> > First time poster here - probably a good sign since I've been running
> > postgresql with zero issues for the last several years! At any rate,
> I&
Hello all,
First time poster here - probably a good sign since I've been running
postgresql with zero issues for the last several years! At any rate, I've
recently run into a strange issue. Client-based EOFs are nothing new to our
application; people can sometimes close a connection for a number
12 matches
Mail list logo
