PostgreSQL Database Forum

Ok, I've got postgresql to run fine with the 'postmaster -i &', but there is one thing I don't understand. Why does this start up three instances of postmaster? Check e.g. 'ps' or processcontroller. Furthermore when I shutdown with 'pg_ctl stop' only one of these instances is removed. Anyone?

I have a postgres installation on RH8. I want to connect to this using JDBC. I've installed the driver in /usr/local/pgsql/share/java and set CLASSPATH. I think the default configure option does not enable the JDBC interface so is it possible to recompile and still maintain my original databases? Thanks, NK

Hi, I am trying to tuning up the performance of PSQL. I have tried changing the cache size. I found that the default page size if 8k, I am just wondering has any one know, if page size if biger the better or smaller the better, what is a good number of page size? My OS is red hat 8, and the OS page size is 4K. So should I change PSQL page...

Hi all, I've come across an article at http://php.weblogs.com which seems to raise concerns of PostgreSQL commercial visibility and long term potential. What does the PostgreSQL dev team has to say about this? As a PostgreSQL user myself I hope to hear some interesting insights and hopefully this post won't turn into a flame war.

I have a set of tables partitioned horizontally. DML below. I have also created a view that will allow me to display information stored in all partitioned tables. Im trying to create an INSERT RULE on the VIEW that would direct an insert into the appropriate partition table depending on the personal LastName. Can anyone help me with this?...

I've got a problem when adding a CONSTRAINT CHECK on a table by calling a function. It just seems not to work... Here is the table (simplified to only the relevant fields for this case): CREATE TABLE public.tb_contacts ( contact_id serial NOT NULL, actor_id varchar(50) NOT NULL, contacttype_id varchar(6) NOT NULL,

Hello all, I was trying to write a simple function in c and include in postgres But am not able to do so I created a function with CREATE FUNCTION "lower1"(text) RETURNS text AS '/usr/local/src/ram/mydbilib.so' LANGUAGE 'C' I looked at the src for a simple function in $POSTGRES_SRC/src/backend/utils/adt/oracle_compat.c

I have a table of points, actually zip codes and their points. If a point is an X, Y pair, how do I extract X from a point? (And how do I create or insert a new point (X, Y)?) I am given a latitude, longitude pair and I would like to determine the closest zipcode. I can do this using point_distance, but I wonder if there is a faster...

I have very large databases that are in postgresql (500Gbs) and individual tables that take up as much space as 4 GBs. I know that in mysql one can compress individual tables with isam-compression. I understand that postgresql compresses text automatically, is there anyway to compress my large database further? Thanks.

I've hit a situation where I'm getting an unexpected set of results from a cross join that I've narrowed down to a table alias. If I do (a has 4 rows, b has 1 row) select a.field1, b.* from a as maintable cross join b I get 16 rows returned. Is this expected behaviour or should an error

I apologize if this is a RTFM question, but I have not been able to find a definitive answer elsewhere. Does a "REINDEX TABLE" lock the table while it is working? Can applications write data to the table during the REINDEX? I am working on a real-time application that handles over 2 million "events" per day and runs 7-by-24. Most of...

Hi all, Excuse me if this is not the right place to ask this .., but it's the closest I could find. I am reading Ramakrishnan and Gehrke "Database Management Systems". In their errata for the second edition at http://www.cs.wisc.edu/~dbbook/openAccess/secondEdition/dbbook2ed.errata1st.html it says

Hi, I don't know if it is a bug, but when I try to run to following query on a DB with 2100 (fonds_tbl) and 6100 (fonds_name_tbl) entries I can see the memory use increasing and in the end the query is aborted due to a out of memory message. And I have about 768 MB of RAM. select * from fonds_tbl where fonds_tbl.isin !=...

Hello, I've been using ASP and Access for little web applications (mainly for managing passwords access to web pages) and I've never really planned to go further. Now, I'll start a huge project, and I need a really good planning and study about possibilities. I will create a "shopping" database, with ~50 tables from wich 20 will have...

Hello, I have a table with two columns, created with : CREATE TABLE test ( id serial primary key, name text ) ; To populate the table i use : INSERT INTO test(name) values('test1'); so the "id" is automatically set by PostgreSQL. Now the problem, i would like to retrieve the value of "id" that

Hi, how do I figure out, what internal date format is used by PostgreSQL (7.1.3)? Or how do I set it to the desired format after I've already created the table? I don't know what's standing in my db? 08.04.2003 | 04.08.2003?? April | August thanks

Hey all! I had an idea to implement a very simple (IMHO) auditing mechanism for an application I'm developing, and thought some people here could give some hints, opinions, etc about it. I was thinking about implementing update and delete triggers for all my tables that I want to be audited, and these triggers would create automatically the...

I have one process which writes a single float into 300 columns once per second. I then run 4 process, from remote computers, to query a small subset of the latest row. I have even commented out everything in the query programs, all they do is sleep, and the associated postmaster still sucks up 15% - 20% CPU. Computer is a P4 /w 1Gig...

Hello, I would like to know to what extent PostgreSQL includes support for the ACID properties of transactions (Atomicity, Consistency, Isolation, and Durability). In particular, does PostgreSQL include constructs to guarantee that a sequence of SQL statements is executed atomically (i.e., either all execute to completion or none of them...

I need to convert recordsets to XML, is there an automatic way to do this in PostgreSQL or a tool I can use? Or do I have to code this manually? Regards, BTJ -----------------------------------------------------------------------------------------------

I made a modification on DBMirror.pl, an addition in the slavedatabase.conf file, and added another replication table "specialtables". The goal was to have a way of controlling when a row of table (if the table is present in specialtables), will be mirrored to the remote slave. Lets assume, we have a bank's central IT DEPT master DB...

Hello In this version I can't convert returned value to time. timeofday() return text. I need convert to timestamp before. It is normal behavior? I expected timestamp as returned type. regards Pavel Stehule

when I try to do a dump pg_dump -v -f dump.dmp dtbtransporte i get following error: DEBUG: database system was shut down at 2003-08-08 09:40:10 BRT DEBUG: checkpoint record is at 6/7E2E3D9C

Hi all, apologies if this is a dumb question - not really sure where to look for this kind of stuff... I have a frequently called stored procedure that needs to access some "configuration" information to determine how it should behave. Currently I have the configuration information in its own table, and the sp does a lookup "select item...

I currently have PostgreSQL 7.1 installed on a server with about 700 Mb of RAM. I have many problems of speed with a database I created. For example, it took almost 12 sec to run the query "select * from table" directly from PostgreSQL, on a table with 4000 records and 60 fields ... And the whole application built on this database is very...