[ADMIN] Pre-Allocate tablespace on disk

is be done with PG at all? If not, is this planned for any time in the future? best regards, chris -- chris ruprecht database grunt and bit pusher extraordinaíre  -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

Re: [ADMIN] MacOS X 10.5.1 and compiling for multiple Architectures

rld anyway, there is no real need to do that, except if there are major issues with PG 64-bit under OS X. So far, it's still up and running. best regards, chris -- chris ruprecht network grunt and bit pusher extraordinaíre On Jan 3, 2008, at 14:09, Shane Ambler wrote: Chris Ruprecht

Re: [ADMIN] MacOS X 10.5.1 and compiling for multiple Architectures

, to go and give the completely built libphp5.so module to somebody and say 'here, run it' regardless of what his hardware architecture supports. best regards, chris -- chris ruprecht network grunt and bit pusher extraordinaíre On Jan 3, 2008, at 00:41, Tom Lane wrote: Ch

[ADMIN] MacOS X 10.5.1 and compiling for multiple Architectures

ues[i], att[i]->attlen); I have checked this using 8.2.5 as well, with the same results (except that the errors are on different line numbers, but in the same file, using the same function and arguments). Any help is appreciated. best regards, chris -- chris ruprecht network grunt and

Re: [ADMIN] How to do fast, reliable backups?

o be kept on a drive, different from the DB. In case the DB drive crashes, you can recover from your last backup and then roll forward the after image log. Is there any slight possibility, some mechanism can make it into Progresql at some stage (maybe version 8)? Best regards, Chris -- Chri

[ADMIN] How to do fast, reliable backups?

Hi all, I am wondering how you guys back up your databases. Say, I have a 20 GB database, data and indexes. If I run pg_dump on this, it backs up the schema and the data. When I have to restore this, I whould have to run this through psql which would then re-build the indexes after it has inser

Re: [ADMIN] Database Encryption (now required by law in Italy)

On Friday 05 March 2004 10:31, Mitch Pirtle wrote: [snip] > 1) I've never seen a quad-xeon live on a UPS for more than 90 seconds I had mine (Acer Altos G900) running for more than 10 minutes the other day, until I decied the outage would take a little longer than usual and shut everything dow

Re: [ADMIN] Postgresql 7.3 And Redhat Enterprise 3

Remi, you have to make a symbolic link to the start-up directory for the run-level you are starting up from. The /etc/rc.d/init.d directory contains all avalable start/stop scripts, regardless if they are used or not. Your /etc/inittab file shows you, which default run-level you are starting u

Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on faster HDDs

Hi all, On Monday 25 November 2002 05:43, Sander Steffann wrote: > Hi, > > > In a production environment I would always favor some > > kind of error protection. Either RAID 5 or RAID 1 > > (mirroring). A hardware RAID controller is faster than > > software RAID. > > Considering the speed of CPU's

Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on faster HDDs

