FAQ

PostgreSQL > pgsql-general > August 2011

Search Discussions

196 discussions - 1,074 posts

  • Dear Postgres users, from last few months I am reading and searching for can postgresql used as application server? As postgresql supports many languages like pl/perl, pl/python etc, supports dblink ...
    C kC k
    Aug 13, 2011 at 3:57 pm
    Aug 28, 2011 at 5:10 pm
  • I have several Linux-x68_64 based dedicated PostgreSQL servers where I'm experiencing significant swap usage growth over time. All of them have fairly substantial amounts of RAM (not including swap), ...
    Lonni J FriedmanLonni J Friedman
    Aug 29, 2011 at 8:36 pm
    Aug 31, 2011 at 3:24 pm
  • Hello, do you know any FREE hosting platforms where PostgreSQL, Java SDK, Tomcat (or other web servers) can be already found installed or where they can be installed from scratch? In possible, it ...
    Fernando PianegianiFernando Pianegiani
    Aug 6, 2011 at 8:03 am
    Aug 8, 2011 at 7:11 am
  • Dear Friends, For client requirements, I am testing postgresql 9.0.4 on windows 7 with plpython. First I installed python 2.7 and then added python installation path to windows PATH variable. Then ...
    C kC k
    Aug 9, 2011 at 2:54 pm
    Aug 24, 2011 at 8:41 pm
  • Hi all, I have an application that is reading from a queue table, as part of my testing I stressed the table to check performance, but after the test was completed I have the a very large empty ...
    Michael GrahamMichael Graham
    Aug 3, 2011 at 10:07 am
    Aug 3, 2011 at 5:53 pm
  • Hi, we have 8.3.11 installation on client site, with table, which looks like this: $ \d objects Table "public.objects" Column | Type | Modifiers ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Aug 8, 2011 at 3:53 pm
    Aug 10, 2011 at 8:56 pm
  • hello to all i am trying to find an "acceptable" solution for a backup strategy on one of our servers (will be 8.4.8 soon, now its 8.4.7). i am familiar with both logical (dump/restore) and physical ...
    MirrorXMirrorX
    Aug 13, 2011 at 9:44 pm
    Aug 26, 2011 at 11:06 am
  • CREATE OR REPLACE FUNCTION prueba_cursor(codigo integer, curCursor refcursor) RETURNS SETOF refcursor AS $BODY$ DECLARE cur alias for $2; BEGIN PERFORM mpf.ConstruyeCursorDesdeQuery('cur' ,'SELECT * ...
    Martín MarquésMartín Marqués
    Aug 26, 2011 at 12:46 am
    Aug 29, 2011 at 7:42 pm
  • Hi Forum, We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually already done in Dev). The application is J2EE application with Hibernate. My question are 1) Is there a list of ...
    Atul GoelAtul Goel
    Aug 1, 2011 at 2:22 pm
    Aug 2, 2011 at 9:30 am
  • A table has a sequence to generate a primary key for inserted records with NULLs in that column. I have a .csv file of approximately 10k rows to copy into this table. My two questions which have not ...
    Rich ShepardRich Shepard
    Aug 11, 2011 at 11:13 pm
    Aug 12, 2011 at 10:47 pm
  • Hi all, I have a cluster database with a master and slave , the size of master database is very high reltive to slave while both have approximatly same data. On master # select ...
    Vivekkumar PandeyVivekkumar Pandey
    Aug 5, 2011 at 7:07 am
    Aug 9, 2011 at 10:24 am
  • Dear all, Today I am researching about fetching all the table names in a particular database. There is \dt command but I need to fetch it from metadata. I find some commands as below : = 'public'; 2. ...
    Adarsh SharmaAdarsh Sharma
    Aug 31, 2011 at 5:26 am
    Aug 31, 2011 at 6:12 am
  • Hi, I'm about to evaluate this SSD card: FusionIO ioDrive Duo [1]. The main reason for this experiment is to see if SSD can significantly improve query performance. So, I have the following ...
    Ondrej IvaničOndrej Ivanič
    Aug 9, 2011 at 11:17 pm
    Aug 24, 2011 at 4:22 am
  • Hi all. I have a function returning setof record. The name of a table it acts on is one of its input variables, and its output is a set of rows from that table. E.g. for simplicity, imagine it's this ...
    George MacKerronGeorge MacKerron
    Aug 12, 2011 at 4:13 pm
    Aug 13, 2011 at 6:32 pm
  • Hello ppl, any one can tell me how I can secure linux server with database postgres for example ? Im thinking to make a cryptfs file system and to deploy database over the cryptfs. The problem here ...
    CondorCondor
    Aug 22, 2011 at 8:40 am
    Aug 23, 2011 at 6:25 am
  • Hi All, I understand that copy and \copy commands in PostgreSQL work only for tables. I want it to export the data from varies tables. Instead, I can create a view for the list of tables. Can the ...
    Siva PalanisamySiva Palanisamy
    Aug 11, 2011 at 7:12 am
    Aug 11, 2011 at 1:16 pm
  • Hi list, A client is hitting an issue with JDBC: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP ...
    Sam NelsonSam Nelson
    Aug 23, 2011 at 11:06 pm
    Aug 28, 2011 at 4:25 pm
  • Hi! I try create master for replication and in his config I set synchronous_standby_names = '*' so I can connect with other slave's (name of this slave I don't know at this moment) But if I try ...
    AlexondiAlexondi
    Aug 19, 2011 at 10:06 am
    Aug 19, 2011 at 1:22 pm
  • I have a file with 5500 rows formated as 'INSERT INTO <table (column_names) VALUES <values ;' that I thought I could read using psql from the command line. However, the syntax, 'psql <database_name < ...
    Rich ShepardRich Shepard
    Aug 16, 2011 at 9:34 pm
    Aug 16, 2011 at 10:48 pm
  • Is max connections in any table in the database I can access? -- Until later, Geoffrey "I predict future happiness for America if they can prevent the government from wasting the labors of the people ...
    Geoffrey MyersGeoffrey Myers
    Aug 10, 2011 at 6:34 pm
    Aug 11, 2011 at 8:09 pm
  • We have system(Cluster) with Master replicating to 2 stand by servers. i.e M |------- S1 If master failed, we do a trigger file at S1 to take over as master. Now we need to re-point the standby S2 as ...
    SenthilnathanSenthilnathan
    Aug 2, 2011 at 5:59 am
    Aug 3, 2011 at 3:18 am
  • We recently took a copy of our production data (running on 8.4.2), scrubbed many data fields, and then loaded it onto a qa server (running 8.4.8). We're seeing some odd planner performance that I ...
    Ben ChobotBen Chobot
    Aug 30, 2011 at 10:24 pm
    Aug 31, 2011 at 10:49 pm
  • I am trying a simple access of a table and get an out of memory error. How do I avoid this issue. It seems I have some configuration set wrong. Our system has 24GB of memory and is dedicated to the ...
    DonDon
    Aug 30, 2011 at 2:28 pm
    Aug 31, 2011 at 5:10 pm
  • I need to understand why this command fails: nevada=# copy statdata to '/home/rshepard/projects/nevada/queenstake/stats/chem.csv' with delimiter '|' null as 'NA' CSV HEADER; ERROR: could not open ...
    Rich ShepardRich Shepard
    Aug 30, 2011 at 5:15 pm
    Aug 31, 2011 at 1:16 am
  • Hello all, Don't shoot me, I'm just the fella sweeping up after a departure. I'm supporting a web site with mapping features using Mapserver and PostgreSql 7.5 for windows. Recently, my mapping ...
    Mcleod, JohnMcleod, John
    Aug 24, 2011 at 6:49 pm
    Aug 24, 2011 at 8:14 pm
  • Does PG support the use of an init script or procedure? I'm looking for something that'll run unconditionally every time someone makes a DB connection. This script will create a temp table and stuff ...
    Gauthier, DaveGauthier, Dave
    Aug 24, 2011 at 2:21 pm
    Aug 24, 2011 at 3:51 pm
  • Hello. Is there any way (or hack) to dump the whole database, but to exclude the DATA from a table within this dump? (DDL of the table should not be excluded: after restoring the data the excluded ...
    Dmitry KoterovDmitry Koterov
    Aug 18, 2011 at 7:50 pm
    Aug 19, 2011 at 9:20 pm
  • Dear All, I want some views on the below requirements : 1. I have a Postgres DB server with 25 GB database. It has more than 110 tables. I am using Postgresql 8.3 on a CentOs. 2. I have another ...
    Adarsh SharmaAdarsh Sharma
    Aug 18, 2011 at 12:37 pm
    Aug 19, 2011 at 1:34 pm
  • Hi! Can I call initdb with some params as regular user (not root or postgres)? May I have some problem with replication, backup or with some other subsystem? Thank you! -- View this message in ...
    AlexondiAlexondi
    Aug 18, 2011 at 6:20 pm
    Aug 19, 2011 at 8:39 am
  • Hi all, I have made a function returning a custom record type that contains two fields. Now I want to select from that function. Actually I want to make a join with a table. Let me explain. Here is ...
    Lauri KajanLauri Kajan
    Aug 16, 2011 at 7:42 am
    Aug 18, 2011 at 6:30 am
  • Hi folks, I have a problem with identical versions of postgresql - 8.3.13 Config files are identical. HostA is a 32 bit CentOS 5.3 install and the hostB is x86_64 CentOS 6. Difference in architecture ...
    Johnny EdgeJohnny Edge
    Aug 1, 2011 at 6:25 pm
    Aug 2, 2011 at 10:45 am
  • Hi, I have a server running PostgreSQL 8.4 (Scientific Linux release 6.0). I'm running a process which receives messages from a remote server and logs them into a table. Here is the table structure: ...
    Dan ScottDan Scott
    Aug 30, 2011 at 2:23 pm
    Oct 21, 2011 at 6:35 pm
  • hi guys (and hopefully also ladies) I use postgresql as a backend for freeradius with a coova-chilli hotspot we have an installation with plenty of concurrent users with a lot of traffic, however the ...
    Peter WarasinPeter Warasin
    Aug 30, 2011 at 3:52 pm
    Aug 31, 2011 at 12:42 am
  • Hi, I'm using Pg 9.0 and inheritance to do table partitioning. A simple example would be: CREATE TABLE foo ( id INTEGER PRIMARY KEY, thing VARCHAR(32) ); CREATE INDEX foo_thing_idx ON foo(thing); ...
    Toby CorkindaleToby Corkindale
    Aug 25, 2011 at 1:18 am
    Aug 30, 2011 at 12:19 am
  • Hi, I am attempting to import a csv file into a predefined, empty table using the following commands: COPY ContactUpdates FROM '/media/Fred/Work/SQL_Server/AP/ContactUpdates.csv' WITH DELIMITERS ',' ...
    PlanasPlanas
    Aug 28, 2011 at 5:04 am
    Aug 29, 2011 at 3:44 pm
  • I was just testing a simple plperlu function to return the existence of a directory and as soon I pasted the function into psql and hit Enter, I got the following crash: CREATE OR REPLACE FUNCTION ...
    BricklenBricklen
    Aug 24, 2011 at 4:22 pm
    Aug 24, 2011 at 8:26 pm
  • Hi! Do I need setup wal archiving (archiving_mode = on) setup when I use streaming replication? -- View this message in context: ...
    AlexondiAlexondi
    Aug 23, 2011 at 9:01 am
    Aug 24, 2011 at 1:47 am
  • Hell l, I am trying to debug a query that gives an error. The error in the application server log is " ERROR: operator does not exist: timestamp without time zone = character varying Hint: No ...
    Jayadevan MJayadevan M
    Aug 19, 2011 at 11:20 am
    Aug 23, 2011 at 7:32 am
  • Hi list, as part of a db schema update, I'd like to alter the "on update" property of a fkey, for example going from : I understand I can create the new fkey and drop the old one, but this requires a ...
    Vincent de PhilyVincent de Phily
    Aug 15, 2011 at 10:37 am
    Aug 19, 2011 at 5:20 pm
  • Greetings, I've got three Linux systems (each with Fedora15-x86_64 running PostgreSQL-9.0.4). I'm attempting to get a basic streaming replication setup going with one master & two standby servers. At ...
    Lonni J FriedmanLonni J Friedman
    Aug 10, 2011 at 10:19 pm
    Aug 18, 2011 at 1:26 am
  • Hi, According to the docs, the DEFAULT keyword lets you explicitly insert a field's default value in an INSERT statement. From a db function, I'd like to force the use of default when an input ...
    Postgres UserPostgres User
    Aug 9, 2011 at 10:57 pm
    Aug 12, 2011 at 8:31 pm
  • Hello, I have query phone number in database as follows: [123) 456-7890 (123) 456-7890 When I query like this: SELECT * FROM phone WHERE phone_number ~ ('^\[123' || '[-\s\)]{0,2}' || '456' || ...
    Naoko ReevesNaoko Reeves
    Aug 11, 2011 at 10:26 pm
    Aug 12, 2011 at 12:05 am
  • I've a table (from a client, not created here) with a column that should be the primary key, but not all rows have a value for this attribute. The column format is VARCHAR(12) and has a variety of ...
    Rich ShepardRich Shepard
    Aug 11, 2011 at 6:47 pm
    Aug 11, 2011 at 8:20 pm
  • For a table where column col has an index, the query: SELECT ... FROM ... WHERE col = MD5('') doesn't seem to use an index but SELECT ... FROM ... WHERE col = 'd41d8cd98f00b204e9800998ecf8427e' does. ...
    - -- -
    Aug 8, 2011 at 1:24 am
    Aug 8, 2011 at 1:29 pm
  • Hi All, I am also a newbie here! I need to backup a database and restore it into the target machine where the database may already present or might not. If it exists, I want the "restore" command to ...
    Siva PalanisamySiva Palanisamy
    Aug 8, 2011 at 8:07 am
    Aug 8, 2011 at 12:30 pm
  • I am using a library which is emitting SQL like this SELECT COUNT(*) FROM batches LIMIT 15 OFFSET 15 the library fails because on postgres this query returns nothing (not even zero as a result). ...
    Tim UckunTim Uckun
    Aug 5, 2011 at 10:51 am
    Aug 5, 2011 at 3:17 pm
  • Problem: A client of mine, running PostgreSQL 8.3, wrote his application such that it depends on column order. (He now realizes that this was a really bad idea.) Among the things I'm doing for him is ...
    Reuven M. LernerReuven M. Lerner
    Aug 1, 2011 at 6:41 pm
    Aug 1, 2011 at 11:13 pm
  • Hi All, In my table, some of the columns are in text datatype. Few data will come down from UI layer as integers. I want to convert that to string/text before saving it into the table. Please help me ...
    Siva PalanisamySiva Palanisamy
    Aug 12, 2011 at 1:54 pm
    Mar 20, 2012 at 8:48 am
  • Hey, I am trying to upgrade a CentOS 5.4 32bit test server running postgres 8.3.4 to postgres 9.1 RC1 and am running into an error I haven't seen mentioned in the forums (at least dealing with the ...
    Justin ArnoldJustin Arnold
    Aug 30, 2011 at 5:48 pm
    Sep 1, 2011 at 11:45 pm
  • Hi, I'm trying to optimize a query where I have two tables that both have a timestamp column. I want the result where either of the timestamps is after a specified time. In a reduced form, like this: ...
    Tore HalvorsenTore Halvorsen
    Aug 31, 2011 at 2:35 pm
    Aug 31, 2011 at 3:01 pm
Aug 2011
1234
Group Navigation
period‹ prev | Aug 2011 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions196
posts1,074
users257
websitepostgresql.org
irc#postgresql

257 users for August 2011

Tom Lane: 52 posts Merlin Moncure: 49 posts Scott Marlowe: 40 posts David Johnston: 39 posts John R Pierce: 34 posts Adrian Klaver: 26 posts Chris Travers: 26 posts Craig Ringer: 26 posts Rich Shepard: 24 posts Sad: 20 posts Siva Palanisamy: 20 posts Alexondi: 19 posts Adarsh Sharma: 18 posts C k: 18 posts Lonni J Friedman: 18 posts Guillaume Lelarge: 15 posts Pavel Stehule: 15 posts Fernando Pianegiani: 12 posts Ondrej Ivanič: 12 posts Pasman Pasmański: 12 posts
show more
Archives