Search Discussions
-
I need to build a query for the sample data below: ----------------------------------------------------------------------- -------- fte_clave fte_padre fte_porc fte_porc_aux total ...
JORGE MALDONADO
Aug 31, 2013 at 5:38 pm
Aug 31, 2013 at 5:38 pm -
PostgreSQL 9.2 Hello, We are a new PostgreSQL site. I want to send emails from within a PL/pgSQL function. Email addresses, subject lines, etc., would be retrieved from fields in a record that had ...
Jack Kaufman
Aug 28, 2013 at 4:39 pm
Aug 29, 2013 at 2:24 pm -
Hello Postgres Novice Helpers, I don't know if this is the correct place for this question, but please redirect as appropriate. I am trying to create a datastore for a mathematical optimization model ...
Kevin Hunter Kesling
Aug 27, 2013 at 6:41 pm
Aug 28, 2013 at 6:09 pm -
Hi, Does anyone know if there are any CTAGS extensions or variants that support PL/pgSQL ? I use exuberant-ctags which does not support it, and a web search does not return anything promising ...
Charles Sheridan
Aug 27, 2013 at 2:08 pm
Aug 27, 2013 at 2:17 pm -
Hi there, I was wondering if anyone had any ideas on how to make this UPDATE query any quicker please? UPDATE stage_cleaned SET route_geom = (SELECT route_geom.wkb_geometry FROM route_geom WHERE ...
James David Smith
Aug 27, 2013 at 10:26 am
Aug 27, 2013 at 1:25 pm -
Hello, Newbie to pgsql here. I would like to ADD COLUMN "Scan resolution" bigint[] This works. However, how can I add a constraint that will check each member of the bigint array for being positive ? ...
SpinDFazor
Aug 26, 2013 at 2:22 pm
Aug 26, 2013 at 6:02 pm -
9.2 on Red Hat 6 I would like users other than postgres to be able to 'see' the postgres owned files and directories that are under ....../psql/data However definitely a Linux group and giving group ...
Birchall, Austen
Aug 23, 2013 at 10:04 am
Aug 23, 2013 at 2:40 pm -
I'm trying to convert this method using bitmaps in redis for real time metrics to postgresql: http://blog.getspool.com/2011/11/29/fast-easy-realtime-metrics-using-redis-bitmaps/ I'll use a bit ...
Pablo platt
Aug 22, 2013 at 4:26 pm
Aug 22, 2013 at 4:26 pm -
I performed my first VACUUM today on my database. I'm trying to learn PostgreSQL and learn about basic DBA tasks that need to be performed regularly so I can eventually automate this with Cron in ...
Carlosinfl .
Aug 21, 2013 at 7:22 pm
Aug 22, 2013 at 3:28 am -
Dear all, I am trying to dump a large (appx 200Gb) database and exclude certain tables from it. The command I am using is the following (with IP/Port and DBname masked for obvious reasons:) pg_dump ...
Athanasios Kostopoulos
Aug 20, 2013 at 8:04 am
Aug 20, 2013 at 7:31 pm -
Dear list, I am trying to understand the format of pg_dump -l 's output specifically let's examine the following line 16118; 1262 5499023 DATABASE - vourtsis postgres I understand that 16118 is an ...
Athanasios Kostopoulos
Aug 16, 2013 at 9:02 am
Aug 18, 2013 at 7:18 pm -
Hi Folks, My first time using postgres and I'm struggling setting the postgres user's password. Am using 9.2 btw, I'm running the following commands to initialise postgres, create a superuser with a ...
Edd Grant
Aug 14, 2013 at 12:04 pm
Aug 14, 2013 at 7:17 pm -
Hello... and thank you for your help! I can't be the only one to whom this has happened. I just set up a new postgreSQL server on a Mac that is running OS 10.6.8. I was using an image that I ...
Carol Walter
Aug 12, 2013 at 9:50 pm
Aug 12, 2013 at 10:19 pm -
Hello, Is there a way I can get the number of queries per second on a PostgreSQL database? I'm talking about the average number since the server, or the statistics collector, was started. I have to ...
Daniel Gomez Blanco
Aug 12, 2013 at 10:04 am
Aug 12, 2013 at 10:09 am -
Hi Extreme novice here. Pls be gentle. I have a database with four tables orders (have a foreign key to depots.de_id) depots (have a foreign key to customers.co_id) companies addresses depots have an ...
Michael Rowan
Aug 10, 2013 at 3:12 am
Aug 10, 2013 at 2:23 pm -
I have a monitor user that does a SSH from a remote location onto a database's host then runs commands of the form: /usr/bin/psql -c "SELECT COUNT(*) FROM pg_stat_activity; ;" -U monitor -d db1 -q -A ...
Birchall, Austen
Aug 5, 2013 at 1:45 pm
Aug 19, 2013 at 8:46 am -
Hi, Bit of an abstract question I appreciate, however I just thought I'd see what people thought. I have an anonymosied dataset of travel behaviour of some people in a major city (I'd rather not go ...
James David Smith
Aug 5, 2013 at 11:38 am
Aug 5, 2013 at 1:33 pm -
Anyone know how to get around this one: psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket ...
Kinnard Hockenhull
Aug 5, 2013 at 7:55 am
Aug 5, 2013 at 9:07 am -
Hello, I want to connect to my database using a md5 hash instead of the plain password, so i changed the authentication method in the pg_hba.conf to md5 instead of password. example: i want to use ...
Philip Poloczek
Jul 31, 2013 at 7:17 am
Aug 4, 2013 at 5:41 am -
I have an INSERT AFTER trigger that runs on inserts into a specific table. I'm not sure if the function automatically gets all the information that was inserted into the table or whether you have to ...
Some Developer
Jul 27, 2013 at 12:55 pm
Jul 29, 2013 at 8:48 am -
Hello I have a database in Postgres 9 with 75 tables, all have the exact same definition except for the name of the table. Each one contains data for people who are doctors (table name = doctors), ...
Francisco Leovey
Jul 26, 2013 at 6:21 pm
Jul 29, 2013 at 11:44 am -
Hi all, Some help if you can please. I have GPS data for a number of people. Each person turned the GPS on, at home, at a different time of the day. Before that time, I presume that the person was in ...
James David Smith
Jul 26, 2013 at 9:24 am
Jul 29, 2013 at 10:42 am -
Hi there, I have a query as below which works great and does exactly what I want it too. It has this form: SELECT my_function( field_one, field_two, field_three, field_four ) FROM my_table WHERE ...
James David Smith
Jul 24, 2013 at 11:45 am
Jul 24, 2013 at 1:44 pm -
Hi again Just wondering how does pg_hba.conf deal with incoming connections from non-static/dynamic IP addresses? Thanks Austen Austen Birchall Senior Database Administrator Met Office
Birchall, Austen
Jul 24, 2013 at 9:40 am
Jul 24, 2013 at 9:54 am -
Good day all, I have a small java app that has been running against and oracle backend for some time. Recently we have decided to move the postgres as our database of choice. Right now we are porting ...
Wayne Oliver
Jul 22, 2013 at 8:50 am
Jul 23, 2013 at 6:06 am -
Hi, Could you please let me know what does the error "system identifiers are same" mean? Below is the snapshot from one of the masters. I am setting up BDR as per the wiki ...
Indrajit Roychoudhury
Jul 18, 2013 at 8:02 pm
Jul 19, 2013 at 3:40 am -
Hello, I'd like to create a user that is almost a superuser, but without some privileges. I cannot create a superuser and then revoke privileges from them, because by definition nothing can be ...
Daniel Gomez Blanco
Jul 18, 2013 at 12:52 pm
Aug 9, 2013 at 4:58 pm -
Hello, Data input includes carriage returns. When I extract query results in delimited format these have been replaced by '\n' Currently I run a perl script to replace the '\n' by a cr as needed by ...
Anne Wainwright
Jul 11, 2013 at 6:36 pm
Jul 12, 2013 at 7:00 am -
Hello, Following the PostgreSQL 9.2 official documentation, I have set up continuous archiving on my postgres.conf file: wal_level = archive archive_mode = on archive_command = 'test ! -f ...
Daniel Gomez Blanco
Jul 9, 2013 at 3:51 pm
Jul 18, 2013 at 8:01 am -
Hi! I'm quite unfamiliar with the capabilities of hstore, so bear with me. My use case is recording a large-ish amount of timestamped, single-value events which are continuously pushed to the server ...
Johannes Staffans
Jul 9, 2013 at 9:22 am
Jul 10, 2013 at 3:49 pm -
Hi Is it possible to start a PostgreSQL cluster in 'restrict' mode so that only the postgres user can connect to a database i.e. as a means of keeping 'normal' user out when data updates etc. are ...
Birchall, Austen
Jul 3, 2013 at 3:37 pm
Jul 4, 2013 at 8:18 am -
Hello, I am trying to copy a table from a file: COPY table FROM 'file/path/filename.csv' DELIMITER ';' CSV; But I got this error: ERROR: value too long for type character varying(8) SQL state: 22001 ...
Brauner Oliveira
Jul 3, 2013 at 1:07 pm
Jul 3, 2013 at 2:05 pm -
Good Day All! I setup my postgres servers to allow certificate authentication. Right now I have two database servers and one application server. Users are only allowed to connect into the application ...
Megan
Jun 27, 2013 at 12:51 pm
Jun 27, 2013 at 12:51 pm -
Hello! Nice strangers. I'll keep to the basics, both (re)questing (?) (pardon my english) and answering. PostgreSQL won't select a specific row and it won't change an old value to a new one. Not for ...
Jonas Schwanbom
Jun 26, 2013 at 11:00 am
Jun 27, 2013 at 4:22 pm -
There are many ways to recover iPhone Contacts, you can choose an easy one like this: How to Restore iPhone Contacts <http://www.howto-backup-iphone.com/knowledge/how-to-restore-iphone-contacts.html ...
Walerina
Jun 25, 2013 at 7:44 am
Jun 25, 2013 at 7:44 am -
Hi, Recently started on Ubuntu. I have installed postgresql on CentOS with no issues, but I dont know where I am going wrong with this one. I installed postgresql first through the software center ...
Pmu
Jun 23, 2013 at 8:17 am
Jun 24, 2013 at 9:19 am -
Can someone please help me set the 'postgres' users home ENV so that I can simply type 'psql' rather than the rull path and bash doesn't say '-bash-4.1$'? -bash-4.1$ whoami;ls -l;pwd postgres total ...
Carlosinfl .
Jun 20, 2013 at 9:13 pm
Jul 17, 2013 at 10:54 am -
Team, Am using Postgres 9.2 I am having a table technologies ( technologyid bigint, status character(1), implementeddate date *CONSTRAINT technologies_uq UNIQUE (technologyid, status, ...
Technical Doubts
Jun 20, 2013 at 5:57 am
Jun 21, 2013 at 6:45 am -
Hi list, is any aware of any comprehensive tutorials for setting up 2 postgres 9.1 databases in master-master configuration? What "add-ons" are required (for example is Bucardo still a necessity?). I ...
Athanasios Kostopoulos
Jun 14, 2013 at 8:08 am
Jul 19, 2013 at 4:01 am -
I'm trying to decide if this task is best performed using triggers or some other method in the application itself. Basically I have two tables. When I insert (or update) data in one table I want to ...
Some Developer
Jun 12, 2013 at 4:15 pm
Jun 12, 2013 at 4:15 pm -
Hi , I am running PostgreSQL 8.3.6 on Red Hat Linux 5.5 and am getting empty log files in the pg_log directory. I am running the server with the following configuration : log_destination = ...
Aditya Rastogi
Jun 8, 2013 at 5:24 am
Jun 8, 2013 at 2:45 pm -
Hi, i'm in need of an advice and here is my situation. I've started putting stuff on paper, drawing my application and everything seems simple enough. My application will store large amount of string ...
Toni Alfirević
Jun 6, 2013 at 9:29 am
Jun 11, 2013 at 7:48 pm -
Dear all, I'm trying to find a way to get the last sql error which happened on a database. Found that the last command could be retrieved with "select current_query(); ". Is there a simple way to get ...
Erik Ande
Jun 5, 2013 at 3:24 pm
Jun 11, 2013 at 2:05 pm -
Hi! I have a question, which I'm certain may be a bug, but I thought I'd check with the community first before submitting it as one. I have the following SQL pseudo code which obtains an exclusive ...
Christian Lawrence
Jun 3, 2013 at 11:35 pm
Jun 4, 2013 at 2:57 am -
Hi, I've installed PostgreSQL 9.2 (client and server) on a local Windows desktop and can run pgAdmin to see the postgres database. However, now I'm trying to install a sample database to have a play ...
Frank Moore
May 30, 2013 at 8:40 pm
May 31, 2013 at 7:59 pm -
Hi, I´m using the copy command to generate a csv file, but the generation its extremely slow in a production server. In our test's server this copy takes 20 minutes but in a production server this ...
Jalisson Mello
May 30, 2013 at 5:48 pm
May 31, 2013 at 8:40 pm -
1
espejo
Un cordial saludo a la comunidad de Postresql. En la empresa donde laboro me he conseguido con una aplicación que esta trabajando originalmente en un servidor con Debian 4.0, Postgres 8.1, y la Base ...Jose Manuel Piña T.
May 28, 2013 at 11:38 pm
Jul 19, 2013 at 3:59 am -
Hello. I have a web surveying system backed by PostgreSQL. A common use case is for internal staff to make a series of changes to some survey templates (questions, question order, calculations based ...
Michael Swierczek
May 20, 2013 at 6:18 pm
May 20, 2013 at 8:52 pm -
Sorry, once again. Hello, everyone My software environment is the following: ---------------------------------------------------------------------------- ...
Changhh
May 20, 2013 at 4:05 am
May 20, 2013 at 4:05 am
Group Overview
group | pgsql-novice |
categories | postgresql |
discussions | 8,816 |
posts | 28,265 |
users | 4,603 |
website | postgresql.org |
irc | #postgresql |
Top users
Archives
- August 2013 (95)
- July 2013 (81)
- June 2013 (29)
- May 2013 (56)
- April 2013 (42)
- March 2013 (42)
- February 2013 (104)
- January 2013 (41)
- December 2012 (12)
- November 2012 (61)
- October 2012 (70)
- September 2012 (61)
- August 2012 (94)
- July 2012 (112)
- June 2012 (103)
- May 2012 (127)
- April 2012 (92)
- March 2012 (155)
- February 2012 (120)
- January 2012 (104)
- December 2011 (149)
- November 2011 (125)
- October 2011 (88)
- September 2011 (77)
- August 2011 (86)
- July 2011 (92)
- June 2011 (165)
- May 2011 (125)
- April 2011 (121)
- March 2011 (160)
- February 2011 (116)
- January 2011 (147)
- December 2010 (126)
- November 2010 (195)
- October 2010 (173)
- September 2010 (197)
- August 2010 (160)
- July 2010 (159)
- June 2010 (226)
- May 2010 (158)
- April 2010 (131)
- March 2010 (161)
- February 2010 (204)
- January 2010 (107)
- December 2009 (50)
- November 2009 (193)
- October 2009 (93)
- September 2009 (127)
- August 2009 (244)
- July 2009 (160)
- June 2009 (108)
- May 2009 (135)
- April 2009 (129)
- March 2009 (71)
- February 2009 (56)
- January 2009 (136)
- December 2008 (66)
- November 2008 (104)
- October 2008 (102)
- September 2008 (90)
- August 2008 (78)
- July 2008 (83)
- June 2008 (66)
- May 2008 (82)
- April 2008 (126)
- March 2008 (94)
- February 2008 (140)
- January 2008 (158)
- December 2007 (72)
- November 2007 (128)
- October 2007 (126)
- September 2007 (121)
- August 2007 (132)
- July 2007 (113)
- June 2007 (188)
- May 2007 (157)
- April 2007 (138)
- March 2007 (122)
- February 2007 (169)
- January 2007 (110)
- December 2006 (108)
- November 2006 (152)
- October 2006 (176)
- September 2006 (225)
- August 2006 (327)
- July 2006 (239)
- June 2006 (226)
- May 2006 (260)
- April 2006 (311)
- March 2006 (218)
- February 2006 (278)
- January 2006 (321)
- December 2005 (338)
- November 2005 (245)
- October 2005 (253)
- September 2005 (218)
- August 2005 (287)
- July 2005 (204)
- June 2005 (224)
- May 2005 (322)
- April 2005 (383)
- March 2005 (356)
- February 2005 (293)
- January 2005 (388)
- December 2004 (276)
- November 2004 (279)
- October 2004 (207)
- September 2004 (222)
- August 2004 (333)
- July 2004 (203)
- June 2004 (122)
- May 2004 (148)
- April 2004 (153)
- March 2004 (230)
- February 2004 (215)
- January 2004 (309)
- December 2003 (240)
- November 2003 (214)
- October 2003 (265)
- September 2003 (314)
- August 2003 (321)
- July 2003 (267)
- June 2003 (337)
- May 2003 (344)
- April 2003 (276)
- March 2003 (262)
- February 2003 (304)
- January 2003 (357)
- December 2002 (267)
- November 2002 (265)
- October 2002 (286)
- September 2002 (211)
- August 2002 (196)
- July 2002 (264)
- June 2002 (177)
- May 2002 (362)
- April 2002 (277)
- March 2002 (221)
- February 2002 (285)
- January 2002 (197)
- December 2001 (123)
- November 2001 (233)
- October 2001 (202)
- September 2001 (130)
- August 2001 (144)
- July 2001 (131)
- June 2001 (119)
- May 2001 (156)
- April 2001 (197)
- March 2001 (264)
- February 2001 (147)
- January 2001 (328)
- December 2000 (241)
- November 2000 (207)
- October 2000 (171)
- September 2000 (112)
- August 2000 (159)
- July 2000 (161)
- June 2000 (123)
- May 2000 (47)