FAQ

PostgreSQL > pgsql-admin > March 2007

Search Discussions

59 discussions - 243 posts

  • Hello, we have one table in database (db has over 200 tables), which has one byteA filed for storing user photos. We are making backup every night, but it is now too large because of photos. We do ...
    LukasLukas
    Mar 8, 2007 at 8:02 pm
    Mar 9, 2007 at 4:58 pm
  • 8.2.3 I was hoping to not have to support client certs. I want encryption and to verify the server, but no to verify the client. Does this work and I've got the config wrong? I get ssl connections if ...
    Ray StellRay Stell
    Mar 23, 2007 at 6:16 pm
    Mar 26, 2007 at 2:00 pm
  • Hi, The PostgreSQL of a customer database (running on Windows 2003) crashed and wrote the messages below in the logfile. According to the customer the drives are working OK, partitions are not full ...
    Joost KraaijeveldJoost Kraaijeveld
    Mar 12, 2007 at 1:33 pm
    Mar 13, 2007 at 4:29 pm
  • I've got a client that has a function in a db which had been humming along quite nicely on 2xOpteron 275, PG 8.1.5, 8GB of RAM. Now suddenly many of the functions in the DB if called will spike the ...
    Jeff FrostJeff Frost
    Mar 16, 2007 at 8:53 am
    May 4, 2007 at 4:15 am
  • Hi Guys! I am trying to deploy an application together with postgresql. Therefore, i compiled postgres versions on Intel, G4 and G5. Mostly, this works perfectly. But on some machines, the ...
    Peter ElmersPeter Elmers
    Mar 26, 2007 at 2:53 pm
    Apr 11, 2007 at 2:19 pm
  • Hello, After upgrading from 8.1.6 to 8.1.8 (using Debian testing packages) I started to get a really strange error, and I have not been able to gain any insights into this from the list archives. ...
    Glen W. MabeyGlen W. Mabey
    Mar 9, 2007 at 4:06 pm
    Mar 12, 2007 at 3:03 pm
  • Hello, I had a problem in my computer system yesterday. Some data has disappeared. I was looking for a program that might have deleted it accidentally. Before I found anything, the data suddenly came ...
    Laszlo NagyLaszlo Nagy
    Mar 26, 2007 at 5:17 pm
    Apr 5, 2007 at 7:17 am
  • Hello, I'm testing my PITR recovery procedures and something doesn't look right. The following is from the logs upon starting postgres with recovery.conf file in place 2007-03-23 05:56:00 MDTLOG: ...
    Warren LittleWarren Little
    Mar 23, 2007 at 11:16 pm
    Mar 30, 2007 at 5:14 pm
  • I was following migration document http://www.postgresql.org/docs/8.2/interactive/migration.html and hit the problem I can't solve. Basically my goal is to migrate data from 8.0.3 to 8.2.3 The error ...
    Anton PikhteryevAnton Pikhteryev
    Mar 16, 2007 at 3:59 pm
    Mar 19, 2007 at 5:35 pm
  • Hi everybody, I have a problem while trying to make the dictionnary generated by gendict. I'm using postgresql 8.2.3 on macosx I get the sources on the postgresql website (not on darwinports or ...
    Laurent ThevenetLaurent Thevenet
    Mar 14, 2007 at 12:33 am
    Mar 15, 2007 at 4:21 pm
  • Pregunta
    Daniel MedinaDaniel Medina
    Mar 14, 2007 at 4:50 pm
    Mar 15, 2007 at 3:36 pm
  • Hi! I've probably missed somthing but here is my problem. I have a view that is really slow and I ca easily work around the slowness by bypassing the view and query the real table directly. Example: ...
    Rickard SjöströmRickard Sjöström
    Mar 30, 2007 at 11:49 am
    Apr 3, 2007 at 5:39 am
  • help please when I execute this query select * from pg_shadow; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig ...
    Daniel Ricardo MedinaDaniel Ricardo Medina
    Mar 25, 2007 at 2:57 am
    Mar 26, 2007 at 1:58 pm
  • dear list, I know there are already hunderts of posts about pg_hba.conf, but still after reading a few of them I still got troubles with this topic. I've got a vpn server with a ststic ip address, ...
    Moritz BayerMoritz Bayer
    Mar 5, 2007 at 11:37 pm
    Mar 6, 2007 at 8:49 am
  • Hello list, I'm trying to compile postgresql-8.2.3 on a system running debian stable with kernel 2.6.8-2-686, but compilation stops with this error: <snip gcc -O2 -Wall -Wmissing-prototypes ...
    Dieter SchickerDieter Schicker
    Mar 15, 2007 at 8:05 am
    Jun 2, 2007 at 3:28 am
  • Hi there, I try to use WAL support for backup/recovery on Windows. I applied the procedures from PostgreSQL 8.2.3 Documentation / 23.3.3. Recovering using a Continuous Archive Backup. I set the ...
    Sabin CoandaSabin Coanda
    Mar 20, 2007 at 3:28 pm
    Apr 6, 2007 at 6:21 am
  • Hello! I have to manage an application written in java which call another module written in java which uses Postgre DBMS in a Linux environment. I'm new to Postgres. The problem is that for large ...
    Sorin N. CiolofanSorin N. Ciolofan
    Mar 26, 2007 at 2:07 pm
    Mar 27, 2007 at 1:59 pm
  • CedricCedric
    Mar 16, 2007 at 3:39 pm
    Mar 22, 2007 at 2:01 pm
  • Be aware of linebreaks ... [Galadriel: cug ] cug $ psql -U postgres -c "select pg_size_pretty (pg_database_size('testdb'));" pg_size_pretty ---------------- 495 MB (1 row)
    Guido NeitzerGuido Neitzer
    Mar 21, 2007 at 5:37 pm
    Mar 21, 2007 at 10:24 pm
  • Hi, I am using postgres 8.2.3. I have recently converted my database from sql-ascii to UTF8. I have a portal which calls a perl program to insert the data into the database. While inserting, I am ...
    Karthikeyan SundaramKarthikeyan Sundaram
    Mar 20, 2007 at 7:34 pm
    Mar 21, 2007 at 5:26 pm
  • I'm getting really mad at RHEL 4. They do not package a recent postgres in the base distro, and only put 8.1.x in a disk call lamp-beta... So now I wonder what a 'recommended' way of running ...
    David BearDavid Bear
    Mar 21, 2007 at 12:54 am
    Mar 21, 2007 at 1:52 pm
  • Hi everyone. I have some encoding problems like many others. I'm using Python (and Django) with my PostgreSQL 8.2 and pgAdmin 1.6.2 on Windows XP Pro. The default encoding here in Iceland is win1252. ...
    Bjarni RagnarssonBjarni Ragnarsson
    Mar 22, 2007 at 1:07 pm
    Mar 23, 2007 at 1:20 pm
  • hi, I am new comer in this millis... i have a poblem, how to add a field/column in existing table without oids. if i create new table i can add field oids Thank alot before regrads Nyoman/bali
    Gunartha.nyomanGunartha.nyoman
    Mar 16, 2007 at 7:38 am
    Mar 20, 2007 at 1:52 am
  • I have been using postgres 8.1 for a while now with large databases (over 300-400G). The biggest issue I have faced is the routine vacuumdb command that takes care of the transaction id wraparound ...
    Sriram DandapaniSriram Dandapani
    Mar 6, 2007 at 8:02 pm
    Mar 12, 2007 at 3:07 pm
  • Hi Everybody, We are using postgres 8.1.0. I want to do some maintenance work. Hence, I want to run postgres in single user mode so that external people won't be able to access the database. How can ...
    Karthikeyan SundaramKarthikeyan Sundaram
    Mar 9, 2007 at 6:01 pm
    Mar 9, 2007 at 7:01 pm
  • PostgreSQL version 8.1.4 Linux version 2.6.19-gentoo-r5 (gcc version 4.1.1 (Gentoo 4.1.1)) I make backup with commang: pg_dump -U postgres -h /tmp -Ft -b -C mydb file.tar When I want to restore from ...
    IskIsk
    Mar 2, 2007 at 10:52 am
    Mar 5, 2007 at 10:30 am
  • Hi all, I have a server (Ubuntu 6.10 to be exact) running PostgresQL 8.1.4. On that server I have a user account, called "ynui", and I also have a postgres user called "ynui", they have the same ...
    Rob van der LindeRob van der Linde
    Mar 1, 2007 at 12:58 am
    Mar 1, 2007 at 10:14 am
  • Hi, How can I configure to auto-startup Postgres installed on Open Suse 10.1?? On other systems, just configure file start.conf to "auto". But on Suse ... Could you help me? Thank you Yahoo! Mail - ...
    Alexander B.Alexander B.
    Mar 28, 2007 at 2:25 pm
    May 8, 2007 at 6:16 pm
  • Hi, I installed on linux the dbms "PostgreSQL 8.2.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.0.2 20051125 (Red Hat 4.0.2-8)". Initially I set an empty password for the user postgres. ...
    Sabin CoandaSabin Coanda
    Mar 23, 2007 at 2:45 pm
    Mar 29, 2007 at 8:48 am
  • Hi, When and are rpms going to be released for RedHat 5? Benjamin
    Benjamin AraiBenjamin Arai
    Mar 21, 2007 at 2:33 pm
    Mar 27, 2007 at 7:08 am
  • Hello, We recently began giving our users a ten connection limit. The are some accounts that have no limit. Some of these should have no limit because they're system accounts, but others are just ...
    Carol WalterCarol Walter
    Mar 27, 2007 at 3:36 am
    Mar 27, 2007 at 4:03 am
  • I am doing a vacuum full on a table that takes up 78 GB of a 79 GB HD. When I couldn't add any more data because of out of disk space errors, I freed up space by dropping other tables in the ...
    Davidson, RobertDavidson, Robert
    Mar 22, 2007 at 2:42 am
    Mar 22, 2007 at 2:49 am
  • Hi, I'd like to create a user that has read-only access to a database. I've read the docs and fumbled around a bit (even tried to use phppgadmin) - but nothing works. "CREATE USER username" is about ...
    Morten W. PetersenMorten W. Petersen
    Mar 21, 2007 at 5:42 pm
    Mar 21, 2007 at 6:33 pm
  • Dear All, I am trying to create table which have one field auto increas value like autonumber in ms access. My question is how to create this auto increas field. Thank a lot for your attention ...
    Gunartha.nyomanGunartha.nyoman
    Mar 20, 2007 at 1:55 am
    Mar 20, 2007 at 2:28 am
  • Hi, As per this article http://people.planetpostgresql.org/greg/index.php?url=archives/96-Is-your-database-ready-for-the-Daylight-Savings-Times-change-of-2007.html&serendipity[cview]=linear#comments, ...
    Pallav KalvaPallav Kalva
    Mar 1, 2007 at 8:30 pm
    Mar 1, 2007 at 9:02 pm
  • Hi, I've been having this problem occurring a few times in the last few days : in the postgresql log, I've seen these messages : 2007-03-28 13:53:34.845 CEST,18249 LOG: SSL SYSCALL error: Broken pipe ...
    Marc CousinMarc Cousin
    Mar 28, 2007 at 1:09 pm
    Apr 2, 2007 at 9:39 am
  • Hi ADMIN, Pls exclude me from the mailing list. Regards, Subash --------------------------------- It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar.
    SUBASH CHANDRA MOHAPATRASUBASH CHANDRA MOHAPATRA
    Mar 23, 2007 at 11:30 am
    Mar 29, 2007 at 8:20 pm
  • Hi, some developers were using the database, and suddenly no one could connect. Just only some connections that was established before. As soon as I was advised, I noticed that no postgres process ...
    Alexander B.Alexander B.
    Mar 27, 2007 at 7:32 pm
    Mar 28, 2007 at 12:51 am
  • Hi Everybody, What is the difference between creating a rule and a trigger? Regards skarthi i'm making a difference. Make every IM count for the cause of your choice. Join Now. ...
    Karthikeyan SundaramKarthikeyan Sundaram
    Mar 23, 2007 at 7:03 pm
    Mar 23, 2007 at 7:45 pm
  • All, have a cluster that hit the wrap-around issue. We are trying to run the backend vacuum as describe in the manual to clear up the problem. I not sure how I should be interrupting the messages I'm ...
    Warren LittleWarren Little
    Mar 23, 2007 at 3:07 pm
    Mar 23, 2007 at 3:18 pm
  • Hi All, There are a few plpgsql functions in our application, When the functions are called, I would like to see the commands executed from the functions ( the selects, inserts, updates and Deletes ...
    Anoo PillaiAnoo Pillai
    Mar 23, 2007 at 5:15 am
    Mar 23, 2007 at 5:47 am
  • Hi guys, I know I'm out of topic, but have you ever tried using Slony with PostgreSQL 8.2x as master and PostgreSQL 7.4.x as slave? Thanks in advance, Pelle,.-
    Ezequiel Luis PellettieriEzequiel Luis Pellettieri
    Mar 22, 2007 at 3:31 pm
    Mar 22, 2007 at 7:15 pm
  • Hi there, I'd like to use WAL, but I need some clarifications about the backup/recovery procedure. In Postgresql v8.2.3 documentation, I found I have to make backup between ...
    Sabin CoandaSabin Coanda
    Mar 19, 2007 at 8:28 am
    Mar 21, 2007 at 12:01 am
  • Hi there, I set 'log_error_verbosity' to 'verbose' and I get the following message logs: 2007-03-20 11:30:11 WARNING: 22P06: nonstandard use of \\ in a string literal at character 128 2007-03-20 ...
    Sabin CoandaSabin Coanda
    Mar 20, 2007 at 12:28 pm
    Mar 20, 2007 at 3:26 pm
  • Hi everyone, I'm looking to convert a lot of data from Sybase to Postgres. As this will be a painful process, I was wondering if there are any utilities and programs to ease the conversion process. ...
    Peter KoczanPeter Koczan
    Mar 20, 2007 at 12:03 am
    Mar 20, 2007 at 3:39 am
  • Hi list, I would like to know if I set the debug mode to 2 (-l 2) in the pgAgent connection string it could spend much cpu processing. I have other things running in the server and I don't like to ...
    Ezequias Rodrigues da RochaEzequias Rodrigues da Rocha
    Mar 13, 2007 at 4:38 pm
    Mar 13, 2007 at 4:43 pm
  • Hi list, Could someone tell me what libs are packed in the rpm below ? postgresql-libs-8.2.3-1PGDG.i686.rpm We are concerned about the problem of compatibility with Oracle and we prefer to check all ...
    EzequiasEzequias
    Mar 12, 2007 at 8:37 pm
    Mar 12, 2007 at 9:03 pm
  • I get the following error when using postgreSQL 8.2.x and postgresql-8.2-504.jdbc3.jar: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. at ...
    Campbell, LanceCampbell, Lance
    Mar 8, 2007 at 4:33 pm
    Mar 8, 2007 at 5:10 pm
  • Has anyone done this? In a fatal crash where the backup only recovered the numbered directories (data dirs) of a PG installation (i.e. nothing above the numbered directories), is it possible to ...
    Bradley KieserBradley Kieser
    Mar 7, 2007 at 5:05 pm
    Mar 7, 2007 at 8:22 pm
  • Hi! We use postgreSQL 8.1.2 in Solaris 9 platform to maintain very important business data. The postgresql DB was interrupted now: LOG: could not bind socket for statistics collector: Cannot assign ...
    Roger PanRoger Pan
    Mar 5, 2007 at 6:23 pm
    Mar 6, 2007 at 4:29 am
Mar 2007
12
Group Navigation
period‹ prev | Mar 2007 | next ›
Group Overview
grouppgsql-admin @
categoriespostgresql
discussions59
posts243
users91
websitepostgresql.org
irc#postgresql

91 users for March 2007

Tom Lane: 33 posts Karthikeyan Sundaram: 12 posts Daniel Ricardo Medina: 9 posts Glen W. Mabey: 7 posts Jeff Frost: 7 posts Michael Fuhr: 6 posts Milen A. Radev: 6 posts Phillip Smith: 6 posts Sabin Coanda: 6 posts Simon Riggs: 6 posts Joost Kraaijeveld: 5 posts Alvaro Herrera: 4 posts Anton Pikhteryev: 4 posts Bjarni Ragnarsson: 4 posts Cedric: 4 posts Laurent Thevenet: 4 posts Magnus Hagander: 4 posts Ray Stell: 4 posts Achilleas Mantzios: 3 posts Alexander B.: 3 posts
show more
Archives