FAQ

PostgreSQL > pgsql-admin > April 2005

Search Discussions

123 discussions - 408 posts

  • Hello Everybody! I´m trying to use delete to remove data from one table based on another. The query is this: DELETE FROM table1 WHERE column1 IN (SELECT column2 FROM table2); but my table is big, so ...
    Ricardo Valença de AssisRicardo Valença de Assis
    Apr 6, 2005 at 4:45 pm
    Apr 23, 2005 at 11:53 pm
  • LS, is there a way of securing the postgresql-server against brute force password cracking ? iow: is there a way of setting eg a maximum number of login attempts, or using a time-out or ..? + ...
    Wim BertelsWim Bertels
    Apr 14, 2005 at 11:46 am
    May 12, 2005 at 12:48 pm
  • I need some help, I am doing initial investigation into the next project. Part of the project is to upgrade from RH 2.1 to 3.0 (or greater) and to upgrade from Postgresql 7.3.4 to a newer version. ...
    Chris HooverChris Hoover
    Apr 13, 2005 at 4:13 pm
    Apr 16, 2005 at 1:39 pm
  • I have a near-real-time system writing into a Postgres 7.4.2 database on the order of 340 million rows per day in about 300 million transactions. So we quickly bump up against the XID wrap-around ...
    Ian WestmacottIan Westmacott
    Apr 5, 2005 at 4:08 am
    Apr 5, 2005 at 7:35 pm
  • Hi Everybody, Postgres log rotation doesnt seem to behave properly, below are the settings which I used for log rotation. I want the postgres log to be rotated every week , its past over a week now ...
    Pallav KalvaPallav Kalva
    Apr 18, 2005 at 7:24 pm
    Apr 19, 2005 at 3:36 pm
  • UNSUSCRIBE ---------------------------------------------------- Internet to skuteczna metoda poszukiwania pracy! Zajrzyj do serwisu Praca.wp.pl - Mamy dla Ciebie setki nowych ogłoszeń każdego dnia! ...
    Piotr KabathPiotr Kabath
    Apr 14, 2005 at 6:37 am
    Feb 10, 2006 at 3:14 pm
  • unsubscribe
    Arcane_RhinoArcane_Rhino
    Apr 12, 2005 at 8:08 pm
    Apr 28, 2005 at 5:38 pm
  • Hi guys i have a following query: SELECT nspname as schema, relname as objeto FROM pg_class bc, pg_attribute ta, pg_namespace ns, pg_type ty WHERE ta.attrelid = bc.oid and ta.attnum 0 and not ...
    Mario Soto CordonesMario Soto Cordones
    Apr 27, 2005 at 6:02 pm
    Apr 27, 2005 at 8:41 pm
  • Hi, I make a dump from a database in cygwin in Windows to PG 7.3 in linux Red Hat 9. But I have a problem with 'order by'. The query is 'select prodes from es002 where prodes like 'TELHA%' order by ...
    Reuly Bússolo MendesReuly Bússolo Mendes
    Apr 11, 2005 at 1:13 pm
    Apr 12, 2005 at 2:54 pm
  • I was talking to someone just recently who was saying that they were thinking about going with Oracle rather than Postgresql because Oracle has a their story in place about how to do disk encryption. ...
    Joseph BrennerJoseph Brenner
    Apr 1, 2005 at 9:43 pm
    Apr 3, 2005 at 1:43 am
  • Hi! (Hope this is the right place to post) I crashed the postmaster and cannot start it anymore, with the error LOG: database system was interrupted while in recovery at 2005-04-01 11:04:33 CEST ...
    L.BoldarevaL.Boldareva
    Apr 1, 2005 at 10:02 am
    Apr 1, 2005 at 4:19 pm
  • Hello list, there is migrate to postgreSQL 8.0. and I have begun to have some errors, before had the 7.4.5: For example I have the following function: CREATE OR REPLACE FUNCTION ...
    Mario Soto CordonesMario Soto Cordones
    Apr 26, 2005 at 6:32 pm
    Apr 26, 2005 at 9:05 pm
  • hi, which is the sentence to run a Database REINDEX from linux or from script or shell,etc. Thanks. Fabio Barón S. DBA, Plataforma Tecnologica Gerencia Corporativa de Tecnologia Tel : 4-37-61-61 Ext. ...
    FbaronFbaron
    Apr 22, 2005 at 4:04 pm
    Apr 22, 2005 at 5:03 pm
  • hello all, i work in an organization that has a handful of people accessing a few ms access database files. i'm strongly considering porting everything to postgre (as the backend for access) for a ...
    Alex ZendelAlex Zendel
    Apr 12, 2005 at 1:47 pm
    Apr 18, 2005 at 5:06 pm
  • I have problem using initlocation on my debian-server I have a debian server and a postgresql 7.4 on it. When I try to set up a new alternative location on it, I got some problem first I do not know ...
    ListaLista
    Apr 4, 2005 at 4:07 pm
    Apr 12, 2005 at 9:07 am
  • Hello, Iam trying to take a dump of my DB from one machine to another in this fashion: on the secondary database: pg_dump -b -h 172.16.1.20 (dbname) /tmp/dump.dump my error is : could not connect to ...
    Askar ZaidiAskar Zaidi
    Apr 8, 2005 at 1:27 pm
    Apr 11, 2005 at 10:17 am
  • For several weeks now we have been experiencing fairly severe database corruption upon clean reboot. It is very repeatable, and the corruption is of the following forms: ERROR: could not access ...
    Ian WestmacottIan Westmacott
    Apr 15, 2005 at 8:55 pm
    Apr 18, 2005 at 1:43 am
  • I am writing a program to backup Postgres 8.0 installed on windows via Visual Basic. Is there an easy way to find out where a the PostgreSQL bin files are located so I can get the pg_dump and ...
    David A. LeedomDavid A. Leedom
    Apr 8, 2005 at 6:09 pm
    Apr 10, 2005 at 7:52 pm
  • It is generally not recommended that you kill processes with anything stronger than HUP, which is (I believe) what kill sends by default. Stronger signals will cause all backends to kill themselves ...
    Thomas F.O'ConnellThomas F.O'Connell
    Apr 23, 2005 at 3:58 pm
    Apr 23, 2005 at 8:44 pm
  • I have a postgres installation with one database on a server. I'd need to create another database; however, I'm curious if there's a way to create the second database in a different directory than ...
    Tomeh, HusamTomeh, Husam
    Apr 22, 2005 at 4:53 pm
    Apr 22, 2005 at 8:12 pm
  • Hi all, Does any one know why I have following inconsistant results from PostgreSQL? Thanks in advance. test=# select birthday from patient; birthday ------------ 1960-02-01 1960-02-01 (2 rows) ...
    Zuoxin WangZuoxin Wang
    Apr 19, 2005 at 8:35 pm
    Apr 19, 2005 at 9:08 pm
  • Greetings, I am running Postgresql 8.0 on "Linux xxx 2.4.18-14 #1 Wed Sep 4 12:13:11 EDT 2002 i686 athlon i386 GNU/Linux" and while loading data my program received: DBD::Pg::db do failed: server ...
    SimpsonSimpson
    Apr 17, 2005 at 5:26 pm
    Apr 18, 2005 at 5:34 pm
  • Hi, I am running Postgres 7.4.5 and am storing binary objects in the largeobject table. We want to keep the size of the database and especially the large object table to a minimum, so we vacuum it ...
    Chris White (cjwhite)Chris White (cjwhite)
    Apr 1, 2005 at 7:40 pm
    Apr 1, 2005 at 10:21 pm
  • Hello to everyone, I'm new to postgres. I Have installed a new SuSE 9.2 on a pc. I also installed the Postgres which was on the suse-cd's. psql --version says: 7.4.7 PG_VERSION in /var/lib/psql/data ...
    Bernd LentesBernd Lentes
    Apr 25, 2005 at 8:35 am
    May 11, 2005 at 10:13 pm
  • Greetings, Running /etc/init.d/postgresql stop results in: Stopping postgresql service: [FAILED] I ran an strace on "/usr/local/pgsql/bin/pg_ctl stop -D /data/pgsql/data -s -m fast" and it is sending ...
    SimpsonSimpson
    Apr 24, 2005 at 12:53 pm
    Apr 25, 2005 at 3:08 pm
  • Hi all. I'm running 7.4, and I recently did a few upgrades, which seem to have broken it. I believe that all of them were php updates. Anywho, my service configuration shows that postmaster is ...
    Bobb ShieldsBobb Shields
    Apr 19, 2005 at 6:11 pm
    Apr 21, 2005 at 2:39 pm
  • Hi folks, we've got an quite large table with 17 columns and now 15k rows. The table works also as an journal will continously grow day by day. Man of the columns (mostly text) aren't needed anymore ...
    Enrico WeigeltEnrico Weigelt
    Apr 15, 2005 at 2:22 pm
    Apr 21, 2005 at 4:10 am
  • Hy all ! Is there any tool, middelware, or feature to syncronize 2 databases (With the same schema, ofcourse) I have an application that runs from 2 points. One of this points has a master database ...
    ShadowShadow
    Apr 20, 2005 at 4:33 pm
    Apr 20, 2005 at 6:50 pm
  • Hello... Postgres 8.0.1 is running on Debian with 2.6.10 kernel with 12GB of RAM, where 2GB is for shared memory: echo 2147483648 /proc/sys/kernel/shmall echo 2147483648 /proc/sys/kernel/shmmax Also ...
    Marcin GiedzMarcin Giedz
    Apr 15, 2005 at 1:05 pm
    Apr 18, 2005 at 2:38 pm
  • i am having poor performance with postgres 8.0.0 the config of my machine is: single xeon 3.4 Ghz, 1GB of memory, two IDE drives mounted using LVM and JFS file system on Suse 9.2 professional. What I ...
    Sanjay tumulaSanjay tumula
    Apr 12, 2005 at 5:05 pm
    Apr 17, 2005 at 5:54 am
  • Hi to all, I have to do a database replication (of corse pgsql database) and I never done something like this. I still read about ... what replication is. Can anyone send me some directions, ...
    Andrei BintintanAndrei Bintintan
    Apr 12, 2005 at 6:48 am
    Apr 14, 2005 at 9:33 am
  • Hi, The developers on my company reports me a problem with de upper() function. The problem is: - with a text 'magriñá' - the upper('magriñá') returns MAGRIñà - NOTE that the characters 'ñ' and 'á' ...
    Lic. Guillermo GonzálezLic. Guillermo González
    Apr 12, 2005 at 1:22 pm
    Apr 13, 2005 at 4:02 pm
  • I have a legacy system that has been developed with a mysql backend. I'm in the process of converting it over to postgres. As postgres is case sensitive it appears as I will have to make numerous ...
    Theo GalanakisTheo Galanakis
    Apr 11, 2005 at 6:27 am
    Apr 12, 2005 at 12:25 am
  • Hello, I have a quesion - suppose I have sparc box and x86 box running same release of postgresql compiled with same options. Can I simply copy database directory between hosts (of course when ...
    Vlad HarchevVlad Harchev
    Apr 9, 2005 at 4:38 pm
    Apr 10, 2005 at 10:16 am
  • Dear all, I have a postgresql database. "du -ks /var/lib/pgsql/data" gives me the following disk usage 45592808 /var/lib/pgsql/data (about 44G) But after I did a pg_dump, the dump file only has the ...
    Chuming ChenChuming Chen
    Apr 4, 2005 at 1:27 pm
    Apr 4, 2005 at 2:52 pm
  • Since I could not locate anything similar on the net, I have written a script to automatically start and stop the autovacuum daemon. This should be added to the existing postgresql script. Please let ...
    Theo GalanakisTheo Galanakis
    Apr 11, 2005 at 3:20 am
    Jan 11, 2006 at 1:32 pm
  • I found a table pg_version_history in the public schema (which we don't use). Does anyone know where this table comes from and what is it for? Also I'd like to implement a code versioning for the ...
    Ezequiel TolnayEzequiel Tolnay
    Apr 26, 2005 at 2:09 am
    May 7, 2005 at 4:22 am
  • Hi, I have an error trying to drop an index using PostgreSQL 7.4.6 running on Solaris 2.9. The table on which the index was built is no longer present (it should have been dropped by my application ...
    Oliver Duke-WilliamsOliver Duke-Williams
    Apr 26, 2005 at 12:13 pm
    May 3, 2005 at 11:03 am
  • Hi, This might be a stupid question as it is not covered in the 7.4.7 and probably obvious to all others. Where do the system catalogs live? How to back them up? Should I back them up? The admin ...
    Mauri SahlbergMauri Sahlberg
    Apr 30, 2005 at 8:16 am
    Apr 30, 2005 at 4:27 pm
  • Hi , I got this error while doing my online backups on the new postgres 8.0.2. I follow the same procedure as mentioned in the docs and the way i do in brief is 1) Put the database in backup mode ...
    Pallav KalvaPallav Kalva
    Apr 29, 2005 at 2:22 pm
    Apr 29, 2005 at 5:04 pm
  • Hi, Problem environment: Database-server: - Fedora Core 1 under virtuozzo virtual server running on Fujitsu-siemens hardware - Kernel: Linux claymountain.planeetta.com ...
    Mauri SahlbergMauri Sahlberg
    Apr 28, 2005 at 6:27 am
    Apr 29, 2005 at 6:38 am
  • Hello, I am using postgreSQL 8.0.2 I configured the database, started postmaster. It is running well. I can check and see it with ps anx command. I am running postgreSQL on centos 3.4 and Centos 4.0 ...
    Vaneet SharmaVaneet Sharma
    Apr 27, 2005 at 4:50 pm
    Apr 27, 2005 at 5:43 pm
  • Hi folks, we've got a larger project with several subsystems, which should run in their own security context / users. Most of the database access works over views and functions. For functions its ...
    Enrico WeigeltEnrico Weigelt
    Apr 27, 2005 at 3:52 pm
    Apr 27, 2005 at 5:28 pm
  • Hiii alll, I would like to ask, does pl/sql in oracle is same with the pl/sql in postgreSQL Thank You Dedy Styawan Semarang - Central Java Indonesia . |L /| . . |\ _| \--+._/| . / ||\| Y J ) / |/| ./ ...
    DedyDedy
    Apr 25, 2005 at 4:20 am
    Apr 25, 2005 at 2:04 pm
  • I have a question to configuration of PostgreSQL 7.3 If in var/lib/pgsql/data/postgresql.conf the variable autocommit is set to true, I cannot work with transactions, because all is commited ...
    Manfred RebentischManfred Rebentisch
    Apr 20, 2005 at 8:38 am
    Apr 23, 2005 at 7:09 pm
  • contrib is a directory? where is it? Fabio Barón S. DBA, Plataforma Tecnologica Gerencia Corporativa de Tecnologia Tel : 4-37-61-61 Ext. 5123 Cel : 311 2-54-74-00 Aviso de confidencialidad: Este ...
    FbaronFbaron
    Apr 22, 2005 at 3:01 pm
    Apr 23, 2005 at 3:30 pm
  • Hi all you pg gurus and admins, I'm trying to implement versioning of the code of objects that can be "created or replaced" (functions, views, etc). I tried to implement a trigger on pg_proc, but ...
    Ezequiel TolnayEzequiel Tolnay
    Apr 20, 2005 at 3:37 am
    Apr 23, 2005 at 5:06 am
  • I'd like to check field names for various tables in our code. Is there a system table that lists the field names of each table? ...some way to query this information to run an error check? Thanks ...
    Jodi KanterJodi Kanter
    Apr 21, 2005 at 6:38 pm
    Apr 23, 2005 at 4:30 am
  • hi, i'm using postgres version 7.4.1 and it run very stable until, may be, 4 weeks ago. now the postmaster hangs sometimes for a while (actually since 2 hours) and doesn't accept connections but ...
    Rolf StaegeRolf Staege
    Apr 19, 2005 at 2:39 pm
    Apr 19, 2005 at 3:58 pm
  • Hello, We have an client who has postgres 7.1.2 database on our old server. We recently bought a new server and installed Fedora Core 2. Is it still possible to upgrade the pg7.1.2 database to pg7.4? ...
    Sherwin ChuaSherwin Chua
    Apr 14, 2005 at 3:32 am
    Apr 19, 2005 at 3:19 pm
Apr 2005
123
Group Navigation
period‹ prev | Apr 2005 | next ›
Group Overview
grouppgsql-admin @
categoriespostgresql
discussions123
posts408
users142
websitepostgresql.org
irc#postgresql

142 users for April 2005

Tom Lane: 45 posts Michael Fuhr: 14 posts Bruce Momjian: 13 posts Jim C. Nasby: 13 posts Bruno Wolff III: 12 posts Scott Marlowe: 11 posts Ian Westmacott: 10 posts Pallav Kalva: 9 posts Chris Browne: 8 posts Mario Soto Cordones: 8 posts Alvaro Herrera: 7 posts John DeSoi: 7 posts Thomas F.O'Connell: 7 posts Marcin Giedz: 6 posts Fbaron: 5 posts Chris Hoover: 5 posts Dextra - Gustavo Bartz Guedes: 5 posts Joel Fradkin: 5 posts Joshua D. Drake: 5 posts Ricardo Valença de Assis: 5 posts
show more
Archives