FAQ

PostgreSQL > pgsql-admin > November 2001

Search Discussions

74 discussions - 203 posts

  • contrib refers to the contrib directory at the top level of the source tree.
    Stephan SzaboStephan Szabo
    Nov 27, 2001 at 3:43 pm
    Nov 29, 2001 at 8:13 pm
  • Hi. I need to know howto make a test for know the best accuracy of two types of tables: 1- a table with three fields, and with seven registers or more, and 2- a table with ten fields, and two ...
    Manuel TrujilloManuel Trujillo
    Nov 28, 2001 at 9:49 am
    Nov 30, 2001 at 2:52 pm
  • Hi all, sometimes i have a curios problem with my Zope. Without any errors in any logs Zope could not authenticate himself with postgres. The error message is that there is a wrong password. After a ...
    Andre SchubertAndre Schubert
    Nov 23, 2001 at 9:54 am
    Dec 14, 2001 at 12:38 am
  • I need to create a diagram of our schema. I recently obtained a copy of Visio. Has anyone used Visio to reverse engineer a model diagram from a Postgres database?? If not, can anyone recommend the ...
    Jodi KanterJodi Kanter
    Nov 29, 2001 at 8:25 pm
    Nov 30, 2001 at 4:38 pm
  • Hi : Want to get your opinion. I am thinking to schedule to run Vaccum everynight. 1) As I understand, Vaccum is the command to delete old data, right? 1) Do I have to stop the postmaster before run ...
    Leong, FushanLeong, Fushan
    Nov 29, 2001 at 5:18 pm
    Nov 30, 2001 at 4:06 am
  • Maybe it's just me, but I think pg_hba.conf needs a user column in it. On the one hand, I need local sameuser password because I have untrusted users who should only have access to their own ...
    Nick SayerNick Sayer
    Nov 7, 2001 at 2:19 am
    Nov 8, 2001 at 12:19 am
  • Hi! I subscribe to this list now. :) I have a question. How can I query (in SQL) the user permissions of a table? Which system table stores the tables permissions for the user? Bye! ---------------- ...
    MGMG
    Nov 22, 2001 at 9:39 am
    Nov 26, 2001 at 2:52 pm
  • A grim suspicion begins to dawn on me ... We have an application that attempts many insertions into a table, detecting the prior existance of the row by whether we get a 'duplicate key in unique ...
    Jeff BoesJeff Boes
    Nov 16, 2001 at 5:07 pm
    Nov 18, 2001 at 11:02 pm
  • We have a table which has approximately 400,000 rows. It has 17 columns, and 4 indexes. The primary key is a int4 (filled by a sequence), additionally we have two more int4 indexes and a timestamp ...
    Jeff BoesJeff Boes
    Nov 9, 2001 at 9:37 pm
    Nov 12, 2001 at 2:36 pm
  • Hello everyone: Would anyone know how to find a bad date field in an external file? I have an external file that I am using to populate a table using the following command: COPY release_data FROM ...
    Peralta Miguel-MPERALT1Peralta Miguel-MPERALT1
    Nov 29, 2001 at 4:42 pm
    Nov 29, 2001 at 6:33 pm
  • Hi We are a group studying at Aalborg University. We are at the moment developing a postgresql-db (7.1.3) on Mandrake 8.0, which we intend to access via libpq. But at the moment we can't even connect ...
    Ryan Rohde HansenRyan Rohde Hansen
    Nov 21, 2001 at 2:08 pm
    Nov 24, 2001 at 11:06 pm
  • I use Microsoft SQL 7 (on Microsoft Windows NT 4) for support database of radius server. I want give up Microsoft SQL 7 and organize support database of radius server on PostgreSQL (on FreeBSD 4.3). ...
    Aleksander KopanchukAleksander Kopanchuk
    Nov 12, 2001 at 4:07 pm
    Nov 21, 2001 at 12:23 pm
  • I mistakenly created a second database cluster. Can someone tell me how to remove this? Also, I need to reinitialize my original cluster since I did not have my locale set properly. I have corrected ...
    Default UserDefault User
    Nov 20, 2001 at 1:38 pm
    Nov 21, 2001 at 4:13 am
  • Hi We´re running a database on PGSQL 7.1.3 and I want to know where(I mean the files are numbered and I want to know who is who) are stored the tables Thanks in advance
    Luis AmigoLuis Amigo
    Nov 15, 2001 at 10:49 am
    Nov 15, 2001 at 3:58 pm
  • Hi- It would be great if somebody can give me a "recipe" answer for this, but I'm equally interested in informed conjecture and stories from similar experiences. We're getting ready to spec our ...
    Nick FankhauserNick Fankhauser
    Nov 13, 2001 at 7:57 pm
    Nov 14, 2001 at 8:52 pm
  • hi I have a problem with my postgre 1 time a day my postgre crash my server and send me a message "... to many clients connect..." I have incrase the sharedbuffer and the max connection in ...
    ProgrammersProgrammers
    Nov 12, 2001 at 9:07 am
    Nov 12, 2001 at 4:45 pm
  • Hi, What's wrong with the patch mailingslist ? I can't read the history (page not found). I have subscribed to the list, it's confirmed by mail, but i get no mail. I've posted a little patch, but i ...
    Ferdinand SmitFerdinand Smit
    Nov 5, 2001 at 11:01 am
    Nov 5, 2001 at 3:39 pm
  • I seem to remember a psql option that dumped out the table schema. I can't seem to find it in the man for psql. Could someone point out the option to me? Thanks. -Tony
    Tony ReinaTony Reina
    Nov 30, 2001 at 7:08 pm
    Dec 4, 2001 at 1:38 am
  • Hi, I would like to know how can we create a schema in postgres. Many thanks Jyoti. ********************************************************************** This email and any files transmitted with it ...
    Jyoti PatilJyoti Patil
    Nov 28, 2001 at 10:38 am
    Nov 28, 2001 at 4:39 pm
  • hello, what is wrong? postgresql 7.1.3 suse linux 7.1 configure postgresql: ./configure --prefix=$DIR_DEST --exec-prefix=$DIR_DEST --enable-local --enable-multibyte --enable-odbc --enable-syslog ...
    König, FrankKönig, Frank
    Nov 21, 2001 at 2:15 pm
    Nov 27, 2001 at 8:42 am
  • I am wondering what 'common' solutions are used to access postgress data on unix back ends. I'd be glad to tabulate results for the list, but don't even know all the options. I am thinking of ...
    David BearDavid Bear
    Nov 26, 2001 at 4:24 pm
    Nov 26, 2001 at 11:38 pm
  • Hi, i have forwarded this message from Zope in hope of an answer.
    Andre SchubertAndre Schubert
    Nov 23, 2001 at 5:20 am
    Nov 26, 2001 at 9:44 am
  • I am running PostgreSQL 7.1.2/3 on Mandrake 8.1. My problem (well my immediate problem) is that the Postmaster will not start. I installed MDK a couple months ago. In that time, Postgres has started ...
    Eric TheisEric Theis
    Nov 19, 2001 at 10:27 pm
    Nov 21, 2001 at 2:07 am
  • Does anyone have a pointer to info on what kinds of things cause entries in pg_trigger? We're trying to understand why some tables have a half-dozen corresponding entries, and some have 30. -- Jeff ...
    Jeff BoesJeff Boes
    Nov 20, 2001 at 8:38 pm
    Nov 20, 2001 at 9:56 pm
  • Hi i hope some one can help i'm new to PostgreSQL i have been trying to load data into a table using the "\Copy" function. All the records (approx. 15,000) will go into the table but the it doesn't ...
    Elizabeth O'NeillElizabeth O'Neill
    Nov 14, 2001 at 4:39 pm
    Nov 15, 2001 at 5:05 pm
  • We've been adjusting the WAL log file count on our database. The only effects we've seen so far in increasing the count from 8 (default) to 32 (current) are: 1) No more WAL messages in the log 8-/ ...
    Jeff BoesJeff Boes
    Nov 12, 2001 at 10:37 pm
    Nov 12, 2001 at 11:43 pm
  • Hi : Want to get some idea about Vaccum function... How often would you suggest to run Vaccum command? Should I schedule to run in non-busy time like midnight? Vaccum all or Vacuum for each ...
    Leong, FushanLeong, Fushan
    Nov 28, 2001 at 10:59 pm
    Dec 12, 2001 at 3:39 pm
  • Hi everybody ! We are developing a PHP-application with a postgresql-server, apache and the php-module. Developing works well until this day - a new developer entered out team. Now we are three ...
    Marc SchöchlinMarc Schöchlin
    Nov 30, 2001 at 5:08 pm
    Dec 2, 2001 at 3:38 am
  • Hi, I've got SuSE 7.3 with PostgreSQL 7.1.3 server an a system where LANG=de_DE@euro. I tried to import some data with: \copy im from '/usr/share/data/pricelist.csv' using delimiters '|' and got ...
    Oliver VecernikOliver Vecernik
    Nov 30, 2001 at 1:38 pm
    Nov 30, 2001 at 3:22 pm
  • When trying to connect to the postgreSQL database through ODBC, I get an error "Unknown username or password. Password crypt authentication not supported. (errcode 13095)" I can assume ODBC do not ...
    Sulik_pbemSulik_pbem
    Nov 27, 2001 at 1:56 pm
    Nov 28, 2001 at 6:34 pm
  • I'm trying to make a copy of a production database that's running on a RedHat 7.0 machines with posgresql 7.1.2 and moving it to a machine running RedHat 7.1 with postgresql 7.1.3. The database has ...
    Lane RollinsLane Rollins
    Nov 26, 2001 at 11:28 pm
    Nov 27, 2001 at 2:48 am
  • I have a database that was busy when it's server was rebooted. Following is the output of postmaster -d4. It runs for about 15 minutes and then core dumps. Any advice how I can get this database ...
    Jeff WaughJeff Waugh
    Nov 22, 2001 at 5:51 pm
    Nov 23, 2001 at 1:43 am
  • Hi. I'm using a postgresql-7.1.3 compiled into a Debian Potato. I need to grant access "select" to one user in all tables. How can I make this into "one command", without make "grant 1 to x", "grant ...
    Manuel TrujilloManuel Trujillo
    Nov 19, 2001 at 12:00 pm
    Nov 20, 2001 at 9:25 pm
  • Hi Can anyone help me write a trigger on a table, I have created an audit table for a table and what I want trigger to do is to whenever a record is deleted from the table it should first be inserted ...
    Mr OCPMr OCP
    Nov 16, 2001 at 2:18 am
    Nov 20, 2001 at 3:48 pm
  • I'm running postgers 7.1.3 on a origin 2000 running Irix 6.5.13 and oid2name hangs up. It's because on line 68 "while ((c = getopt(argc, argv, "H:p:U:P:d:t:o:xh?")) != EOF)" we're trying to compare a ...
    Luis AmigoLuis Amigo
    Nov 15, 2001 at 4:27 pm
    Nov 15, 2001 at 6:26 pm
  • Intro data: 1. table with one (from many) columns: timestamp | timestamp with time zone | not null default timeofday() used because I need better time resultion than just second provided by use of ...
    Radoslaw StachowiakRadoslaw Stachowiak
    Nov 6, 2001 at 5:57 pm
    Nov 15, 2001 at 5:35 pm
  • Hi, I modified a source file(I just define a macro for #ifdef) in the gist subdirectory, and comiled the source file by using makefile in the directory. Then, what I need to do to see the behaviour ...
    Seung Hyun JeongSeung Hyun Jeong
    Nov 12, 2001 at 7:11 pm
    Nov 15, 2001 at 4:10 pm
  • Since my earlier posts on this, I have gotten several requests for the steps involved. As there does not seem to be a clear explanation in the docs, I decided to post this. Perhaps the experts can ...
    Eric SawlerEric Sawler
    Nov 9, 2001 at 1:07 pm
    Nov 9, 2001 at 6:39 pm
  • Hi, I read the manual for the REINDEX command. The REINDEX command is described as "Recover corrupted system indexes under stand-alone Postgres " I am currently trying to reindex an user table. Does ...
    Shuzo KuboShuzo Kubo
    Nov 8, 2001 at 8:05 am
    Nov 8, 2001 at 2:27 pm
  • Hi I'm building an app (A) that inserts about 30.000 - 40.000 records in a table per day. Another app (B) get this records and process it, an then the records are deleted. The A app gets 50 records ...
    Manuel Duran AgueteManuel Duran Aguete
    Nov 6, 2001 at 4:01 pm
    Nov 6, 2001 at 5:07 pm
  • Hi. I currently had a client move from linux 7.1 to 7.2, at this point postgres stopped working. I attempted to install the new rpms, but had many dependency failures. I attempted to start the ...
    Michael BakerMichael Baker
    Nov 1, 2001 at 7:37 pm
    Nov 5, 2001 at 4:37 pm
  • Hello! Im using several views for the Usermanagment of a database. My question is: How does postgres keep the views consistent to the according tables( if the original table has been changed)? Is ...
    David M. RichterDavid M. Richter
    Nov 1, 2001 at 2:37 pm
    Nov 1, 2001 at 4:07 pm
  • I'm the administrator of lbdpc15.epfl.ch and mirroring postgresql for switzerland since now 4 years. Why has been ch.postgresql.org and ftp.ch.postgresql.org been removed from your DNS and ...
    Philippe RochatPhilippe Rochat
    Nov 1, 2001 at 3:19 pm
    Nov 1, 2001 at 3:30 pm
  • Hi everybody, I'm having a serious performance problem. We're using PostgreSQL (7.1.3) for data collection (appr. 3 000 000 new records per day). Every night all records older than 3 days are ...
    MwiMwi
    Nov 1, 2001 at 1:37 pm
    Nov 1, 2001 at 2:02 pm
  • Hi : I am working on the procedure to restore a database from dump file ( pg_dump ). I am thinking to create a new database, then restore the dump file, drop the old database and rename the old ...
    Leong, FushanLeong, Fushan
    Nov 30, 2001 at 7:01 pm
    Nov 30, 2001 at 7:01 pm
  • Configuration: Windows 2000 Server cygwin 2.78.2.9 PostgreSQL 7.1.3 psqlODBC 7.1.8 pgAdmin II 1.1.66 Bug: Capital letters cannot be used in column names used in foreign key constraints All Smalls ...
    Mike SmialekMike Smialek
    Nov 30, 2001 at 4:38 pm
    Nov 30, 2001 at 4:38 pm
  • I have modified pgmonitor to work on Solaris. You can download version 0.54 from: http://gborg.postgresql.org/project/pgmonitor/download/download.php Would some Solaris folks please test it. See the ...
    Bruce MomjianBruce Momjian
    Nov 29, 2001 at 9:59 pm
    Nov 29, 2001 at 9:59 pm
  • I am aware of the initlocation command that allows me to set up a new directory location for a database CREATE DATABASE xxx WITH LOCATION = 'xxx'; I am interested a finer level of control for ...
    Jeff YoungJeff Young
    Nov 28, 2001 at 8:38 pm
    Nov 28, 2001 at 8:38 pm
  • Hi all, I had curious problem with the characters like " éèàïîù... " (refer to my first mail "[ADMIN] character sequence problem" for more information). My database was encoding with UNICODE. I have ...
    Vincent GaboriauVincent Gaboriau
    Nov 28, 2001 at 4:23 pm
    Nov 28, 2001 at 4:23 pm
  • From the document, I haven't found it can do this. Does anybody know how to store data to raw device? Thanks. ming du
    Ming Du - Sun MicrosystemsMing Du - Sun Microsystems
    Nov 28, 2001 at 3:27 pm
    Nov 28, 2001 at 3:27 pm
Nov 2001
12
Group Navigation
period‹ prev | Nov 2001 | next ›
Group Overview
grouppgsql-admin @
categoriespostgresql
discussions74
posts203
users94
websitepostgresql.org
irc#postgresql

94 users for November 2001

Tom Lane: 24 posts Stephan Szabo: 13 posts Vincent Gaboriau: 9 posts Jeff Boes: 9 posts Nick Fankhauser: 8 posts Bangh: 6 posts Luis Amigo: 6 posts Manuel Trujillo: 6 posts Bruce Momjian: 5 posts Leong, Fushan: 5 posts Andre Schubert: 4 posts Andrew G. Hammond: 4 posts Brian McCane: 3 posts Chad R. Larson: 3 posts Chad R. Larson: 3 posts Ferdinand Smit: 3 posts Ian Barwick: 3 posts Radoslaw Stachowiak: 3 posts David Stanaway: 2 posts Jesus Sandoval: 2 posts
show more
Archives