PostgreSQL Database Forum

I am trying to start Postgresql 8.2.13 in Windows Server 2008 machine but is not starting..Service is getting timed out.. No specific error in the Aplication log in event viwer.. It was previusly running .. But after a server restart this was happening.. Is there any way I can recover the data? The pg_log says 2014-08-21 17:13:30...

I am running a SQL Script called from a batch file to build a temp database from a flat file. It works when the flat is on the C: drive but not on a net work drive I get this error: ERROR: could not open file "\\ESSOMAFPS5\Pollbook\Data\STREET_DATA.txt" for reading: Invalid argument Here is the copy statement... I am using the \\ UNC...

I have a table with 12 million records. There are indexes on columns col_1 and col_2. I use postgresql 9.3. I need two types of queries on it. First, some queries with just one condition in where clause, such as: select count(*) from table_1 where col_1 >= 123456; **explain analyze:**

I have a Postgresql table with the following structure: id | value ----+-------- 1 | 1 2 | 2 3 | 3 4 | 4 5 | 1 6 | 2

I have a simple table with a primary id column called id. I have a need to ALTER the table and delete the primary id column. When I do the first 6 rows are reordered to the bottom of the table. I do not want them to be reordered. Any thoughts? Thanks in advance.

Hi I'm using postgreSQL 9.3 and I have the following two types of stored procedures (only the statements given): INSERT INTO table1 (col1, col2, col3, col4, col5) SELECT $1, $2, $3, $4, $5 WHERE EXISTS (SELECT id FROM table2 q WHERE q.id = $1) RETURNING table1.id; DELETE FROM table1 m WHERE m.id = ( SELECT m.id FROM table1 m

Trying to import postgresql file around 8GB using pg_restore but it's outputting an error message: pg_restore -d testdb -U postgres -C helium-20141009.sql pg_restore: input file does not appear to be a valid archive

Hi Guys, I am new to Database and Postgresql. I created an ERD diagram to store information on students, parents, teachers and schools, part of my design instead of having address for each entity I create a new entity called address and contains a composite primary key from (studentID, partentID, techerID, schoolID), streetName, suburb,...

i have followed this link http://www.postgresonline.com/journal/index.php?url=archives/165-Encrypting-data-with-pgcrypto.html&serendipity=moderate#feedback to perform two way encryption, but i am getting the following error while inserting : ERROR : Corrupt ascii-armor please help me to solve this error.

Hi, Following is my code that does some initial accounts creation in bulk for some purpose. After creating about 52 accounts it gives the following error: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already Unless I am overlooking something , I open only one database connections, making 3 SQL Statatements, 3...

Simply put, I have been storing json data in bytea's with the data encrypted. Now, I would like to take advantage of 9.3's ability to have json indexes, but presume that encryption / indexes simply won't work. If anyone knows how to do this, or can confirm that it can't be done, then please advise.

Hello, I have installed postgresql on Linux on a virtual box on my wintel machine. I am unable to get a connection from pgadmin to the DB. I have modified these two files to allow remote connections to DB, then restarted the postgresql service: postgresql.conf added line: listen_addresses = '*'

HI Guys I need a big help from you guys. I need to install postgresql cluster on Suse Linux 11 SP1. I have found links about cluster installing on CentOS but not in Suse Linux. Can you please let me know a way or a link about installing Postgresql on Suse Linux.

I just want to ask if you can upload binary files (ex. jpg, doc files) to the postgreSQL server through PHP? If so, how must this be done? Just a link on any tutorial will do. Thanks!

Hello, Did a search here, manuals and Googled, etc generally, so apologies if I did not find the answer to my issue - that is, I try and 'self help' as mush as I can... I adjusted my postgresql.conf file to set as on 'explain_pretty_print' Now in pgAdmin (1.10.0) when I right-click a database in the 'usual' way, Maintenance, any of the...

1) i'm new to postgresql. i have one package in oracle, now i need to create that package in postgresql.please give me the alternative for the packages in postgresql. 2) how to execute the procedures automatically in postgresql. like we have a package in oracle dbms_job.submit. please help me.. thanks in advance

I am struggling to write a pl/sql function that encompasses the two below queries. Right now, the function executes, but when called it isn't returning anything.... It looks like I *might* be running into some trouble with passing $1 in a set returning function (i.e ST_Dump or generate_series...). It fails like this on a Multipolygon feature: ...

How to find duplicate points(poi) in an area by creating a radius for each points and compared with another points which resides in the radius, for every points it has to be follow the same method?

I have been researching for days about the diff. between pltcl and plpgsql language in postgresql to solve my problem. I have created a trigger function in 'pltcl' language but now I am trying to convert this in 'plpgsql' language. Any idea on how to convert this piece of trigger function code to plpgsql function? Thanks CREATE OR REPLACE...

HI, I am developing a program for windows ce device using c#. The existing database is Postgresql. Is it possible to connect Postgresql to my windows ce program? If yes, how? Looking forward for your immediate response. Thank you.

CREATE OR REPLACE VIEW vwstmACC AS SELECT DISTINCT ON (stmnt.chargeservicelineid) stmnt.created, stmnt.createdby, stmnt.lastupdated, stmnt.updatedby, stmnt.accountid, stmnt.practiceid, stmnt.chargegroupid, stmnt.chargeservicelineid, stmnt.patientid, stmnt.paymentpostingid, stmnt.chargeadjustmentid, stmnt.locationid, stmnt.specialityid,...

I keep getting this error within my application duplicate key value violates unique constraint "product_supplierinfo_pkey" DETAIL: Key (id)=(409) already exists. The actual next sequence number the key constraint needs to be is 5461 not 409. It is a postgreSQL table called product_supplierinfo and it has a constraint called...

Hello, We have two postgres databases running in the same server. Now we have to write a trigger in one database to access a table in another database for live data updation in both databases. How can we perform that? Can we use contrib/dblink? If we yes how to do that? Our postgres version is 7.4.7. And the function dblink does not...

We need to fetch multiple records from a table using select POSTGRESQL SQL query and need to highlight the record(row) with red or green color based on a condition. Is the above requirement is feasible. Please help us to achieve this task.

I have Oracle query which needs to be converted into postgresql . In oracle query i have NLS_DATE_LANGUAGE='Italy' parameter set. What is the equivalent code to read the italy date values in postgresql.