raid 0 (striping) spreads the load over multiple spindels, the same way raid 5 does. but raid 5 always needs to calculate parity and write that to it's parity drive. RPM isn't that critical, a lot depends on the machine, the processor and the memory (and the spped with which the processor can g

Re: [ADMIN] Is there a utility to load data?

-(end of broadcast)--- >TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/users-lounge/docs/faq.html -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _ Do Y

Re: [ADMIN] About Redo

>My concern is REDO such as ORACLE do. >The following is our recovery method. I don't know whether it's possible >or not. [snip] -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _ Do You Yahoo!? Ge

Re: [ADMIN] Re-nameing a database?

Thanks, Tom, I will play around with it a bit. Best regards, Chris At 19:07 -0500 02/10/2002, Tom Lane wrote: >Chris Ruprecht <[EMAIL PROTECTED]> writes: >> is there an easy way to re-name a database? > >Officially, no. Unofficially, since 7.1 it should work to UPDATE th

Re: [ADMIN] user to database restriction?

> >---(end of broadcast)--- >TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/users-lounge/docs/faq.html -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _

[ADMIN] Re-nameing a database?

Hi all, is there an easy way to re-name a database? Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

[ADMIN] Problems with upgrading 7.1.3 -> 7.2

nes.schema.2:168: connection to server was lost At this point, I don't know any further. As this is my production db, I will revert back to 7.1.3 for the time being. Any input is welcome. Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre

[ADMIN] Restore Question

res dump file? Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---(end of broadcast)---

Re: [ADMIN] PG 7.2 tarball

; >---(end of broadcast)--- >TIP 6: Have you searched our list archives? > >http://archives.postgresql.org -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _ Do You Yahoo!

Re: [ADMIN] Increasing Shared Memory - on MacOS X

tem you can use "sysctl" to change the variable >"kernel.ipc.shmmax" on the fly to whatever you think makes sense. > > > -crl >-- >Chad R. Larson (CRL22)[EMAIL PROTECTED] > Eldorado Computing, Inc. 602-604-3100 > 5353 North

Re: [ADMIN] Increasing Shared Memory - on MacOS X

X SPECIFIC question, and solutions for other UNIXen don't quite apply. I checked on the web and any other available resource on this, but came up empty handed ... Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre __

[ADMIN] Increasing Shared Memory - on MacOS X

Hi guys, does anybody know how I can increase the shared memory under MacOS X? I have tried but gotten an error message, telling me that it's too much. (PostgreSQL 7.2RC1). Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordi

Re: [ADMIN] poor performance of loading data

eady with these optimizations applied. Without knowing more specifics, this is all I can recommend. Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _ Do You Yahoo!? Get your free @yahoo.com add

Re: [ADMIN] Shared Memory

Thank you guys - I have the answer and it's ticking along nicely now with 6 KB of shared memory (this is what 'top' reports). I have set the parameter in the config file to 8192, now I have to monitor if this has any impact on speed. Best regards, Chris -- Chris Ruprech

Re: [ADMIN] [Solution] PG 7.1.3 & MacOS X (10.1)

gt; > regards, tom lane > >---(end of broadcast)--- >TIP 3: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to [EMAIL PROTECTED] so that your >message can get through to the mailing

Re: [ADMIN] [Solution] PG 7.1.3 & MacOS X (10.1)

it would make a difference if I would >>format that with UFS. I have a spare 10 GB drive and I'm willing to >>put myself though 10 hours of installation vows ... any hints? >> >>Best regards, >>Chris > > >---(end of broadcast)-

Re: [ADMIN] How can I..

ds in the temp table from your calling procedure. Sorry, but there is no data type 'record' which can be used to return a records (row, tuple, etc.) in PostGreSQL at the moment. Best regards, Chris -- -- Chris Ruprecht Network grunt

[ADMIN] PG 7.1.3 & MacOS X (10.1)

put myself though 10 hours of installation vows ... any hints? Best regards, Chris -- -- Chris Ruprecht Network grunt and bit pusher extraordinaíre -- -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _ Do You Yahoo!? Get y

Re: [ADMIN] Permission Denied When i am Trying to take Backup

you should make sure, that you have 'rwx' access to the directory you're trying to send the output to. Make sure, all your postgres files under the postgres home (~postgres) as well as all directories are actually owned by postgres. If they are not, this small script can change that: cd ~postgres

Re: [ADMIN] [REPOST] Remote database questions (NFS shared access, RServ)

Sharing a DB via NFS - No - absolutely not a good idea, no matter which DB you're talking about. However, you can remote access the DB through TCP/IP sockets, the Postmaster can be configured to listen to some port (5432 is the default) and you can have remote sessions running. To R/O access a Po

[ADMIN] Reporting Tool?

Hi all,   so far, I had no need to print any reports out of my PostGreSQL database, I was able to do everything through the web. However, things change and now, I need to write an invoicing system. I have been using PL/PGSQL in the past, but it doesn't seem to have the ability to produce any

[ADMIN] updating a function

Hi all,   not sure, if this belongs into this list or in the SQL list, but, here goes:   I changed a function (some business rules changed). I did the writing of the code in one terminal window and I had another terminal window open, running in psql. after I saved the file to disk (vi :w comm

Re: [ADMIN] Memory exhausted errors

Tom, I'm running the latest 7.1.2 ;) Best regards, Chris - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Chris Ruprecht" <[EMAIL PROTECTED]> Cc: "pgadmin" <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 9:35 AM Su

[ADMIN] Memory exhausted errors

Hi all,   on a daily basis, I load records from an external source into my database. During the load, the records go through a validation process during which I have to read anywhere between 2 and 15 records from the database. The postmaster process which does this, starts out with 10 MB mem

Re: [ADMIN] Dump Schema?

Thanks all who responded, I got that working just fine ;-). I should read the manual some time ...   To my surprise, I saw my Pl/PGSQL procedures (functions) dumped there as well. Is there any way to 'encode' them so that the end user is not able to read them in clear text and (heavens forbid

[ADMIN] Dump Schema?

Hi guys,   I have a database on my production machine and I want a copy of this db (9 GB) - without the data - on a development machine (notebook with about 6 GB of space). How can I just dump the schema without the data? Is there a simple command for that?   Best regards, Chris  

[ADMIN] Vacuum

Hi fellow Postgressers   I have a relatively small database. The data itself is about 1.5GB. After I did some index value changes over the weekend, I decided that it's time to do a vacuum - the db had grown to 10 GB in size - which was just unrealistic. at 7:13 this otherwise fine morning, I

[ADMIN] Performance issues

Hi all, I have a table with +/- 5.5 million records. There is a column (field) which has the default value of a sequence. The records get dumped to postgresql from another database, about 50'000 records at a time, once a day. I read these records in using the 'load' feature. Today, I decided to

[ADMIN] data/base file structure

Hi all,   can somebody explain to me, or point to an explanation of, the way, PostGreSQL names databases?I have files like 18732 and 7503034 - and they are big but I have no idea which data lives in what file:   /home/pgsql/data/base/18720/ -rw---    1 postgres postgres 70385664 May 24 1

[ADMIN] Database over multiple drives

Hi all, Can I spread a database over multiple physical drives? I want to put temp files somewhere, some tables somewhere, some other tables somewhere else etc. Is this possible? Why? My db is growing at an enormous rate, last month, it didn't exist, now it's 530 MB - and that's just one client, w

[ADMIN] Recompiling Non-PostGres apps when upgrading PostGreSQL

Hi all,   In the past, I have rebuilt all my "dependant" binaries, every time I installed a new version of Postgres. "Other binaries" means php, ssl and apache. However, I'm wondering if I really have to do that if nothing in the API changes. I know, it might be safe to do it anyway - just in