I have a datasource. Hmm, well first of all, what is the proper term for postgres? its not database because there are "database' inside of...

dnoyeB

03-21-2007 05:29 AM
dnoyeB

What string should i write in the NEW SERVER field (localhost or 127.0.0.1 is not accepted and give me generic error messages).. And in PORT NUMBER...

LeoVInce

12-05-2006 10:25 AM
LeoVInce

Hi, I'm dumping my database using pg_dump -i -a --column-inserts my_database > my_database_backup Then I drop my database, and recreate it and all...

Farce Milverk

07-15-2006 02:23 PM
Farce Milverk

Hi everyone. On my PostgreSQL 8.1 server, if a client application crashes, its associated backends remain active until I shut down the server. Is...

Pegasus86

05-02-2006 05:11 AM
Pegasus86

I just upgraded a machine to Fedora Core 3 and now on startup pgsql gives me the message "An old version of the database format was found"...

Gordon Fox via DBMonster.com

04-23-2006 07:28 AM
blip2

I know nothing about databases, SQL, or PostGreSQL :-) I installed PostGreSQL and phpPgAdmin on a web server. It looks like PostGreSQL insists that...

John Oliver

04-12-2006 07:46 PM
John Oliver

Hi, Is it possible to hide table structure for other users ? I'm able to revoke insert, select privileges for others users, but they still can view...

Eric Beaudry

03-16-2006 09:16 AM
Eric Beaudry

I am normally the admin for our PostgreSQL servers, but someone else tried to kill a runaway query while I was out sick. Unfortunately, he...

Tony O'Bryan

03-02-2006 06:46 AM
Tony O'Bryan

Can anyone point me towards some docs/papers/etc of the transaction logging system of PostgreSQL? Thanks, -Jim

Jim Morrissey

02-28-2006 12:05 PM
HansH

I have added a field to one of my PostgreSQL tables in the "Timestamp" datatype, but when I add a row to that table I don't get the date and...

Si

11-12-2005 11:52 AM
Stephen Prinster

Colleagues, On postgresql-7.4, pg_restore fails to restore a database because it tries to create some views referencing other objects which is has...

Victor Sudakov

09-16-2005 12:31 AM
Victor Sudakov

Hello is anybody know how to install pg_autovacuum as a window service. i've tryed this : pg_autovacuum -I -U my_user -P my_password -H...

LPO

03-23-2005 03:42 AM
LPO

not found a bison rpm for suse at the proper revision so I ignored the warning. The rest of the install process went very easy. Hopefully not having...

Vangelis Natsios

01-16-2005 01:01 PM
Nikolay A Mirin

I searched for the latest on adding the Oracle-like feature called partioning - a nice feature for tables that grow and grow, when you still need to...

boyd

12-16-2004 02:51 PM
boyd

Be gentle as I come from an Oracle background a long time ago. I am trying to join several tables with a couple of tables having a one to many...

Roderick A. Anderson

11-24-2004 09:44 AM
Erwin Brandstetter

Once again, I am in need of some assistance. I have been handed a postgresql 7.2.1 db running on an AIX platform that is suddenly having...

Chris Hoover

11-23-2004 08:06 PM
Chris Hoover

I´m not DBA. I´m a infrastruture professional, please someone help me In my company we have a PGSQL Linux Red Hat 9 Database The relevant portions...

Flavio Borup

11-23-2004 09:02 AM
Tsirkin Evgeny

Hi! My problem is tha I hava a remote db and a local db (with the same schema). When I can connect to the remote db I want to synchronize data...

mariabreis@ono.com

11-23-2004 06:46 AM
mariabreis@ono.com

On Thu, Nov 18, 2004 at 04:23:50PM -0800, Di Croce, Tony wrote: Have you tried calling nextval() in a FOR EACH STATEMENT trigger and currval() in...

Michael Fuhr

11-22-2004 08:43 PM
Michael Fuhr

I am in need of some help. We are experiencing a lot of very weird strangeness with our Postgresql databases. It appears that we are suddenly...

Chris Hoover

11-22-2004 03:03 PM
Chris Hoover

I am in the prototyping phase of a conversion from dbase to postgresql I am trying to load data with the copy function,------- *ham-existing=#...

Fred Wohlfert

11-21-2004 02:43 AM
Michael Fuhr

This may sound like an impossible thing to ask because it may seem like an apples to oranges questions. If there were a book entitled "Using...

David Bear

11-17-2004 05:34 PM
Simon Riggs

Hello, I was using 7.3.4 and decided to upgrade to 7.3.8. I did this via RPMs for RH9. RPM installed OK, and the migration of data looks like...

ogjunk-pgjedan@yahoo.com

11-17-2004 04:20 PM
Devrim GUNDUZ

While using pg_dump and pg_restore (or attempting to restore, more precisely), the process failed because of a missing user, user '128'. I never...

Taber, Mark

11-17-2004 12:14 PM
Taber, Mark

Our Linux admin just upgraded our server to fedora Core 2 which apparently upgraded postgres to version 7.4.2-1 Now on trying to start the postgres...

Jodi Kanter

11-17-2004 11:13 AM
Devrim GUNDUZ

Hi to all I'm Jeoffrey, and I'm a newbie to postgreSQL. My problem is that when i execute the command createdb <database name> i always get a #...

