Hi, I used to make synchrnoistation between data directories with Rsync cause it's faster when synchronizing offline database than making a...

Olivier Hubaut

09-21-2004 09:13 AM
Tom Lane

Hi all, I was just trying to add some users to my database....i followed the createuser help and gave the following...

Pradeepkumar, Pyatalo

09-21-2004 09:10 AM
Tom Lane

When starting the Windows psql client I get a warning that the "console codepage (437) differs from the windows codepage (1252)" and to...

Bender, Cheryl

09-21-2004 06:55 AM
Dave Page

Hello, I have a Fedora core 2 box and just installed postgresSQL 7.3.7. I added a user postgres using the instruction from an installation menu:...

Yiqun Lin

09-21-2004 02:28 AM
MPaule Torre

The link for the Beta 2 Windows version of 8.0 is not working. How do I download it? Question: is this a real windows version? Not cygwin?

Federico Alves

09-21-2004 01:25 AM
Robert Treat

Hi there, I've been looking into configuring Postgres for a small/medium sized group of users for a local computer science society. We want to give...

rjyoung@scs.carleton.ca

09-21-2004 01:20 AM
Robert Treat

Hi all, I have a reference table that holds all the status used in a system (it's a very little table just 10 or 15 rows). create table status...

Jaime Casanova

09-20-2004 06:27 PM
Stephan Szabo

Hi I have vps (virtual private server) with freebsd-4.8. I have installed postgresql manually and when I run...

Boris Tomic

09-20-2004 12:03 PM
Boris Tomic

I need a data base to install with my application, but i want that it can be accessed only by the application. Because it runs on the customer...

ctnan@adinet.com.uy

09-20-2004 10:49 AM
Bruno Wolff III

Hi, all, I am using pg_dumpall (pg_dumpall -o > backup) to backup postgresql 7.2.3 datatbase on Redhat Linux 8. It worked well, but recently,...

Chuming Chen

09-20-2004 09:40 AM
Tom Lane

On Thu, 2004-09-16 at 15:09, "Lic. Guillermo González" wrote: select * from pg_stat_activity; -- Oliver Elphick ...

Oliver Elphick

09-20-2004 03:59 AM
Oliver Elphick

I just created a table, but now cannot access it or even drop it. I can access all the other tables in the database just fine. But any...

Robb Shecter

09-19-2004 04:55 PM
Robb Shecter

Here is the copy of a reply i received via e-mail, and my answer to it: on the staging system. I ran it on the whole database and it did a lot of...

R. Willmington

09-18-2004 09:09 AM
Michael Paesold

Hello. I have a postgresql 7.4.5 running. On the server i have a few databases, all owned and administered by different users. The users sometimes...

stig erikson

09-18-2004 09:04 AM
Peter Eisentraut

Hi I have many databases in Postgresql and I want to have one user who can connect only to one database but now if he querying pg_database (select *...

msz@mikrobit.pl

09-18-2004 09:02 AM
Peter Eisentraut

Hello, Does anybody know as I do to revoke the privilege of the user owner of a certain table, because the command, for example, "REVOKE ALL ON...

Maximiliano Araujo Pedatella

09-17-2004 07:55 AM
Peter Eisentraut

Ladies and gentlemen, I am running a Postgres 7.3.2 on a Red Hat Linux release 7.3 (Valhalla) in a multiprocessor (4) environment. There is a db...

R. Willmington

09-16-2004 05:24 PM
Gaetano Mendola

Hi, Though I can interpret the meaning of pg_trigger.tgtype, I am wondering if any PG table can be used to join with pg_trigger to get the...

Lee Wu

09-16-2004 12:41 PM
Lee Wu

I want to create a user that has read only access to the tables in a schema. I was able to configure that fine, but that user can see all of the...

Mark.Miller@tavve.com

09-16-2004 11:18 AM
Chris Gamache

Hi All, Just installed PostgreSQL 7.4.5 with Cigwin and get the output copied below when running initdb. Thanks in advance for any help. Tom $...

Tom Burns

09-16-2004 07:09 AM
Tom Burns

Hello all: I'm hoping I'm wrong, but I think I'm looking at a corrupted table or database. We have a column that's sequence-driven, with a unique...

Steve Lane

09-15-2004 06:44 PM
Steve Lane

We are seeing some different sorting sequences (when using BETWEEN) amoung our various operating systems. My guess is that some paramater controls...

Naomi Walker

09-15-2004 12:29 PM
G u i d o B a r o s i o

Hello, I'm having trouble with pg_dump and pg_restore (PG 7.3.4). This is how I'm dumping my DB: # pg_dump -d mydb --clean --inserts...

ogjunk-pgjedan@yahoo.com

09-15-2004 09:22 AM
Tom Lane

Hi. I'm running postgresql on a Debian box, and plan to use it for teaching a database class. While installing some graphical tools for the students...

Terry Letsche

09-14-2004 03:46 PM
Oliver Elphick

I am trying to get FUNK radius to use postgres 7.3.4 as it's backend authentication server. Throughout FUNK's documentation it only refers to...

Jeff Stout

09-14-2004 02:58 PM
Jeff Stout

I'm trying to recover a database where some tables 'went missing'... Short story: server was rebooted without being shut down properly, upon bootup...

Wim Kerkhoff

09-14-2004 02:01 PM
Wim Kerkhoff

=?ISO-8859-1?Q?M=E1rio_Gamito?= <gamito (AT) netual (DOT) pt> writes: That was a bad move. Start over, and next time don't assume that you can...

Tom Lane

09-14-2004 09:31 AM
Tom Lane

Hi, I have a problem with my trigger... : my tables : CREATE TABLE public."T-Alumni" ( "Id_Persoon" int8 DEFAULT...

Joepie Platteau

09-14-2004 02:43 AM
Joepie Platteau

I needed to add a FK constraint to a table where one was forgotten. I found an add constraint command and used it: ALTER TABLE file_info add foreign...

Jodi Kanter

09-13-2004 10:48 AM
Lee Wu

Hey folks, I'm running 7.3.5 on an OpenBSD 3.5-STABLE machine, with 512M of RAM. I'm running VACUUM ANALYZE every hour, with a VACUUM FULL once per...

C. Bensend

09-12-2004 11:55 AM
C. Bensend

I apologize if this answer is in the archives but my search did not reveal it. I need to add an alternate db location for my 7.3.4 server (running...

Bender, Cheryl

09-11-2004 07:43 AM
Geoffrey

Hi All, I'm using PGSql 7.4.3 on win2k system. i have a small db with some tables,indexes,sequences,constraints and data. Today i took...

Praveen

09-10-2004 07:51 AM
Praveen

Hi Ý want to call a trigger function from another trigger.Like "include" function in php.is that possible?if ok, how? Thanks a lot.

osman

09-10-2004 03:45 AM
osman

We have a postgres 7.4 database which never vacuum for 4 months. I try to vacuum one time. But my manager can't bear the low performance of website....

S. C.

09-10-2004 01:41 AM
Howard Bagcat

Hello, Does pg7.4.x support resizing a varchar column ie varchar(30) -> varchar(200) If not does the feature in 8.0 relating to changing column...

Warren Little

09-08-2004 04:34 PM
Tsirkin Evgeny

On Wed, 2004-09-08 at 11:02, Mário Gamito wrote: What error are you getting on attempting startup? ---------------------------(end of...

Scott Marlowe

09-08-2004 12:39 PM
Tom Lane

Hello. I have a slightly off topic question. Is it possible to set up replication between a mysql 3.23.56 server and a postgresql 7.2.4 server...

k b

09-08-2004 09:56 AM
Christopher Browne

Hola, les comento mi inquietud, ya instale PostgreSQL 7.4.3 en Red Hat y funcionatod bien, accedo a la BD a traves de access sobres Windows desde...

Christian Hache

09-07-2004 07:21 AM
Goulet, Dick

Hello list. 2 - 3 times a day we find in the logfile the message: ERROR: RemoveFunction : function 't_r2_srl()' does not exist. As I cannot find a...

H.J. Sanders

09-07-2004 03:06 AM
Devrim GUNDUZ

Dear List, I am using postgresql 7.2.1. I would like to know whether we should vacuum the template1 and template0 database as well, in addition to...

NH Lau

09-06-2004 10:46 PM
Tom Lane

Hi all! Another problem : a web application working under apache2 and using postgresql 7.3.4 is having stack while most of the postmaster proccesses...

Tsirkin Evgeny

09-06-2004 11:47 AM
Tsirkin Evgeny

Tsirkin Evgeny wrote: BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; DELETE FROM schedule WHERE studentid = ... ; INSERT INTO schedule...

Tsirkin Evgeny

09-06-2004 09:36 AM
Jean-Luc Lachance

Hi All, Anyone good in writing Linux scripting for backup PostgreSQL. I just required a simple scripts only. Normally we do the manual ways as...

Lawrence C

09-05-2004 09:22 PM
Geoffrey

Hi all, I am searching for good working HW RAID controller. I will use linux as OS. Also I will use SCSI. I readet the docs about adaptec AHA2120S,...

pginfo

09-05-2004 06:23 AM
Tony Reina

Greetings, Are there any differences, advantages of running a dump/restore vs running the following:1)REINDEX all the tables in all the...

Adi Alurkar

09-04-2004 05:19 AM
Gaetano Mendola

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Does anyone have a pretty way view the members of a group? How about a list of groups which a user is...

Andrew Hammond

09-03-2004 03:54 PM
Bruce Momjian

Thanks to everyone who helped. Chris, as you said, reading several GB (abt 3 GB) and writing out the data was causing a huge I/O Wait and this caused...

kris pal

09-03-2004 02:17 PM
kris pal

I need some help understanding locales and what the impact upon my database/application would be. I am currently running 7.3.4 and have a database...

Chris Hoover

09-02-2004 02:56 AM
Peter Eisentraut

Hi, I'm running PostgreSQL 7.4.2, UnixODBC Driver Manager: 03.51.0002.0224 and psqlODBC 7.3.2 on a Red Hat Linux system. I need to understand...

Richard Harris

09-01-2004 06:33 PM
Richard Harris

Hello! Is there any way to see that a postmaster is running with what configuration? I want to verify if it picked up all the values...

Akshay Mathur

09-01-2004 06:01 PM
Tom Lane