Search Discussions

27 discussions - 66 posts

  • I think the problem is something along these lines. I originally had the authentication method set to "MD5" in pg_hba.conf. I changed it to "trust" (and restarted postgres) just to try to get it ...
    Bruce HyattBruce Hyatt
    Dec 16, 2008 at 12:12 am
    Dec 25, 2008 at 8:00 pm
  • I have successfully created a user defined enumerated type using the CREATE TYPE some_type_name AS ENUM command using Postgresql 8.3.3. Is it possible to query the database (e.g. from psql or from ...
    Nagle, Gail A \(US SSA\)Nagle, Gail A \(US SSA\)
    Dec 18, 2008 at 9:08 am
    Dec 19, 2008 at 1:00 am
  • Hello All, Running 8.3.4. My situation is a little unique. I am running on a 1 core with 2GB of memory on Redhat Linux 5.2. My entire installation of pgsql is about 8GB (compressed) from pgdump. I ...
    Mag GamMag Gam
    Dec 12, 2008 at 1:09 am
    Dec 16, 2008 at 2:19 pm
  • Hi, I have e problem with a function (plpgsql) and a trigger in my database. Postgres and triggers/functions are new to me... Anyway, the database is filled with larg amounts of measurements, we are ...
    Ola EkedahlOla Ekedahl
    Dec 5, 2008 at 10:10 am
    Dec 8, 2008 at 9:07 am
  • Hi Postgres professionals, I hope someone is able to give some advice to the following matter: I created two plpgsql functions, which appear in pgAdminIII as expected. The first one works fine, it ...
    Andreas JuniusAndreas Junius
    Dec 1, 2008 at 5:38 pm
    Dec 2, 2008 at 7:12 am
  • Hi, I have a table with a column of integers called 'status'. A number may appear 0+ times in this column. For example, status -------- 25 28 28 ... I know I can get counts of the each status using ...
    Carol CheungCarol Cheung
    Dec 1, 2008 at 5:09 pm
    Dec 1, 2008 at 10:58 pm
  • Setup: Postgres 8.1.11 on RedHat EL 5 with only one (password protected) user: me and this machine does not have a web server. So, the security issues can be a little bit relaxed!! I have a bunch of ...
    P KapatP Kapat
    Dec 31, 2008 at 8:28 pm
    Jan 1, 2009 at 9:48 pm
  • I need to provide the ability for end users to make customizable reports from within my application. Can anyone give me some suggestions for open source web based applications that I could use as a ...
    Ertel, SteveErtel, Steve
    Dec 18, 2008 at 3:15 pm
    Dec 18, 2008 at 8:15 pm
  • Last night, while running a scheduled backup, our database became corrupt. When I open the database backup file it includes the definition of all of the tables but only data for the first table. We ...
    Ertel, SteveErtel, Steve
    Dec 16, 2008 at 2:39 pm
    Dec 16, 2008 at 3:32 pm
  • I have not been able to connect to postgresql via postgresql jdbc. The problem is not with postgresql jdbc because tcpdump on the postgresql host shows that the connection is getting through. The ...
    Bruce HyattBruce Hyatt
    Dec 12, 2008 at 2:31 am
    Dec 12, 2008 at 3:09 am
  • Is it possible to move a table from one schema to another (in the same database)? The only way I can think of is to: - backup table - modify backup file - restore from modified backup - delete ...
    Frank BaxFrank Bax
    Dec 3, 2008 at 1:55 am
    Dec 3, 2008 at 3:31 pm
  • Hello everyone, I am sorry if I am repeating as I had send this message before but it doesn't show anywhere. I am new to Postgresql but not to the database theme actually. So I went through the list ...
    Rita MatildesRita Matildes
    Dec 1, 2008 at 2:54 am
    Dec 3, 2008 at 9:43 am
  • Hi, I am not sure if I should be mailing this to postgis list or this one, but I'll shoot here first: Setup: Postgres 8.11 on RedHat EL 5 + postgis 1.3.2 I do the following to add the postgis ...
    P KapatP Kapat
    Dec 31, 2008 at 8:14 pm
    Jan 5, 2009 at 3:18 pm
  • So how good is the random() function in pgsql? How many iterations through the PRNG before the PRNG loops? Does it depend on the underlying O/S? Which, in our case, is CentOS 5, 64bit. (I ask, ...
    Thomas HaroldThomas Harold
    Dec 30, 2008 at 12:25 pm
    Dec 30, 2008 at 3:44 pm
  • Hey Everyone, I was hoping someone could give me a push in the right direction. From the info on the web and what I've been reading in the manuals, and what I've been trying out, I'm getting very ...
    Bastiaan OlijBastiaan Olij
    Dec 23, 2008 at 11:02 pm
    Dec 24, 2008 at 4:11 pm
  • Hi all I wouldn't normally forward all but if you have heard about the internet explorer security problems you will probably want this. ...
    Stephen ChoulartonStephen Choularton
    Dec 18, 2008 at 7:40 pm
    Dec 22, 2008 at 10:08 pm
  • Hi, Two tables Table_Master id bigint t1 timestamp with time zone t2 timestamp with time zone PK is id,t1 Table_Data ts timestamp with time zone data text pk is ts like to get all rows from ...
    Yogesh SharmaYogesh Sharma
    Dec 18, 2008 at 8:26 pm
    Dec 18, 2008 at 9:17 pm
  • Hi list, I was just wondering how I can see the source code of a specific store procedure. I did a `\df <function_name ` but all it doesn't show exactly the entire source code. I'm using 8.1.8. ...
    Ridvan Lakas ng Bayan S. BaluyosRidvan Lakas ng Bayan S. Baluyos
    Dec 18, 2008 at 7:04 am
    Dec 18, 2008 at 2:46 pm
  • I 'd like to allow only one remote client to connect using plain-text password from certain IP. How to do it?How to setup pg_hba.conf or postgresql.conf? Thanks in advance.
    Dec 17, 2008 at 4:36 am
    Dec 17, 2008 at 6:09 am
  • I've been over my pg_hba.conf and postgresql.conf files again and again, restarting after changes and I always get 08004 connection refused when I try to connect through the postgresql jdbc from ...
    Bruce HyattBruce Hyatt
    Dec 13, 2008 at 3:40 am
    Dec 13, 2008 at 4:41 am
  • Hi All, Alas, my PhD is mathematics, not linquistics. I do not seem to be able to parse the explanation of quotes and delimiters in thte COPY command documentation correctly. I thought that the ...
    Mary AndersonMary Anderson
    Dec 13, 2008 at 12:38 am
    Dec 13, 2008 at 2:20 am
  • Hi - I have a question about how pg_dump uses /tmp. We are running postgres 8.2.4 on solaris 10. We have had some problems with our dump scripts running out of memory on our cron server, and when we ...
    Lee, MijaLee, Mija
    Dec 4, 2008 at 4:47 pm
    Dec 7, 2008 at 9:38 pm
  • Hello, I created and some clients are using a PostgreSQL database with a web page connect. This is for holding environmental analytical data, locations of features, etc. I have added PostGIS but am ...
    Greg CocksGreg Cocks
    Dec 3, 2008 at 2:28 am
    Dec 3, 2008 at 11:24 pm
  • Accidentally replied instead of replied-to-all ... --- On Fri, 12/19/08, Bruce Hyatt wrote:
    Bruce HyattBruce Hyatt
    Dec 20, 2008 at 3:18 am
    Dec 20, 2008 at 3:18 am
  • I've been using PostgreSQL for a while, but now I'm trying to really wrap my head around the ins and outs of each layer, and how to properly secure each layer and grant selective access. ...
    Thomas HaroldThomas Harold
    Dec 17, 2008 at 4:06 pm
    Dec 17, 2008 at 4:06 pm
  • Sorry in case of double posting, wasn't registered when I tried it the first time! Hi! I am currently trying my first steps in writing my own functions in C. I read through the documentation and ...
    Dec 4, 2008 at 11:29 am
    Dec 4, 2008 at 11:29 am
  • hello as newbe Im looking for information for the creation of an init script for my DB. I want to create a DB that some of its features are license based. This means that each time the server is up I ...
    Gal WaldmanGal Waldman
    Dec 3, 2008 at 11:48 am
    Dec 3, 2008 at 11:48 am
Group Navigation
period‹ prev | Dec 2008 | next ›
Group Overview
grouppgsql-novice @

40 users for December 2008

Bruce Hyatt: 8 posts Tom Lane: 7 posts Ertel, Steve: 3 posts Nagle, Gail A \(US SSA\): 3 posts Andreas Junius: 2 posts Andreas Kretschmer: 2 posts Frank Bax: 2 posts Mark Roberts: 2 posts Ognjen Blagojevic: 2 posts Ola Ekedahl: 2 posts P Kapat: 2 posts Stephen Choularton: 2 posts Thomas Harold: 2 posts Andreas Kretschmer: 1 post Andrej Ricnik-Bay: 1 post Bastiaan Olij: 1 post Brad Nicholson: 1 post Bruce Momjian: 1 post Carol Cheung: 1 post Damian Carey: 1 post
show more