Jeoffrey L. Palacio

11-17-2004 07:53 AM
Vishal Kashyap @ [SaiHertz]

Hello, I'm using PG 7.3.4 under RedHat 9.0 and I've started noticing the following type of errors: cannot open segment 1 of relation url (target...

ogjunk-pgjedan@yahoo.com

11-16-2004 10:57 AM
ogjunk-pgjedan@yahoo.com

The my2pg.pl script creates custom functions that help with the MySQL "set" column type. I can't figure out how to use the functions once I have the...

Scott Chapman

11-16-2004 10:51 AM
Scott Chapman

I have been trying to track down the source of why my 7.4.5 database won't reimport it's own dump (...

Christian Fowler

11-16-2004 10:06 AM
Christian Fowler

Hello everybody, I'm working with a monitoring tool for Grid enviroments. The thing is that, this tool (GridICE) works uses a PosgreSQL Database. I...

Francisco Jose Bernabe Pellicer

11-16-2004 06:28 AM
Francisco Jose Bernabe Pellicer

I am currently creating a database which will have less than 20 quite simple tables. Unfortunately, some of those tables will have more than 1...

matthias@cmklein.de

11-15-2004 08:21 PM
matthias@cmklein.de

Ìèêîâ Íèêîëàé wrote: No within postgres, may be you can play with iptables or something like that Regards Gaetano Mendola

Gaetano Mendola

11-14-2004 12:39 PM
Gaetano Mendola

Dan Libby <dan (AT) libby (DOT) com> writes: The past reports I've seen of such misbehavior appeared to result from strcoll() failing to cope well...

danda

11-13-2004 06:12 PM
Tom Lane

I'm trying to move data from an Oracle database into postgresql 7.4.3. I have a program that is extracting data and writing it to an sql script as a...

Paul B. Anderson

11-12-2004 11:09 AM
Joshua D. Drake

Hello everybody, I'm working with a monitoring tool for Grid enviroments. The thing is that, this tool (GridICE) works uses a PosgreSQL Database. I...

Francisco Jose Bernabe Pellicer

11-12-2004 08:14 AM
Francisco Jose Bernabe Pellicer

Hi Ivo, If I use UNICODE encoding for the DB I get some errors: For example the following query: select lower('MöBÜEL') returns ERROR: Unicode...

Andrei Bintintan

11-11-2004 02:22 AM
Andrei Bintintan

I guess this may or may not belong here, but may I ask people's opinion on requesting an improvement. I have a database with mixed case table names...

Ben Kim

11-10-2004 11:21 PM
Ben Kim

I have a database on a machine that does not know what localhost is. Yes, I have 127.0.0.1, but I can't resolve localhost to it. I don't want to...

Ivan Dimitrov

11-10-2004 07:07 PM
S. C.

I am new to Postgresql. I'm trying to load tables from SQLServer bcp export, comma delimited. I'm loading datetime datatype into timestamp. I've...

Sharon Schooley

11-10-2004 04:14 PM
Stephan Szabo

Hello. My name is Mike Cox. I am in charge of the changing of these postgresql lists. I have decided that we are going to drop most of the lists from...

Mike Cox

11-10-2004 07:56 AM
Oliver Elphick

I am migrating data from msaccess. Using msaccess own export function I was able to export to an odbc data source -- I chose the postgres odbc...

David Bear

11-10-2004 12:21 AM
David Bear

"Medora Schauer" <mschauer (AT) fairfield (DOT) com> writes: I hope you meant "7.3.8", or at least something later than original 7.3 ;-) AFAICS,...

Tom Lane

11-09-2004 10:53 AM
Tom Lane

Hello everybody, I have a computer with Scientific Linux. From a repository I downloaded the packages rh-postgresql-* with the command apt-get...

Francisco Jose Bernabe Pellicer

11-09-2004 09:10 AM
Francisco Jose Bernabe Pellicer

Carlos Lopez <chlopezl (AT) yahoo (DOT) com> writes: Do you really need UNION (as opposed to UNION ALL) in this query? The EXPLAIN shows that almost...

Tom Lane

11-09-2004 08:56 AM
Carlos Lopez

Hi , I need to implement the following the replication scenario in postgres database. Here are the details of what we are looking...

Pallav Kalva

11-09-2004 08:37 AM
Pallav Kalva

I'm getting fairly frustrated here. I'm trying to populate a table using psql copy command. The file lives in the client machine where psql is...

David Bear

11-08-2004 06:01 PM
Tom Lane

I'm getting fairly frustrated here. I'm trying to populate a table using psql copy command. The file lives in the client machine where psql is...

David Bear

11-08-2004 05:47 PM
David Bear

I've looked in the archives searching on oid and 'access' (microsoft) to see how others have handled migration from data bases in ms-access to...

David Bear

11-08-2004 05:29 PM
Michael Fuhr

Here's what I do: pg_dump testdb > test.psql dropdb testdb createdb testdb psql -f test.psql testdb But there are 2 things where it won't accept...

Michael Hipp

11-08-2004 03:37 PM
Michael Hipp

hello, I have create database and run "psql -d databasename -f filename(.out)" so according to this it restores all data but not create users, i...

Nitin Jawarkar

11-08-2004 04:07 AM
Dilipan Sebastiampillai