FAQ

PostgreSQL > pgsql-novice

Search Discussions

8,816 discussions - 28,265 posts

  • I need to build a query for the sample data below: ----------------------------------------------------------------------- -------- fte_clave fte_padre fte_porc fte_porc_aux total ...
    JORGE MALDONADOJORGE 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 KaufmanJack 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 KeslingKevin 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 SheridanCharles 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 SmithJames 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 ? ...
    SpinDFazorSpinDFazor
    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, AustenBirchall, 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 plattPablo 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 .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 KostopoulosAthanasios 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 KostopoulosAthanasios 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 GrantEdd 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 WalterCarol 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 BlancoDaniel 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 RowanMichael 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, AustenBirchall, 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 SmithJames 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 HockenhullKinnard 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 PoloczekPhilip 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 DeveloperSome 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 LeoveyFrancisco 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 SmithJames 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 SmithJames 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, AustenBirchall, 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 OliverWayne Oliver
    Jul 22, 2013 at 8:50 am
    Jul 23, 2013 at 6:06 am
  • http://instanterectionpill.com/httpva/nokcycbm.ceephnjld Mag Gam 7/21/2013 7:29:27 AM
    Mag GamMag Gam
    Jul 21, 2013 at 6:29 am
    Jul 21, 2013 at 6:29 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 RoychoudhuryIndrajit 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 BlancoDaniel 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 WainwrightAnne 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 BlancoDaniel 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 StaffansJohannes 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, AustenBirchall, 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 OliveiraBrauner 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 ...
    MeganMegan
    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 SchwanbomJonas 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 ...
    WalerinaWalerina
    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 ...
    PmuPmu
    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 .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 DoubtsTechnical 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 KostopoulosAthanasios 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 DeveloperSome 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 RastogiAditya 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ć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 AndeErik 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 LawrenceChristian 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 MooreFrank 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 MelloJalisson Mello
    May 30, 2013 at 5:48 pm
    May 31, 2013 at 8:40 pm
  • 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.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 SwierczekMichael 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: ---------------------------------------------------------------------------- ...
    ChanghhChanghh
    May 20, 2013 at 4:05 am
    May 20, 2013 at 4:05 am
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions8,816
posts28,265
users4,603
websitepostgresql.org
irc#postgresql

Top users

Tom Lane: 2763 posts Josh Berkus: 601 posts Davis, Sean \(NIH/NCI\) [E]: 464 posts Michael Fuhr: 409 posts Operationsengineer1: 394 posts Bruno Wolff III: 373 posts Oliver Elphick: 283 posts Andreas Kretschmer: 255 posts Richard Broersma Jr: 231 posts John DeSoi: 191 posts Jean-Yves F. Barbier: 182 posts Frank Bax: 175 posts Keith Worthington: 166 posts Nabil Sayegh: 154 posts Stephan Szabo: 151 posts Andreas Kretschmer: 129 posts Andrew McMillan: 125 posts Michael Wood: 112 posts Andrej: 107 posts Mladen Gogala: 106 posts
show more
Archives