Hi.
I'm having some serious trouble with Postgres on Debian Linux (3.0 aka
Woody), and hope somebody can help.
The PostgreSQL DB Server I'm running is the default that comes with
Debian Linux 3.0. From the Information the APT packaging tool can
provide the version number is something between 7.
I had a similar problem after upgrade to 7.4.2,
Try:
SET enable_hashagg = false;
Before you execute that SELECT stmt
If you don't want disable it in postgresql.conf
Jie Liang
-Original Message-
From: Adi Alurkar [mailto:[EMAIL PROTECTED]
Sent: Monday, June 07, 2004 5:01 PM
To: [EMAIL P
Greetings,
During testing of our application we ran into a very odd error:
very randomly during the test the postgresql log file showed a "ERROR:
53200: out of memory"
we changed the logging configuration to log statements causing errors
and found the error to be caused by a SELECT,
here is t
On Tue, 24 Feb 2004, Rajesh Kumar Mallah wrote:
>
> Greetings,
>
> The function txt2txtidx of tsearch1 crashes the backend
> in my installation when it is called with a text where '-' is
> immediately followed by a number.
example, please. Cut'n paste from psql console would be fine.
Also, what'
Jeff,
you need to look under "\?" (psql commands), not "\h" (SQL commands).
Anyway, what you need is:
\c[onnect] [DBNAME|- [USER]]
connect to new database (currently "[...]")
Jeff Stout wrote:
I am fairly new to postgres, I need to know how to switch
databases once I'm in a psql se
http://www.fabforce.net/downloads.php
Jaime Casanova wrote:
Hello,
Db-designer is a nice tool, can work with importing Oracle databases,
and use it with PG and >MySQL.
Hope this helps
BR,
Miguel
Can someone suggest an E-R tool that will read a _PG_ database and
create an E-R diagram - crows feet
Renney,
We've recently begun using Mogwai:
http://mogwai.sourceforge.net/erdesigner/erdesigner.html
It's a lot like ERwin, but is open source and written in Java, so
it runs almost anywhere. We run it under Windows and Linux. I
assume that it will reverse engineer any foreign key constraints
"Jeff Stout" <[EMAIL PROTECTED]> wrote:
>
> I am fairly new to postgres, I need to know how to switch
> databases once I'm in a psql session. I can't seem to find the
> command for \h , maybe I just blind |-;
"\?" is your friend...
$ psql
Password:
Welcome to psql 7.4.2, the PostgreSQL interact
Hello,
Db-designer is a nice tool, can work with importing Oracle databases, and
use it with PG and >MySQL.
Hope this helps
BR,
Miguel
Can someone suggest an E-R tool that will read a _PG_ database and create
an E-R diagram - crows feet and all? Are there any that are available for
free?
Thank
On Mon, 2004-06-07 at 15:18, Jeff Stout wrote:
> I am fairly new to postgres, I need to know how to switch
> databases once I'm in a psql session. I can't seem to find the
> command for \h , maybe I just blind |-;
\c database
---(end of broadcast)-
I am fairly new to postgres, I need to know how to switch
databases once I'm in a psql session. I can't seem to find the
command for \h , maybe I just blind |-;
Thank you in advance
Jeff Stout
---(end of broadcast)---
TIP 9: the planner will igno
I'd like to know if it's possible to force connection timeout on idle
connections. I have Apache connecting to the PostgreSQL through DBI
connection, and sometimes the connections are used up and I can't get a
new connection. We reasonably made sure we close the connections on each
page, but someh
probably the scripts kicks in too early because the
"StartupParameters.plist" file is not correct
here's mine
---
{
Description = "PostGreSQL RDBMS";
Provides = ("PostGreSQL");
Requires = ("Network", "Resolver");
Uses = ("Network Time", "NFS");
on 6/7/04 12:57 PM, Jeff Self at [EMAIL PROTECTED] wrote:
> On Mon, 2004-06-07 at 10:28, Randall Perry wrote:
>> On searching the archives I noticed Bob Smith in Jul, 2002 had a similar
>> problem to mine, but never posted a solution.
>>
>> I'm using pgsql 7.4.2 on Mac OS 10.3.4. I installed the
Hello
I have installed postgres 7.4.2. During normal working of my serwer
number of postmaster processes are from 1 to 60. When I have set on
log_statement_stats=true then numer of processes quickly growing up to
limit allowed connection and serwer dont response. Guys do you know what
is going
Try "pg_dumpall -g".
See http://www.postgresql.org/docs/7.4/interactive/app-pg-dumpall.html
Good luck.
Marc Mitchell - Transportation Practice Director
Enterprise Information Solutions
Downers Grove, IL 60515
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL P
On Mon, 2004-06-07 at 10:28, Randall Perry wrote:
> On searching the archives I noticed Bob Smith in Jul, 2002 had a similar
> problem to mine, but never posted a solution.
>
> I'm using pgsql 7.4.2 on Mac OS 10.3.4. I installed the startup script for
> darwin from the contrib/start-scripts folder
I am having a bit of a problem with getting my users to a new server.
Does anyone know a quck way to export the user list from one server to
import into a new server?
Thanks,
Chris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands
On searching the archives I noticed Bob Smith in Jul, 2002 had a similar
problem to mine, but never posted a solution.
I'm using pgsql 7.4.2 on Mac OS 10.3.4. I installed the startup script for
darwin from the contrib/start-scripts folder. On boot, pgsql startup fails
and I see this error in the p
"lise chhay" <[EMAIL PROTECTED]> writes:
> For tcl, I've run ./configure --enable-shared to have a tcl like a shared library
> and for tk, I've run ./configure
> --enable-shared --with-tcl to have a tk like a shared library. The installation of
> tcl and of tk work fine.
> For postgreSQL,
Where can I find PostgreSQL for Solaris SPARC and x86 platforms?
--
Christopher Smiga
System Engineer (Sun SCSA)
N2 Broadband Network Operations
Phone: 678-812-6353 (Desk)
Phone: 888-671-1268 (NOC)
Fax:678-812-6453
e-Mail: [EMAIL PROTECTED]
-
N2 Broadband, Inc. (www.n2bb.com)
4500 River G
For tcl, I've run ./configure --enable-shared to have a tcl like a shared library and
for tk, I've run ./configure
--enable-shared --with-tcl to have a tk like a shared library. The installation of
tcl and of tk work fine.
For postgreSQL, I've run ./configure --with-tclconfig --with-
On Mon, 23 Feb 2004 [EMAIL PROTECTED] wrote:
> Hi,
>
> We are running Postgresql 7.3.4. Does anyone know how to make pg_dump
> write
>
> dumps larger than 2 GB?? Compilation with D_FILE_OFFSET_BITS=64 gave
> no results...
Hi, what OS and such are you running on? I've had no problems on RH7.
For tcl, I've run ./configure --enable-shared to have a tcl like a shared library and
for tk, I've run ./configure
--enable-shared --with-tcl to have a tk like a shared library. The installation of tcl
and of tk work fine.
For postgreSQL, I've run ./configure --with-tclconfig --with-tkconfig
Hi,
you should give access to postgresql jdbc driver
(http://jdbc.postgresql.org) from your applet
and afterwards look at http://doc.postgresintl.com/jdbc/index.html to find
what you need.
-
Luc Jouneau
Unité Centrale Informatique de Jouy, INRA Domaine de Vilvert
78352 Jouy en
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 23 Feb 2004, Kris Chapman wrote:
>I want to install 7.4.1 using an rpm, but I can't seem to find a
> binary for RH9.
Try installing the rpms built for RHEL3, under /binary/v7.4.1/redhat/rhel3.
They'll work on RH 9.
Regards,
- --
26 matches
Mail list logo
