Search Discussions

18 discussions - 95 posts

  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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 ? ...
    Aug 26, 2013 at 2:22 pm
    Aug 26, 2013 at 6:02 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
  • 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
  • I need to build a query for the sample data below: ----------------------------------------------------------------------- -------- fte_clave fte_padre fte_porc fte_porc_aux total ...
    Aug 31, 2013 at 5:38 pm
    Aug 31, 2013 at 5:38 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
Group Navigation
period‹ prev | Aug 2013 | next ›
Group Overview
grouppgsql-novice @

37 users for August 2013

Birchall, Austen: 12 posts Jean MAURICE: 10 posts Luca Ferrari: 8 posts Athanasios Kostopoulos: 7 posts Tom Lane: 5 posts Raghu ram: 4 posts Tovo Rabemanantsoa: 4 posts Bruce Momjian: 3 posts Jack Kaufman: 3 posts Kevin Grittner: 3 posts Kevin Hunter Kesling: 3 posts Charles Sheridan: 2 posts David Johnston: 2 posts Edd Grant: 2 posts James David Smith: 2 posts Kevin Salisbury: 2 posts Kinnard Hockenhull: 2 posts Mael Rimbault: 2 posts Alan Hodgson: 1 post Amit Langote: 1 post
show more