Search Discussions

22 discussions - 72 posts

  • I have one remote user that wants to connect via DSL and a dynamic IP. I do NOT want to open the database to all internet IP's. Of course the fear is someone will attack and break the password for ...
    Dec 12, 2007 at 5:36 pm
    Dec 13, 2007 at 8:24 pm
  • Hello all, I have a problem. The following message keeps appearing in logs : ...
    Dec 5, 2007 at 7:53 am
    Dec 12, 2007 at 9:33 am
  • Hello, In my data table <d_borehole I have a field 'depth_unit' that is used to record the measurement unit of various numeric depths down a borehole. I have a 'look-up' table <r_unit that contains ...
    Greg CocksGreg Cocks
    Dec 29, 2007 at 12:01 am
    Jan 3, 2008 at 6:54 pm
  • Hi, Many thanks in advance. Any advice and or suggestion for command and/or methods to have a plpgsql stored function create a process / job that will run other stored functions. I've been doing the ...
    Robert M. BernabeRobert M. Bernabe
    Dec 20, 2007 at 10:52 pm
    Dec 24, 2007 at 1:44 pm
  • Hi: I have a script that I use to do regular dumps of my database. Over the weekend it failed, and produced the following error message. I'm not sure why this would have happened, how I would find ...
    Mija LeeMija Lee
    Dec 10, 2007 at 9:25 pm
    Dec 11, 2007 at 5:38 pm
  • Hello, I'm trying to call my PL/pgSQL stored procedure and receive the following error message: ERROR: Not enough resources are available to complete this request. SQL state: P0001 With ...
    Zubkovsky, SergeyZubkovsky, Sergey
    Dec 20, 2007 at 1:14 pm
    Dec 20, 2007 at 4:33 pm
  • I am attempting to install 8,2,4 on a Vista PC. I get to the point in the installation, where files have been copied and the installer attempts to create the postgres user. It fails with "Access ...
    Dale SeaburgDale Seaburg
    Dec 3, 2007 at 8:32 pm
    Dec 4, 2007 at 7:12 pm
  • Greetings, I have installed Postgresql from the William Kyngesbury distribution (http://www.kyngchaos.com/wiki/software:postgres) I do not get any errors starting the server, but it fails on ...
    Richard ChirgwinRichard Chirgwin
    Dec 20, 2007 at 2:26 am
    Dec 20, 2007 at 5:50 am
  • Hi All; I'm much more of a web developer than dba, that's why I'm asking this of the novice list. I've got a database in postgresql 7.4 with 111 tables. I recently created the 111th table and I ...
    Isaac VetterIsaac Vetter
    Dec 11, 2007 at 3:57 pm
    Dec 11, 2007 at 4:18 pm
  • Hello I still have only problems with installing th program. I cant reinstall as a service. It says wrong password. or account name. So I mark off the service and then the installing seems to work. ...
    Patrik ForsmanPatrik Forsman
    Dec 4, 2007 at 10:32 pm
    Dec 5, 2007 at 1:46 am
  • Hi, I am using *.bat file for database backup on client/workstation. I run bat file from the same client machine manually. Contents of file are: ----- cd C:\"Program Files"\"pgAdmin III"\1.8\ pg_dump ...
    Milan CirovicMilan Cirovic
    Dec 24, 2007 at 12:10 pm
    Dec 24, 2007 at 12:57 pm
  • Hi: I have a discrepancy in database size that I don't quite understand. I'm using postgres 8.1.3 on solaris 10. I have two databases on the same machine - the production database and a staging ...
    Mija LeeMija Lee
    Dec 19, 2007 at 4:52 pm
    Dec 19, 2007 at 4:57 pm
  • Hello, I am porting a client application from SQL-Server to PostgreSQL and so far .. so good. For the record, I am very pleased with the power of PostgreSQL. One of the features of this application ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Dec 19, 2007 at 10:29 am
    Dec 19, 2007 at 10:46 am
  • Hello List member, I have a table which ha sfollowing structure my_table: ( output_id serial priimary key, parent_id int, output_date timesatmp ) parent_table: (parent_id int, parent desc ) the ...
    Ashish KaralkarAshish Karalkar
    Dec 13, 2007 at 9:47 am
    Dec 13, 2007 at 5:23 pm
  • I'm writing a reporting script (on postgres 8.1) that logs some table stats along with the time, I'd like to write something like this:- SELECT now(), foo, COUNT(*) FROM table GROUP BY foo; now | foo ...
    Michael LushMichael Lush
    Dec 13, 2007 at 4:33 pm
    Dec 13, 2007 at 4:37 pm
  • I am new to postgresql and I'm working with two tables, both having a geometry for postGIS. What I am trying to do is get the five nearest people from one list for every person in the second. I was ...
    Bryan ManuelBryan Manuel
    Dec 5, 2007 at 4:48 am
    Dec 5, 2007 at 3:25 pm
  • Having upgraded to 8.3 beta 4 prior to creating large number of new tables, I note that Mandriva (my distro) wants to reverse my postgresql back to v 8.25 in order to satisy dependencies for ...
    G. J. WalshG. J. Walsh
    Dec 27, 2007 at 12:41 am
    Dec 27, 2007 at 12:41 am
  • Thanks Andreas And not to worry, I owuld not try to write to system tables directly :) Didier
    Didier Gasser-MorlayDidier Gasser-Morlay
    Dec 20, 2007 at 7:32 pm
    Dec 20, 2007 at 7:32 pm
  • I just downloaded the TPC-H benchmark and I just want to use the stock dbgen schema/data and qgen queries on postgres. However, while reading the documentation for running the makefile, postgres is ...
    Adam ConradAdam Conrad
    Dec 16, 2007 at 1:36 am
    Dec 16, 2007 at 1:36 am
  • Happy Holidays, 2 developers. Two DB's one on my workstation and the other DB on a different workstation. The problem: As one developer makes changes to his DB and those changes can be either data or ...
    Dec 14, 2007 at 8:07 pm
    Dec 14, 2007 at 8:07 pm
  • I own a small yoga studio, we developed an application to manager the studio, with a postgres backen. However now we are opening a second studio, do your a software/tools that can help us ...
    Roody senecalRoody senecal
    Dec 12, 2007 at 2:03 am
    Dec 12, 2007 at 2:03 am
  • Hello I have tried to reinstal postgresql because i belive somthing went wrong the first time. But now I comes up error. Something wrong with user account or password. Seems like I have to use the ...
    Patrik ForsmanPatrik Forsman
    Dec 4, 2007 at 2:50 pm
    Dec 4, 2007 at 2:50 pm
Group Navigation
period‹ prev | Dec 2007 | next ›
Group Overview
grouppgsql-novice @

30 users for December 2007

Tom Lane: 7 posts Andreas Kretschmer: 6 posts Johnf: 6 posts Obe, Regina: 6 posts Greg Cocks: 5 posts Mija Lee: 4 posts Sean Davis: 4 posts Cedric BUSCHINI: 3 posts Robert M. Bernabe: 3 posts Zubkovsky, Sergey: 3 posts Brad Nicholson: 2 posts Didier Gasser-Morlay: 2 posts Isaac Vetter: 2 posts Patrik Forsman: 2 posts Richard Chirgwin: 2 posts Adam Conrad: 1 post Ashish Karalkar: 1 post Bob McConnell: 1 post Bryan Manuel: 1 post Dale Seaburg: 1 post
show more