Hi, I'm trying to use the psql application to execute pg_dump to backup a database named test_db. When I run psql interactively, as user...

Richard Harris

08-13-2004 10:06 PM
Bruce Momjian

Hi, I'm using PostgreSQL 7.4.2. I have a database with several user defined schemas, e.g., public, shr, sys, acc, prt. I have altered the...

Richard Harris

08-13-2004 03:24 PM
Tom Lane

Hi, I was just wondering if anyone new of a way of pulling out the attribute names of a table on the fly. I've managed to figure out how to pull...

Darren Sunley

08-13-2004 02:05 PM
Tom Lane

Hello Everyone I have installed Postgres server in a network and i am trying to use the database using Java code from other network. I have set...

Mohammad Tanvir Huda

08-13-2004 07:25 AM
Andrew Janian

Hello everybody I have a red hat ent.3 operationg system. It has been delivered with postgresql v7.3.6-1 I would like to use a new stable version :...

MPaule Torre

08-12-2004 04:17 PM
Tom Lane

Today, around 13 oclock i get a bizarre problem! (At least to me, i newbie to postgresql!) When i left, at 12:00 every thing was ok, when back, the...

Samuel Abreu de Paula

08-12-2004 01:02 PM
Samuel Abreu de Paula

Hi Tom, Just re-installed a new version of Postgres 7.3.4 on a *clean* version of Mandrake 9.2, which seemed to work well. The reference to...

LISTMAN

08-12-2004 05:49 AM
LISTMAN

Hi Folks, One of our production db's went down the other day, I have restored it from backup to another server and now I am attempting to recover as...

Drew Whittle

08-11-2004 11:43 PM
Drew Whittle

Hi, I'd like to run psql on a remote machine. For security, there won't be login access granted for ssh sessions but we'd like to test various...

Mike Bell

08-11-2004 06:28 PM
Bruno Wolff III

Hi, One of our developers has just managed to make an UPDATE on a table without any WHERE clause to restrict it. Thus a table with a few thousand...

Jona

08-11-2004 08:45 AM
Jona

Hi there, I'm a little new to postgres but I am wondering (as it doesn't seem to be in the in site documentation) how to add multiple instances to a...

Andrew J Delamare

08-11-2004 04:14 AM
Scott Marlowe

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, has anyone encountered an error when running a slony_setup.pl generated script to set up a...

Uwe C. Schroeder

08-10-2004 11:32 PM
Uwe C. Schroeder

