PostgreSQL Database Forum

Can anyone help with why our pages are slow to load during peak-use hours? We run a database site getting 4 million hits a month which becomes painfully slow during peak hours. The slowness is not reflected in Coldfusion's debug output; for example the total run-time of 5 heavy queries is typically 1000 ms, but during peak times the page...

I cannot get the server to start on Mandrake 9.2. I've looked through the logs but cannot find anything to give a hint as to what the problem might be. If anyone has information of any kind I would like to hear from them. Thanks.

Hello :) I'm working on an internet application with MS.Net client program, which is supposed to communicate with database through PHP or ASP-based webservice. The database is to hold up to 20-30 mln records in less then hundred tables; most of the tables (holding up to 80% of all data) will be updated quite rarly (e.g. once a week...

I am having a semaphore issue when running initdb. The FAQ and PAG didn't help. System data: AMD64 1G RAM 80G HD VIA Chipset Linux 2.6.1-gentoo (contains special AMD64 patches). Contains IPC in kernel.

Anyone have any experience or suggestions where to look for tools, libraries etc that can take an XML template (xslt or xsdl) and create a table structure from the XML template definition? I have seen tools to do this in the microsnot world. I am runn PostgreSQL 7.x on linux. I have been doing db admin using PgAdminIII on Win 2k... ...

All the time, timestamp and datetime fields are producing some unexpected results. When I insert a row, assigning NOW() to a field of those types, it's showing up in the PST timezone. My ISP is in the EST timezone and when I look at the timezone of the server where mySQL is installed is showing up in UTC. When I query this table, is...

Hi, I could only find support for defining functions in pl/pgsql. With a function I can have only one return value. What if I need to have multiple OUT parameters (i.e multiple return values) ? Is there any support for something that is similar to an Oracle stored procedure ? I understand that I can return a REFCURSOR from a postgres...

I have a database that should be quite simple to do. I have a base object that is easily defined as create table myObject ( a integer, b integer, len integer, data bytea

Why do I keep getting this error in the function to insert data below, any help would be apprecaited: CREATE OR REPLACE FUNCTION public.add_apppointment (date, time, integer,time, boolean, text, integer, integer, varchar, integer, boolean, varchar, varchar, integer) RETURNS text AS' declare v_appt_date date ; v_end_time time;...

Hi Wondering are there internal API layers within the Postgres server ? Looking for some way to directly cursor through indexes. Chad

Yow, there's got to be an easier way to do this ... I'm trying to create a script file that will process a table whose name is constructed from an integer argument passed into the script file. E.g., $ psql -f my_script.sql -v id=24 .... DELETE FROM table_00024 WHERE ... Here's what I came up with so far:

I am getting this error when I try to run a program in my cgi-bin directory (don't know what I'm still missing to make it work): *** Authentication required! This server could not verify that you are authorized to access the URL "/~group3/cgi-bin/ack.cgi". You either supplied the wrong credentials (e.g., bad password), or your browser...

Bonjour, Is there an embedded sql precompiler for MF Cobol for Postgres or such a project ? Regards. Alain

I want to use PostgreSQL on a project that will have to run on both Linux and Windows. But using cygwin is not a viable option. Does the dbExpert version of PostgreSQL run natively under Windows? Thanks in advance! John

I'm new to postgresql and I'm having problems with the 'nextval' function (or whatever it is called in postgresql). I created a table (called ADDRESS) using 'pgadmin' which has a serial field (called addressid). When I tried the sql statement: select nextval('public."ADDRESS_addressid_seq"') everything seemed to be working fine.

I'm a PostgreSQL newbie and I had a quick question concerning a setup that I have. I current have three tables, a, b, and c. On my create table statement for table a, I have the following: create table a ( id VARCHAR(3) NOT NULL, name VARCHAR(15) NOT NULL, CONSTRAINT a_pk PRIMARY KEY (id) ) INHERITS (b);

Is there a method to encrypt data on postgresql similar to SafeJDBC?

Hi group - I'm using php to extract data from postgres and print to browser. I have data that was input through checkboxes on a form - each checkbox had a different value but got pushed into the same column. So - my values look like this: surveys=# select distinct(additionaldeliverablearray) from csssurvey; additionaldeliverablearray...

Hello I have 2 databases on PostgreSQL, for instance base1, base2. I connect to psql: psql -p 3333 base1 how can I access to base2 ? for instance I wont do instruction: insert into test(a, b) values select a, b from basa2.test

Hi I'd like to ask you when (if ever) you predict to release native support for Windows. And what PostgreSQL version will be the first supported. Thanks for answers jan

Hello, I've installed redhat enterprise 3 on a system to use as a db server. Manually I can install and run postgresql 7.3 (the one on the extras CD). The problem is when you try to add postgres as a service, it might add it, but it will not start it. To do this, we got a postgresql script, placed it in the init.d folder with all the other...

My company is researching the idea of moving from a very large, old and complex UniData DB to something else that is newer and quicker. I was thinking about PostgreSQL, but am not sure PostgreSQL could import the data, and / or what kinds of issues could arrise, not to mention if it's even possible in the first place. Your thoughs would be...

Hello, I can set user varibales in postgresql (ALTER USER user SET search-path=$owner,public,other;) and I can reset. (ALTER USER user RESET search-path) But, how can I show user variables? ALTER USER user SHOW search-path; <-- error.

Hi, I wonder how this can happen. A "not null" field is set to "" even if a sequence should set this to next sequence number. Ok, I know it is not set to null, it is set to '' which is proven by the below Select statement but it is not set to the next sequence number and the inserts

hi, i make programms with c# and i would like to know if there is an alternative to odbc(wich is not really fast) to dialog with postgre. thanks thierry