Search Discussions

30 discussions - 104 posts

  • Hi, I am reading the documentation from here: http://www.postgresql.org/docs/8.1/static/ssh-tunnels.html I am able to ssh (I use ssh keys) in to foo.com using the username joe. My client machine ...
    P KapatP Kapat
    Nov 18, 2008 at 8:46 am
    Nov 19, 2008 at 10:50 pm
  • - I have PostgreSQL 7.4.19 on CentOS 4.7 with no databases I need to keep. - PG was installed with CentOS in /var/lib/pgsql. - I am the only local user but I have Apache running on the same machine ...
    Bruce HyattBruce Hyatt
    Nov 13, 2008 at 1:54 am
    Nov 15, 2008 at 6:20 pm
  • Hello All, I am beginning to partition some database tables and need some help thinking things through. After evaluating my data, it appears that the best partition would be based on year and month. ...
    Ertel, SteveErtel, Steve
    Nov 12, 2008 at 6:00 pm
    Nov 13, 2008 at 7:20 pm
  • Hi, I'm using Postgres 8.3 on Windows Server to store data from an Apache/Tomcat Web Application. I'm using pg_dump to backup the database manually on a daily basis. Can someone recommend a solution ...
    Nov 11, 2008 at 3:23 pm
    Nov 12, 2008 at 5:55 pm
  • Hi guys, I was looking for something like the follow but i dont get ... I want to do two inserts. In my first insert i want that the query returns a result for me and in the second, i want that the ...
    Leví Teodoro da SilvaLeví Teodoro da Silva
    Nov 7, 2008 at 1:21 pm
    Nov 7, 2008 at 2:47 pm
  • I'm a newbie, using the Mac platform. I've installed PostgreSQL on a server and can run PostgreSQL based application from that server with no problem. But when I try to access the DB on a different ...
    Steve HenrySteve Henry
    Nov 12, 2008 at 10:32 am
    Nov 12, 2008 at 1:39 pm
  • I have a Slackware 10.2.0 machine which has been happily serving files, Apache, Pg, etc. across my home network for some time. I had no problem installing pg 8.2.1 on it. But now when I try to ...
    Bob McConnellBob McConnell
    Nov 28, 2008 at 7:07 pm
    Nov 28, 2008 at 9:54 pm
  • My inclination when creating tables is to create columns using varchar-sizes in increments of 10 or 5 but I suspect there must be more-efficient sizes, specifically, values like 16, 32, 64 minus ...
    Bruce HyattBruce Hyatt
    Nov 26, 2008 at 1:51 am
    Nov 26, 2008 at 3:20 pm
  • Hi All, Need a Help. Can a check constraint be deferred until the end of a transaction ? In other words, if i have a constraint like this: CREATE TABLE test ( id serial NOT NULL, qt1 integer NOT NULL ...
    Luiz K. MatsumuraLuiz K. Matsumura
    Nov 24, 2008 at 1:40 pm
    Nov 24, 2008 at 10:52 pm
  • It appears there are some predefined roles (superuser, admin) but I can't find a definition of these privileges in the documentation. I understand that users and roles are equal (though create role ...
    Bruce HyattBruce Hyatt
    Nov 22, 2008 at 1:55 am
    Nov 22, 2008 at 4:37 am
  • Hi, I have a table with these fields, simplified here Device (string name of device) Power State (String "on" or "off") Timestamp Every time a device is turned on or off a record is written to the ...
    Keith TurnerKeith Turner
    Nov 26, 2008 at 5:16 pm
    Nov 26, 2008 at 9:37 pm
  • In MSSQL, I have a dozen or so databases that rely on some shared tables (states, species lists, for example). I put the shared tables in a db called Common. To query them, mssql allows: select ...
    Mark WimerMark Wimer
    Nov 19, 2008 at 6:32 pm
    Nov 19, 2008 at 7:31 pm
  • Hi all, I would like to be able to query some systems table or view to obtain the creation data of a table. INFORMATION_SCHEMA does not seem to record this information. Does postgres store it ...
    Mary AndersonMary Anderson
    Nov 17, 2008 at 4:53 pm
    Nov 17, 2008 at 6:19 pm
  • Hi, I have three tables 1) A list of devices 2) List of rooms 3) A bridge table that relates the two using each table's ID column Any device can be in 0 to All rooms I want to create a view that ...
    Keith TurnerKeith Turner
    Nov 7, 2008 at 8:52 pm
    Nov 7, 2008 at 9:37 pm
  • Hi, I'm a java developer and a novice Postgres user. I'm trying to create a view that will display common fields from several different tables to simplify some JDBC queries. To illustrate my ...
    Nov 6, 2008 at 5:21 pm
    Nov 6, 2008 at 5:50 pm
  • I can do # su - postgres $ psql and run sql commands, but running psql as the user I just created with the command createuser -s -d -E -P -e myself fails with psql: could not connect to server: ...
    A BA B
    Nov 3, 2008 at 10:04 am
    Nov 3, 2008 at 2:41 pm
  • Hi all, I sent similar mail 5 days ago to mailing list owner, but I didn't get any answer. Maybe someone here can help. ccTLD .yu is due to separation of Serbia and Montenegro being replaced by ...
    Ognjen BlagojevicOgnjen Blagojevic
    Nov 19, 2008 at 9:42 am
    Dec 2, 2008 at 2:42 pm
  • Hello all, I have a query regarding PGCLuster. I could not find a cluster specific mailing list so i m posting it here. Is it possible to install pgcluster 1.3c on a system which already has ...
    Pushpendra Singh ThakurPushpendra Singh Thakur
    Nov 26, 2008 at 4:22 pm
    Nov 26, 2008 at 6:44 pm
  • Hello, I hope this is the right place to post my question, it is a user- problem and I wasn't able to extract a solution from the documentation. I am using PostgreSQL 8.35 I am a real novice in the ...
    Rainer SchuetzRainer Schuetz
    Nov 21, 2008 at 5:05 pm
    Nov 21, 2008 at 5:18 pm
  • Hi guys !!!! I am from Brazil, and here we use a lot of special characters like : ã, é. I did a dump from my database, and when i will restore the database i got error with the encoding : invalid ...
    Leví Teodoro da SilvaLeví Teodoro da Silva
    Nov 6, 2008 at 11:50 am
    Nov 7, 2008 at 12:07 pm
  • hello, I want to establish basic security for my pgsql database, which is on a commercial web server. In particular, I don't want people to be able to login from the internet as my superuser. If I ...
    Robert HollingsworthRobert Hollingsworth
    Nov 5, 2008 at 5:41 pm
    Nov 5, 2008 at 6:17 pm
  • Hello everyone, I use an app (developed by someone else) that uses Postgres 8.3 as backend. The app in question starts up for a rather long time, about 10 minutes, during which Postgres is heavily ...
    Marcin KrolMarcin Krol
    Nov 5, 2008 at 11:20 am
    Nov 5, 2008 at 3:42 pm
  • While trying to find the answer to this question (does pg_dumpall support BLOBs) I found some old mailing list posts that said it does not support blobs because it does a plaintext dump, and that ...
    Dobes VandermeerDobes Vandermeer
    Nov 5, 2008 at 9:49 am
    Nov 5, 2008 at 3:28 pm
  • Hello everyone, I've done VACUUM FULL on my db and noticed that it reclaimed considerably more diskspace than regular VACUUM. Should I use VACUUM FULL or not? Are there any downsides/risks to it ...
    Marcin KrolMarcin Krol
    Nov 5, 2008 at 1:47 pm
    Nov 5, 2008 at 2:06 pm
  • This is the expected result given the sample data you provided. If your sample data for call table should be 2008 instead of 2007; then output would be: call_id | datetime | user_id | mobile_no | ...
    Frank BaxFrank Bax
    Nov 20, 2008 at 4:19 am
    Nov 20, 2008 at 4:19 am
  • Unregister ml_flegl@centrum.cz Information from ESET NOD32 Antivirus, version of virus signature database 3619 (20081117) The message was checked by ESET NOD32 Antivirus. http://www.eset.com
    David FleglDavid Flegl
    Nov 17, 2008 at 7:58 pm
    Nov 17, 2008 at 7:58 pm
  • Hi, I need to install the correct version of pgpool on a Suse 10.2 system running PostgreSQL version 8.1.5. I tried the file pgpool-3.2-1vl1.i386.rpm ...
    Wright, GeorgeWright, George
    Nov 17, 2008 at 3:54 pm
    Nov 17, 2008 at 3:54 pm
  • I did some searching, but wasn't able to find anything that would allow me to query a postgres server ("B") for results within a query executing on a separate server ("A") in order to facilitate ...
    Phillip SitbonPhillip Sitbon
    Nov 7, 2008 at 7:37 pm
    Nov 7, 2008 at 7:37 pm
  • Hi, I would like to ask you an advice because I have a database that seems to deadlock on Exclusive locks every couple of days. The issue comes at night when I reindex some tables, it seems unable to ...
    Gabriele MessineoGabriele Messineo
    Nov 6, 2008 at 8:45 am
    Nov 6, 2008 at 8:45 am
  • Hello everyone, Some novices may find it useful: How to calculate disk space occupied by each of top 10 biggest tables: SELECT relpages * 8192 AS size_in_bytes, relname FROM pg_class WHERE ...
    Marcin KrolMarcin Krol
    Nov 5, 2008 at 1:07 pm
    Nov 5, 2008 at 1:07 pm
Group Navigation
period‹ prev | Nov 2008 | next ›
Group Overview
grouppgsql-novice @

35 users for November 2008

Tom Lane: 18 posts Obe, Regina: 13 posts Bruce Hyatt: 9 posts P Kapat: 7 posts Leví Teodoro da Silva: 5 posts Gcj: 4 posts Keith Turner: 4 posts Andreas Kretschmer: 3 posts Bob McConnell: 3 posts Ertel, Steve: 3 posts Frank Bax: 3 posts Marcin Krol: 3 posts Joshua Tolley: 2 posts Luiz K. Matsumura: 2 posts Mark Wimer: 2 posts Michael Swierczek: 2 posts Sean Davis: 2 posts Tim Bowden: 2 posts A B: 1 post Andreas Kretschmer: 1 post
show more