On Thu, 27 Jan 2005 18:23:21 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> On Thu, Jan 27, 2005 at 02:57:22PM -0800, Lonni J Friedman wrote:
> > Is there any way to increase sort_mem without having to perform a full
> > restart of the DB? Will just doing a 'kill
On Thu, 27 Jan 2005 20:05:19 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> On Thu, Jan 27, 2005 at 05:52:41PM -0800, Lonni J Friedman wrote:
> > On Thu, 27 Jan 2005 18:23:21 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > > On Thu, Jan 27, 2005 at 02:57:22PM
On Sat, 29 Jan 2005 21:55:23 +0200, raptor <[EMAIL PROTECTED]> wrote:
> hi,
> how can I dump the db schema so that I can recrate the DB later ?
>From 'man pg_dump':
-s
--schema-only
Dump only the schema (data definitions), no data.
--
~
On Sun, 30 Jan 2005 11:56:04 -0500, Robert Treat
<[EMAIL PROTECTED]> wrote:
> On Friday 28 January 2005 15:42, Joshua D. Drake wrote:
> > > Does anyone have any suggestions for how to get the
> > > testcase id's and suite's replicated to the production
> > > database with out touching the other tab
How often are you running vacuumdb ?
On Mon, 31 Jan 2005 08:28:28 +0700, Frans <[EMAIL PROTECTED]> wrote:
> I'm using Fedora Core 2, apache 2.0 and postgresql 7.4.6.
> Recently, the application is slowing down. When I check the process
> using "top", sometimes postmaster process time is increasin
Greetings,
I've got a pesky J2EE based app that is using PostgreSQL-7.4.x on the
backend. Lately i've been getting a disturbing large number of
PostgreSQL out of memory exceptions on the J2EE side when running
queries that have some huge joins in them. I've tried increasing the
sort_mem value for
On Wed, 02 Feb 2005 11:17:59 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
> > I've got a pesky J2EE based app that is using PostgreSQL-7.4.x on the
> > backend. Lately i've been getting a disturbing large n
On Wed, 02 Feb 2005 12:13:59 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
> > Although, looking in the log postgresql is generating, I'm seeing the
> > following at the same time as that OOM above so it certainly
On Wed, 02 Feb 2005 12:58:49 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
> > On Wed, 02 Feb 2005 12:13:59 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> >> Hmm, looks like a hash join ran out of memory. What PG ver
On Wed, 02 Feb 2005 13:23:11 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
> > I'm afraid i'm not clear on what i'm supposed to be checking here.
> > Which conditions should I be looking at? thanks.
>
On Tue, 08 Feb 2005 18:46:00 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi,
>
> everytime I try to connect to my Database with a Java-Applikation, I
> recieve only the following Exception:
>
> org.postgresql.util.PSQLException: A connection error has occurred:
> org.postgresql.util.PSQ
gt; > > I start the Server with the -i option, so TCP/IP is activated,
> isn't
> > > it?
> > > > > I want to connect by localhost to my database.
> > > >
> > > > From the localhost can you:
> > > >
> > > > psql -h 127.0.0.1 -
On Tue, 8 Feb 2005 13:17:38 -0800 (PST), CSN
<[EMAIL PROTECTED]> wrote:
> Is this anything to worry about? Why are there so many
> Postgresql connections? 'ps axu' usually only shows
> about 5-10 postgres processes.
>
> # netstat
> tcp0 0 localhost.localdo:55547
> localhost.loca:postg
On Tue, 8 Feb 2005 13:44:48 -0800 (PST), CSN
<[EMAIL PROTECTED]> wrote:
>
> --- Lonni J Friedman <[EMAIL PROTECTED]> wrote:
>
> > On Tue, 8 Feb 2005 13:17:38 -0800 (PST), CSN
> > <[EMAIL PROTECTED]> wrote:
> > > Is this anything to worry a
On Thu, 17 Feb 2005 11:58:47 -0500, John Allgood <[EMAIL PROTECTED]> wrote:
> Hello All
>
> I am trying to build 7.4.6 src rpms and when I issue the command
> rpmbuild --rebuild postgres-7.4.6-2PGDG.src.rpm. I get the following error
>
> configure: error: Python Makefile not found.
> error: B
thing I could find was this messages
>
> configure:4681: checking how to link an embedded Python Application
> configure:4685: result: no
> configure:4687: error: Python Makefile not found
>
> Thanks
>
> John Allgood - ESC
>
> Lonni J Friedman wrote:
&
On Thu, 17 Feb 2005 15:41:11 -0500, Geoffrey <[EMAIL PROTECTED]> wrote:
> FYI, Seems there might be some confusion on the part of Red Hat.
> Checking the 4.0 channel on the Red Hat Network for the version of
> Postgresql that comes on 4.0 I see:
>
> postgresql-7.4.7-2.RHEL4.1
>
> Whereas, on the
On Fri, 18 Feb 2005 13:51:00 -0800, Wang, Mary Y <[EMAIL PROTECTED]> wrote:
>
>
> Hi All,
>
> I have been using PostgreSQL for my project repository, because it is free
> and easy to use. My manager is trying to decide if he should use a
> commercial database such as Oracle or PostgreSQL f
201 - 218 of 218 matches
Mail list logo