Any help on the below would be greatly appreciated. Two identical queries on two nearly-identical setups (the slower query is happening on a slower...

kaolin fire

08-10-2004 07:31 PM
kaolin fire

Is there a way to install psql without having to install of the postgresql source? Thanks! Kris ---------------------------(end of...

Kris Kiger

08-10-2004 12:44 PM
Tomasz Myrta

There is any way to have a replication (master -> slave) whithout install anything on the slave computer. I ask this because i would like to have my...

Rodrigo Botana

08-10-2004 12:28 PM
Christopher Browne

How can I kill/stop a long running query or a complete user session using an superuser account? Thx David Ecker

David Ecker

08-10-2004 09:27 AM
Gaetano Mendola

Hi Tom, Managed to get the debugger to work and here are the results, don't understand the results mind :-) #0 0x08155d55 in proc_exit () #1 ...

Kevin Izzet

08-10-2004 06:01 AM
Jim Seymour

Hi, We are in the process of moving from PostgreSQL 7.3.3 to 7.3.6 (Red Hat). However, we are having a number of problems importing the...

Mike Bell

08-09-2004 04:31 PM
Tom Lane

Hello, Sorry if this is a too basic or is a FAQ. I've done some research but it's still unclear if this is something I should be concerned...

Bill Chandler

08-09-2004 11:45 AM
Tom Lane

Why are tablespaces not supported under Win32? --------------------------------------------- Thomas Wegner Cabrio Meter - The Weather Plugin for...

Thomas Wegner

08-08-2004 01:35 PM
Thomas Wegner

Hi, I am using linux cron and pg_dump. It is working very well. After you have dump-file you can move it to remote pc. regards, ivan Edgars wrote:

pginfo

08-06-2004 09:04 AM
pginfo

I have to connect to a postgresql postmaster running in a system in the same nerwork.I started the postmaster with -i option and I changed the...

Senthil Jegadeesan

08-05-2004 11:43 PM
mike g

Hi All, Just installed postgresql-7.4.3 for the first time and all appears to have gone fine apart from :- When I try to connect to a test database...

Kevin Izzet

08-05-2004 02:13 PM
Tom Lane

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there. We have a big problem with one of our databases. Postgres Server 7.3 When we try to backup...

Christian Platzer

08-05-2004 09:03 AM
Tom Lane

Hello, I have successfully compiled and installed PostgreSQL-7.4 in SGI IRIX 6.5.x. on both the node and kept database on shared disk. Could you...

shashi singh

08-05-2004 08:12 AM
shashi singh

I have little experience with postgres' check constraint features and was hoping to get some guidance. We have a table which houses links to various...

Jodi Kanter

08-04-2004 10:37 AM
Oliver Elphick

Hi all, In the project that I am working, we have 4-5 components. Recently we had the integration of the components. Before integrating the...

Pradeepkumar, Pyatalo

08-04-2004 03:43 AM
Gregory S. Williamson

Hi, I'm getting ready to open up port 80 of my apache/pgsql server to the world and am working on tightening up security. I have password based...

Steve Bergman

08-04-2004 12:20 AM
Tom Lane

I have a linking table that has only two fields in it and both are foreign keys to other tables. I'd like to ensure that there are never any...

Jodi Kanter

08-02-2004 02:01 PM
Peter Eisentraut

On Mon, 2004-08-02 at 07:08, Gaetano Mendola wrote: autovacuum is a daemon. You don't run it once a week, you set it loose and forget about it. ...

Scott Marlowe

08-02-2004 11:39 AM
Gaetano Mendola

Hi, I recently upgraded from 7.2.4 to 7.4.1, but can't install the contrib rpm. # rpm -ivh postgresql-contrib-7.4.1-1PGDG.i386.rpm

Anjan Dave

08-02-2004 10:39 AM
Devrim GUNDUZ

Hello All I have an account in our cluster. This is a normal linux use. Our administrator have set up postgres there. But he have n’t start up the...

Mohammad Tanvir Huda

07-31-2004 10:54 PM
Mohammad Tanvir Huda

*Hi , I am running Postgresql on windows 2000.Sometimes when I connect postgresql from my application, I get following error on the prompt ...

Saurabh Pathak

07-30-2004 12:01 PM
Uwe C. Schroeder

Hi, I've asked this question a couple of times before on this forum but no one seems to be nice enough to point me to the right direction or help me...

Steve

07-30-2004 07:59 AM
Ian FREISLICH

Colin Stagner <cbs228 (AT) earthlink (DOT) net> writes: As an unprivileged process, Postgres *cannot* crash the machine --- at least not on...

Tom Lane

07-29-2004 11:38 AM
Tom Lane

Negyesi Karoly wrote: Yes you can, you have to define a service with a IP address, so when the service postgres is relocated in the passive node...

Gaetano Mendola

07-29-2004 11:29 AM
Gaetano Mendola

Hi ! I administrate a development server for a little team, and people want to be able to grant access to an entire database to...

Ulrich Meis

07-28-2004 01:14 PM
Randall Perry

Hola a todos, Esoty necesitando migrar unas bases de Access a Postgresql, el tema es que buscando y buscando encontre una herramienta (que no se si...

Christian Hache

07-28-2004 10:25 AM
marco antonio pacheco

Hi, Yesterday I ahve posted a message indicating that I had a problem the following problem: ERROR: could not access status of transaction...

alvaro@audifarma.com.co

07-27-2004 10:58 AM
alvaro@audifarma.com.co

Hi, Sorry to bother but what means whe the following error appears ERROR: could not access status of transaction 3145728 DETAIL: could not open...

alvaro@audifarma.com.co

07-26-2004 03:39 PM
alvaro@audifarma.com.co

I need to know what the max size of a varchar field is allowed to be in 7.3.4. I have a table that someone created with a varchar(1000)...

Chris Hoover

07-26-2004 12:49 PM
Chris Hoover

Hi, I've been running postgres on my server for over a year now and the tables have become huge. I have 3 tables that have data over 10GB each and...

Steve

07-26-2004 06:59 AM
Gaetano Mendola

Hi Solaris 8, PG 7.4.2 installed from source The DB appears to be running OK I set the following in the pg_conf file to invoke statistics...

Nigel Bishop

07-26-2004 04:02 AM
Nigel Bishop

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Pavel Veretennikov wrote: I don't know what you problem can be but are you sure you need that *very...

Gaetano Mendola

07-26-2004 12:24 AM
Tom Lane

Roberto De Shong wrote: You need to show the error message if you want relevant help. -- Peter...

Peter Eisentraut

07-25-2004 06:47 PM
Gaetano Mendola

There are but it depends if you are running under Solaris, Linux etc. Most of the below can be checked with applications included with...

mike g

07-25-2004 05:08 PM
Simon Riggs

I have a question. I am getting trouble to dump my database with LO (Large Object), but exactly at restoring. Then I ask: If I just copy the data...

Eduardo S. Fontanetti

07-23-2004 10:23 PM
mike g

Hola Tengo que convertir una base de datos de MS-Access a PostgreSQL, se que exite un plug in "Database Migration Tool" de pgAdmin II. No se de...

Christian Hache

07-23-2004 11:49 AM
Eduardo S. Fontanetti

Am Freitag, 23. Juli 2004 14:50 schrieb Jouneau Luc: LIKE requires a different kind of index. ...

Peter Eisentraut

07-23-2004 11:00 AM
Peter Eisentraut

Hi there, Can someone estimate disk space nescessary for PK creation on 70 mln records table? table: create table some_table ( col_one char(10)...

Sebastian

07-23-2004 02:54 AM
Sebastian