FAQ

PostgreSQL > pgsql-admin > June 2004

Search Discussions

132 discussions - 418 posts

  • Hey folks, I am working on a rather small, simple database. I'm running 7.3.5 on an OpenBSD 3.5-STABLE machine (1.3GHz, 512M RAM, IDE drive using UDMA-5). I am parsing and storing emails, so I have a ...
    C. BensendC. Bensend
    Jun 16, 2004 at 12:58 am
    Jun 21, 2004 at 1:17 am
  • Hi, I have about 200 functions in a schema and I have to grant execute privilege on all these functions to a group. I have found on the web an interesting function for grant access on table. ...
    Jean-Denis GiguereJean-Denis Giguere
    Jun 29, 2004 at 9:40 pm
    Jun 30, 2004 at 4:32 pm
  • Hi all, We have table is database which cannot be displayed by either \d, or \dt or pg_class. But we can select, DML on it. Also relfilenode is in our base/dboid directory and timestamp does change. ...
    Lee WuLee Wu
    Jun 14, 2004 at 10:58 pm
    Jun 16, 2004 at 12:11 am
  • what about just : netstat -na | grep 5432 to see if any 5432 stuff is hanging around and if so in what state... It may be that you are missing the evidence of the problem because you filtered -plut ...
    RobRob
    Jun 4, 2004 at 9:51 am
    Jun 8, 2004 at 12:36 pm
  • Hi Tom, I saw your post: http://archives.postgresql.org/pgsql-general/2004-02/msg00194.php We have same error when I do pg_restore under PG version 7.3.2. Can this patch apply to 7.3.2? Where can I ...
    Lee WuLee Wu
    Jun 17, 2004 at 8:47 pm
    Jul 20, 2004 at 4:05 pm
  • How can I do to put a file into the PostgreSQL ? I have got the contents of file in binary yet and put on a String on my APP, but when I try to insert it on postgre, it returns to me: ERROR: parser: ...
    Eduardo S. FontanettiEduardo S. Fontanetti
    Jun 24, 2004 at 7:16 pm
    Jun 28, 2004 at 1:50 pm
  • I recovered my database by pg_resetxlog and then did a dump , initdb , reload. one of the tables exhibited this phenomenon. I thought it was worth mentioning to the developers. Regds mallah. rt2=# ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Jun 16, 2004 at 7:52 am
    Jun 18, 2004 at 5:15 am
  • Hey folks.... Just getting into postgre now. I am wondering if there is something like PhpMyAdmin (web-based db admin tool) for postgresql. Any help is much appreciated! Thanks loads, Michael
    Michael HoldenMichael Holden
    Jun 22, 2004 at 5:09 pm
    Jun 23, 2004 at 7:47 am
  • Greetings, During testing of our application we ran into a very odd error: very randomly during the test the postgresql log file showed a "ERROR: 53200: out of memory" we changed the logging ...
    Adi AlurkarAdi Alurkar
    Jun 8, 2004 at 12:01 am
    Jun 16, 2004 at 1:39 am
  • Hi, pg_dump can be used to dump an entire database, or just a single table. Is there a way to make a consistent dump of more than one table, but less than all of the tables in the database? Doing a ...
    David F. SkollDavid F. Skoll
    Jun 9, 2004 at 2:09 pm
    Jun 10, 2004 at 4:27 am
  • Hi, I need to dump only partial content of my database, for example i want to dump only records that has been insterted to the database from a specific date. I tried to use pg_dump/pg_export but did ...
    H_harushH_harush
    Jun 30, 2004 at 12:14 pm
    Jul 2, 2004 at 9:03 pm
  • Can a database system be restored just from the data under the installation directory? I backed-up my database using "rsync /var/lib/pgsql <dest_directory " Then I upgraded my rpms from 7.3.4 to 7.4. ...
    Chris FjellChris Fjell
    Jun 18, 2004 at 11:42 pm
    Jun 23, 2004 at 11:43 am
  • I have tried to install webauth on Mandrake 2.4.22. For this, I have installed : apache server, Tcl/Tk, PostgreSQL, mod_auth_pgsql et pwgen. - server apache work - Tcl/Tk work - mod_auth_pgsql work - ...
    Lise chhayLise chhay
    Jun 3, 2004 at 11:01 am
    Jun 22, 2004 at 1:27 am
  • Hi, we are running the CanIt mailscanner on some machine. (See http://www.canit.ca .) This application is based on postgresql. However, we frequently observe the following message in the log files: ...
    Jochen WiedmannJochen Wiedmann
    Jun 16, 2004 at 8:13 pm
    Jun 21, 2004 at 10:53 am
  • Hi, I've an application running on RedHat Linux and we are using Postgres as our DB. Initially the DB was running perfectly but due to some requirement we stopped the DB with " pg_ctl stop -m 'fast' ...
    Siddharth Rath (sirath)Siddharth Rath (sirath)
    Jun 4, 2004 at 2:21 am
    Jun 4, 2004 at 6:10 am
  • Hi! I'm looking for a command or method to find out what queries are currently being serviced by the database. Once in a while a query goes berzerk and uses up all CPU. I'd like to find out which ...
    P.A.M. van DamP.A.M. van Dam
    Jun 23, 2004 at 9:36 pm
    Jul 6, 2004 at 2:28 am
  • I have posted this and similar questions repeatedly and can't even raise a single response. I am being led to believe that this then 'Must be a stupid question' although people say that there is no ...
    Adam SmithAdam Smith
    Jun 21, 2004 at 3:12 am
    Jul 4, 2004 at 8:57 am
  • Could I ask for feedback on the error messages used with the archiver and restore functionality? Possibly those of you with a hand in the Error Message style guide? The messages need the eye of some ...
    Simon RiggsSimon Riggs
    Jun 29, 2004 at 8:39 pm
    Jun 30, 2004 at 7:27 pm
  • Hi, We have a very big db that was not vacuumed for a long time. We started vacuum 3 days ago and it has not finished yet. There are some urgent processes that have to be run against the db. Is it ...
    Werner BohlWerner Bohl
    Jun 29, 2004 at 5:09 pm
    Jun 30, 2004 at 2:41 am
  • Hi, does anyone know if binary versions or at least the source rpm are going to be produced for the latest release 7.4.3? Thanks in advance Donald Fraser
    Donald FraserDonald Fraser
    Jun 29, 2004 at 11:30 am
    Jun 29, 2004 at 4:50 pm
  • I am using the /contrib/start-scripts/linux file to set up postgres to automatically restart upon reboot. I set it up /etc/init.d/postgres which calls pg_ctl pg_ctl invokes postmaster where do I set ...
    Jeff StoutJeff Stout
    Jun 28, 2004 at 9:07 pm
    Jun 28, 2004 at 9:57 pm
  • On 7.4.2, I am trying to drop a table using the command drop table vm_message cascade; and I get the error message relation "vm_message" has rel_triggers = 0 and the table is not dropped. What does ...
    Chris White (cjwhite)Chris White (cjwhite)
    Jun 23, 2004 at 7:29 pm
    Jun 23, 2004 at 9:14 pm
  • On searching the archives I noticed Bob Smith in Jul, 2002 had a similar problem to mine, but never posted a solution. I'm using pgsql 7.4.2 on Mac OS 10.3.4. I installed the startup script for ...
    Randall PerryRandall Perry
    Jun 7, 2004 at 2:28 pm
    Jun 13, 2004 at 12:19 am
  • I'm new to pgsql. I'm trying to install sql-ledger featured in Linux Journal The install instructions saay to create the db admin account by: bash$ createuser -D sql-ledger This returns this error: ...
    Dan ThompsonDan Thompson
    Jun 6, 2004 at 5:04 am
    Jun 9, 2004 at 1:52 am
  • How can i determine which directory contains the database files? there are a few databases. I though of doing that, but didnt know how to tell which directory belongs with which database. thanks ...
    Ian LipskyIan Lipsky
    Jun 1, 2004 at 12:49 am
    Jun 5, 2004 at 12:17 am
  • I'm new to postgresql, first of all, and I'm not sure if this is the correct list.... I have built 7.4.2 on Solaris 8/SPARC. I *think* "make install" generated all the expected artifacts. When I run ...
    David ParkerDavid Parker
    Jun 1, 2004 at 3:35 pm
    Jun 1, 2004 at 7:27 pm
  • After a crash of the (frozen) system, postgreSQL issues a message: 2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia 2004-06-30 17:51:39 [3165] ERROR: could not access ...
    Sandro DentellaSandro Dentella
    Jun 30, 2004 at 3:59 pm
    Jul 1, 2004 at 11:39 pm
  • Hi All - We are reviewing possible database and operating solutions for our company and we are looking at running PostgreSQL on Linux. Does PostgreSQL have the capability to handle the following ...
    Jeff KellerJeff Keller
    Jun 16, 2004 at 6:27 pm
    Jun 29, 2004 at 9:44 pm
  • A while back, there was a thread on this list called "pg_restore problem with 7.3.1". It outlined a scenario very similar to one I'm having problems with. Granted, they're not serious problems (in ...
    Thomas F. O'ConnellThomas F. O'Connell
    Jun 21, 2004 at 10:12 pm
    Jun 29, 2004 at 4:57 pm
  • I'm setting my PostgreSQL server to demand md5 encrypted passwords from users. In my C programs (using libpq as the interface), it's no big deal to pass the password through PQconnectdb. However, ...
    Tony ReinaTony Reina
    Jun 27, 2004 at 5:14 pm
    Jun 28, 2004 at 5:22 pm
  • Thank you at all for yours request Hey, i have a question about of the uses the joins in PostgreSQL. In SQL Server the joins i can use with the simbol(*), Example:. the right join is "table1.field1 ...
    Jhonatas M. RodríguezJhonatas M. Rodríguez
    Jun 25, 2004 at 9:56 pm
    Jun 26, 2004 at 4:55 am
  • Hi all, After a severe HD crash and the impossibility to read old DAT with our new DAT drive, I've been able to copy $PGDATA/base/mabase on a new HD. I've found all the tables data, and even the java ...
    Bruno THOMASBruno THOMAS
    Jun 17, 2004 at 12:10 pm
    Jun 22, 2004 at 5:44 pm
  • Hi, The harddrive on which i had linked pg_xlog has been lost. I have all other folders except that which are in a seperate drive are present. Can i get my data back using pg_resetxlog ? Any Help ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Jun 15, 2004 at 10:15 am
    Jun 15, 2004 at 11:31 pm
  • Hello *, after a harddisk filling up to a 100% the database crashed. This is the output I get when I try to start the DB again. Is there any chance to get it back running without using a dump ? ...
    Andreas SchmitzAndreas Schmitz
    Jun 11, 2004 at 11:47 am
    Jun 14, 2004 at 12:25 pm
  • We have a database that we manage through Webmin and today, the entires for the databases dissappeared from webmin. Going in through psql we could see our data in tables still intact, and have a copy ...
    Curtis KlumasCurtis Klumas
    Jun 9, 2004 at 1:09 am
    Jun 11, 2004 at 9:35 pm
  • Hi, My application uses several database tables on Postgres backend and either a postgres or an ODBC front-end. I need to calculate the total hard disk space occupied by the database for my ...
    AkuppachiAkuppachi
    Jun 10, 2004 at 10:27 am
    Jun 11, 2004 at 4:24 pm
  • I executed the script inst/creer-base, the script run, because when I did : $ psql auth auth=# \dt List of relations Schema | name | Type | Owner ------------------------------------------------- ...
    Lise chhayLise chhay
    Jun 10, 2004 at 8:55 am
    Jun 10, 2004 at 3:42 pm
  • I am new to Postgresql and am having problems getting functions working. I have been following an example in the book "PostgreSQL" by Douglas & Douglas Published by Developers Library. I put the code ...
    Tuttle, GeneTuttle, Gene
    Jun 29, 2004 at 8:52 pm
    Jun 30, 2004 at 4:04 pm
  • Hi All, I do have a database which was created with the encoding SQL_ASCII and used with German, French and Italien strings. Until recently there was only a Linux client, an all worked fine (Suse ...
    Ivo RossacherIvo Rossacher
    Jun 28, 2004 at 9:38 pm
    Jun 29, 2004 at 4:16 pm
  • Hi I'm getting an error with pg_dump: I'm using pg_dump -v -C -U username database ./dumpfile.dmp and it errors with: pg_dump: saving database definition pg_dump: reading namespaces pg_dump: reading ...
    Nigel BishopNigel Bishop
    Jun 29, 2004 at 9:38 am
    Jun 29, 2004 at 2:16 pm
  • Hi all, I install cygwin in my windows2000 so as to install postgresql. When I use the postgresql installed together with cygwin, I came into this problem: First, I run ipc-daemon2 & Second, when I ...
    HarryHarry
    Jun 16, 2004 at 12:11 pm
    Jun 29, 2004 at 7:44 am
  • I would like to know if space disk is free to the Operational System during a standard vacuum (without the full option)? I found in section "21.1.1 Recovering disk space" of Postgresql 7.4.2 manual ...
    Carlos BenkendorfCarlos Benkendorf
    Jun 25, 2004 at 4:42 pm
    Jun 25, 2004 at 5:35 pm
  • Hi All, We have postgresql running in mac. I found whatever db objects i create from the sql prompt results in lowercase. Can anyone tell me why it is happening.? does postgres stores the db objects ...
    HemapriyaHemapriya
    Jun 24, 2004 at 2:14 pm
    Jun 24, 2004 at 3:22 pm
  • Hello Everybody?... Hey, i have a question about of the uses the joins in PostgreSQL. In SQL Server the joins i can use with the simbol(*), Example:. the right join is "field1=*field2" In Oracle the ...
    Jhonatas M. RodríguezJhonatas M. Rodríguez
    Jun 23, 2004 at 4:11 pm
    Jun 23, 2004 at 5:24 pm
  • Hi All, I have found that there are some foreign keys in our detail tables while there are not primary keys in master tables. Yes, we have FK constraints on detail tables. I could not think how it ...
    Lee WuLee Wu
    Jun 18, 2004 at 10:51 pm
    Jun 21, 2004 at 6:55 pm
  • Hello, I am trying to save a directory name on the Postgres, but it is "cutting" some characters, and the result is being diferent, and then, my app don't work properly. Example: I am trying to save ...
    Eduardo S. FontanettiEduardo S. Fontanetti
    Jun 21, 2004 at 1:04 pm
    Jun 21, 2004 at 1:26 pm
  • Hello, Do you know a good postgresql database schema generator ? Does not have to be free or open source. Thanks !!!
    Frederic MederyFrederic Medery
    Jun 20, 2004 at 3:28 pm
    Jun 20, 2004 at 10:42 pm
  • 2

    hi.

    Hi, I am trying install the postgresql-7.4.3 simple installation. I did ./configure command at the postgresql directory source. While the configuring proccess I receiving the follow message: checking ...
    Janio Rosa da SilvaJanio Rosa da Silva
    Jun 20, 2004 at 4:33 pm
    Jun 20, 2004 at 7:29 pm
  • Hello! My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a connection from my PC to the server, using pgAdminIII, I get the message above. This is my pg_hba.conf file: local ...
    Sandro Ribeiro - Claro RS -Sandro Ribeiro - Claro RS -
    Jun 16, 2004 at 4:43 pm
    Jun 20, 2004 at 1:04 pm
  • Hi, I have two questions regarding the PG doc: 1. http://www.postgresql.org/docs/7.3/static/routine-vacuuming.html#VACUUM- FOR-WRAPAROUND says: "every table in the database must be vacuumed at least ...
    Lee WuLee Wu
    Jun 18, 2004 at 8:08 pm
    Jun 18, 2004 at 10:56 pm
Jun 2004
123
Group Navigation
period‹ prev | Jun 2004 | next ›
Group Overview
grouppgsql-admin @
categoriespostgresql
discussions132
posts418
users159
websitepostgresql.org
irc#postgresql

159 users for June 2004

Tom Lane: 71 posts Lee Wu: 18 posts Lise chhay: 12 posts Rajesh Kumar Mallah: 9 posts Scott Marlowe: 9 posts Jim Seymour: 8 posts C. Bensend: 7 posts Peter Eisentraut: 7 posts Siddharth Rath (sirath): 7 posts Bruno Wolff III: 6 posts Eduardo S. Fontanetti: 6 posts Gaetano Mendola: 6 posts Juanmime: 5 posts Adam Smith: 5 posts Grega Bremec: 5 posts Stephan Szabo: 5 posts V i s h a l Kashyap @ [Sai Hertz And Control Systems]: 5 posts Andrew Biagioni: 4 posts Bender, Cheryl: 4 posts Chris White (cjwhite): 4 posts
show more
Archives