[ADMIN] Starting the database server

Hi all, I try to start PostgreSQL, but it doesn't work. I installed it successfully and now I try to launch the server. This is what I did: 1. Set the path $ set path = ( /usr/local/pgsql/bin $path ) 2. Create the cluster $ initdb -D /usr/local/pgsql/data 3. Start the database server $

Re: [ADMIN] Child itemid in update-chain marked as unused - can't continue repair_frag

Gaetano Mendola [EMAIL PROTECTED] writes: what this mean and what I should do for it ? You can ignore it. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives?

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

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 and busses these days, software RAID can be a lot faster than hardware RAID in

[ADMIN] ALLOW_ABSOLUTE_DBPATHS

In the following snippet from ./src/backend/commands/dbcommands.c, I cannot see anywhere in the configuration where ALLOW_ABSOLUTE_DBPATHS gets set, and why this wouldn't be the default anyway. I was creating databases fine, but it is possible that I exported PGDATA2, and used this, as I see

[ADMIN] Another never seen message

During a vacuum I got this: Rel pg_proc: Uninitialized page 48 - fixing Should I do or watch something ? Ciao Gaetano PS. I run Postgresql 7.2.2 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Starting the database server (2)

Hi guys, I still have a problem to start the database server as I wrote in the first mail. I read many and many tutorials, but nothing is working to start the postmaster. 1. When I create the database cluster I get this message: (everything is installed correctly) Success. You can now start

Re: [ADMIN] Starting the database server (2)

Javier , are u able to su - to the user who owns the folder /usr/local/pgsql/data ? check the user,group for that folder , do a ls -l /usr/local/pgsql and post the results. regds mallah. Hi guys, I still have a problem to start the database server as I wrote in the first mail. I read

[ADMIN] pg_dump 7.3rc1 with 7.2 server.

hi, lately i realized that my new rc1 installation pg_dump had been backing up my old 7.2.1 production server. is it producing a safe backup of my server restorable thru pg_restore 7.3rc1? regds mallah. - Get your free web based email at

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

operationally, disk subsystems trump software raid for primary dataset storage: battery backed cache - safety first. portability - plug it into any other host, or more than one host on the scsi bus (fc-al loop). raid on a pci card or raid on the motherboard need not apply less they sport battery

Re: [ADMIN] enable iscii in postgres

Mukund Pate writes: how to enable iscii format in postgres? does postgres support iscii format? The list of supported character sets is shown in the Administrator's Guide, chapter Localization. Unless ISCII is really a disguised version of one of the ones listed there (which I don't think it

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 and busses

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

On Mon, Nov 25, 2002 at 11:43:56AM +0100, Sander Steffann wrote: (mirroring). A hardware RAID controller is faster than software RAID. lot faster than hardware RAID in many cases. I prefer hardware RAID myself because of the simplicity (the OS doesn't need to know about the RAID

Re: [ADMIN] Starting the database server (2)

On Tue, 26 Nov 2002, Javier Perez wrote: Hi guys, I still have a problem to start the database server as I wrote in the first mail. I read many and many tutorials, but nothing is working to start the postmaster. 1. When I create the database cluster I get this message: (everything

Re: [ADMIN] Another never seen message

This will be fixed in 7.3, due out tomorrow. It isn't something to be worried about. --- Gaetano Mendola wrote: During a vacuum I got this: Rel pg_proc: Uninitialized page 48 - fixing Should I do or watch something

Re: [ADMIN] pg_dump 7.3rc1 with 7.2 server.

I've not tested it, so I can say 100% for sure, but if I had to guess I'd say that those dumps wont work if you try to restore to 7.2.1 so you need to switch back to the proper version asap. (Things like opaque functions getting rewritten to new types come to mind) Robert Treat On Tue,

Re: [ADMIN] pg_dump 7.3rc1 with 7.2 server.

Robert Treat [EMAIL PROTECTED] writes: I've not tested it, so I can say 100% for sure, but if I had to guess I'd say that those dumps wont work if you try to restore to 7.2.1 so you need to switch back to the proper version asap. Robert's right: the output of 7.3 pg_dump will not load into

Re: [ADMIN] ALLOW_ABSOLUTE_DBPATHS

Eric Hallander [EMAIL PROTECTED] writes: In the following snippet from ./src/backend/commands/dbcommands.c, I cannot see anywhere in the configuration where ALLOW_ABSOLUTE_DBPATHS gets set, and why this wouldn't be the default anyway. I was creating databases fine, but it is possible that

Re: [ADMIN] pg_dump 7.3rc1 with 7.2 server.

Thanks very much for the responses. since 7.3 release is due soon i think i need no bother. regds mallah. On Wednesday 27 November 2002 08:54 am, you wrote: Robert Treat [EMAIL PROTECTED] writes: I've not tested it, so I can say 100% for sure, but if I had to guess I'd say that those