On Tue, Jul 19, 2011 at 2:26 PM, Tom Lane wrote:
> Ken Caruso writes:
> > I am trying to trouble shoot a couple of issue related to vacuum and db
> > size. I currently have a postgres DB that is around 390GB on disk (du -hs
> in
> > $PG_DATA/base). If I look at the total
On Tue, Jul 19, 2011 at 1:50 PM, Kevin Grittner wrote:
> Ken Caruso wrote:
>
>
> > SELECT SUM(pg_relation_size(pg_class.oid))
> > FROM pg_class ;
>
> Perhaps you want pg_total_relation_size()?
>
> -Kevin
>
The number returned when using pg_total_relation s
volumes on the MSA
but they are not actively used for anything.
Thanks
-Ken
On Sun, Jul 17, 2011 at 3:04 AM, Cédric Villemain <
[email protected]> wrote:
> 2011/7/17 Ken Caruso :
> >
> >
> > On Sat, Jul 16, 2011 at 2:30 PM, Tom Lane wrote:
> >>
> >> Ken Caruso writes:
> >> > Sorry, the actual
On Sun, Jul 17, 2011 at 3:04 AM, Cédric Villemain <
[email protected]> wrote:
> 2011/7/17 Ken Caruso :
> >
> >
> > On Sat, Jul 16, 2011 at 2:30 PM, Tom Lane wrote:
> >>
> >> Ken Caruso writes:
> >> > Sorry, the actual
On Sat, Jul 16, 2011 at 2:30 PM, Tom Lane wrote:
> Ken Caruso writes:
> > Sorry, the actual error reported by CLUSTER is:
>
> > gpup=> cluster verbose tablename;
> > INFO: clustering "dbname.tablename"
> > WARNING: could not write block 12125253 of b
On Sat, Jul 16, 2011 at 8:59 AM, Tom Lane wrote:
> Ken Caruso writes:
> > Had a DB that had bloated due to lots of updates and insuffcient auto
> vacuum
> > settings. Attempted the following in the following order:
>
> > VACUUM VERBOSE full tablename;
> > CLUS
Forgot to mention we have streaming replication partner as well that around
the same time stop recovering because a WAL segment could not be found on
the primary.
On Sat, Jul 16, 2011 at 4:05 AM, Ken Caruso wrote:
> Hello,
>
> Had a DB that had bloated due to lots of updates and in
any to recover from this. Also how do
I avoid this in the future?
-Ken
better
results.
I have been looking for some reference to indicate that the recent version
pg_lesslog is compatible with 9.0.4 but not have found anything conclusive.
So I was wondering if anyone on the list is running pg_lesslog on 9.0.X in a
production environment. Any gotchas?
Thanks
-Ken
This is a web app, so the username is unknown until the user actually logs in.
It would be ideal if pg_stat_activity contained the current role.
Until then, I'll go with your second recommendation.
Thanks for such a quick and useful reply.
Ken
On 2010-10-21, at 2:18 PM, Tom Lane wrote:
hat session, "select current_user" fails with "invalid
role OID: ".
Is there any way to determine if a given role has any active sessions?
Thanks a bunch,
Ken Lalonde
Gap Adventures, Toronto
--
Sent via pgsql-admin mailing list ([email protected])
To make chan
connection was made.
Network connectivity otherwise between the two computers is normal.
Is anyone aware of known compatibility issues? If so, can you point me
to documentation, troubleshooting tips, etc?
Thanks.
Ken Banyas
--
Sent via pgsql-admin mailing list ([email protected])
To
?
Thanks.
Ken Banyas
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ow what else to do from here.
Any suggestions? I am running 8.2.5 on 64bit Linux.
Thanks in advance,
Ken
except for data.
Any help appreciated, thanks,
Ken
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
y must
still be there somewhere if it's relpages is so big.
Thanks in advance,
Ken
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Unsubscribe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
n Sun, 18 Dec 2005, Ken Hill wrote:
>
> > I have created two database named 'testdb' and 'csalgorithm'. How do I
> > find these databases? I was expecting the databases to be subdirectories
> > under the database directory (e.g. /var/lib/postresql/7.
That works nice. It shows my data directory in
'/var/lib/postgresql/7.4/main'. When I do an ls command, I get:
$ sudo ls /var/lib/postgresql/7.4/main
basepg_clog pg_ident.conf pg_xlog postmaster.opts
root.crt
global pg_hba.conf PG_VERSION postgresql.conf postmaster.pid
I
On Sat, 2005-12-17 at 06:39 -0800, olive Mckenzie wrote:
> Hello
>
> Problem
>
> when I type psql while logged in as postgres user and
> in /usr/local/pgsql/bin
>
>
> I get message
>
>
> could not connect to server no such file or directory.
> is server running locally and accepting co
I'm using 7.4.8 so that does not work. Any other suggestions?
On Fri, 2005-12-16 at 15:50 -0800, Jeff Frost wrote:
> Run the following query:
>
> show data_directory;
>
>
> On Fri, 16 Dec 2005, Ken Hill wrote:
>
> > database, but I can find the directory
I installed postgresql using the Synaptic Package Manager on my Ubuntu
distro. I created the 'postgres' user account. I can create users and
database, but I can find the directory where the database are kept. How
do I find where the postgresql database directory is from a command
line?
--
I am new to postgres and was wondering if table partitioning
is supported in Postgres. And if so what version and where can
I find documentation on it.
- Thank You
- Ken Reid
---(end of broadcast)---
TIP 6: Have you searched our list archives
Did somebody just yell "fire" in a crowded theatre?
Ken
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian
Sent: Wednesday, October 16, 2002 12:54 PM
To: Rusty Wright
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [ADMIN]
me a note.
Thanks in advance.
--
Ken Kinder
www.kenkinder.com
ged Postgres, I installed it myself.
On Sun, Jan 28, 2001 at 08:14:12PM -0500, Tom Lane wrote:
> Ken Kinder <[EMAIL PROTECTED]> writes:
> > After a few months of running, I have a database that consistantly stops
> > taking inserts. It isn't a high-use database, doesn't
insert in psql, it
acts like it did it, you select from the data, and it's simply not there.
If I dump and rebuild the database, the problem is solved.
Any suggestions?
psql (PostgreSQL) 7.0.0
--
Ken Kinder
www.kenkinder.com
Use a large object. See the Postgres docs.
--
Ken Kinder
www.kenkinder.com
On Tue, 22 Aug 2000, [iso-8859-9] Mustafa Timur Gökçe wrote:
> Hi!
>
> I'm trying to write a program in PHP/PostgreSQL.
>
> In my program when i insert a data bigger than 8K , i have an error like
Can anyone suggest how to get a big schema diagram for a Postgres
database? We want one for the wall.
--
Ken Kinder
www.kenkinder.com
select * from foo where col > datetime 'date literal' and col < datetime
'date literal'
datetime 'value'
casts the string to a datetime variable. You can also use timespans.
--
Ken Kinder
www.kenkinder.com
On Mon, 14 Aug 2000, Erik B. Flitman wrote:
>
Data Junction, and it may connect with PostgreSQL
if you have PG ODBC running.
I'm a little partial to the Python scripting. :)
--
Ken Kinder
www.kenkinder.com
On Sat, 29 Jul 2000, kumar iyer wrote:
> My name is Sreekumar.G.Iyer and I'm working as a software engineer
>
I like pgaccess's reporter.
--
Ken Kinder
www.kenkinder.com
On Tue, 25 Jul 2000, miguel valero wrote:
>
> Any good report generator for PostgreSQL out there ?
>
> I need something that is BSD-licensed, public domain, or LGPL
One way I think of is just grepping for postgres in your ps command. I
think each connection gets its on thread. On Linux, ps will show threads.
--
Ken Kinder
www.kenkinder.com
On Wed, 12 Jul 2000, Mario Simeone wrote:
> how can I count the number of current connections to a postgres DB ?
>
I was reading in the hackers list threads regarding workarounds
to the 8k block limit.
I have a number of polygon objects that are bigger than 8k. Has a
workaround been done? The hackers thread seemed to indicate
that it would be in 6.3.2 but was delayed. Is there a fix in 6.4.x?
Regards,
Kenne
I ran configure using the 'with-x' option in
configure and got an warning:'X11 library '-lX11'
could not be found so TK support will be
disabled',where or what rpm is the -lX11 library
under redhat 5.1?
I'm not sure I even need 'with-x'. Is there a more
extensive description of all the confi
assigned, ca_date) VALUES
('$service_id',
'$org_name', '$phone_number', '$status', '$product', '$problem', '$resolution',
'$contact',
'$assigned', '$time_now')};
Thanks in advance.
Ken Wills
GFC Call Center
Email: [EMAIL PROTECTED]
Phone: 1-888-4325556
Fax: 1-608-432
37 matches
Mail list logo
