Re: [ADMIN] Re: [GENERAL] I screwed it up, my installation :(

2000-08-18 Thread Mitch Vincent
Download and install it from source, it takes about 5 minutes and it's _absolutely_ worth it.. -Mitch - Original Message - From: "AlphaByte" <[EMAIL PROTECTED]> To: "pgsql list - admin" <[EMAIL PROTECTED]>; "pgsql list - general" <[EMAIL PROTECTED]> Sent: Friday, August 18, 2000 3:54 PM

[ADMIN] Postgres Problem

2000-08-18 Thread Nataraj
Hi, I am using postgres 7.0.2 in a web application with Perl and CGI. I had created a database for the web application. I had to modify the database by adding few new tables. I created the new tables using the "create table" command. When I query the database for the data in the new tables from t

Re: ODP: [ADMIN] I screwed it up, my installation :(

2000-08-18 Thread AlphaByte
Thanks for the suggestion but the installation had updated the start up script to read version 7.0, however the other RPMs were not upgraded and were still 6.5. It all became clear when I actually read the script. I had to reinstall from the CD, so all done now :0) Of course if I had read the RE

Re: [ADMIN] Re: [GENERAL] I screwed it up, my installation :(

2000-08-18 Thread AlphaByte
Thanks John, I tried your suggestion but it made no difference, and whilst I wiped the egg off my face I reinstalled from the 6.5 CD after uninstalling 7.0 as root. So its all happy now. I guess with my current configuration it ain't gonna work under RedHat 6.1, but I am going to wait till a pro

Re: [ADMIN] I screwed it up, my installation :(

2000-08-18 Thread Lamar Owen
AlphaByte wrote: > Checking postgresql installation: old version. Need to > Upgrade.See /usr/doc/postgresql-7.0/README.rpm for more > information. > So please help me, I am desperate. Did you read the upgrade instructions in /usr/doc/postgresql-7.0.2/README.rpm, by chance? After you have read

[ADMIN] Authenticating some users and trusting others

2000-08-18 Thread Lio Test
Hi, I want to avoid that someone could authenticate as root user on my databases. For this, I would like to apply "trust" access mode mixed with auth by password for other users. In this case, someone would have first to gain root privileges on my Linux system to access PG as root. Is it possibl

ODP: [ADMIN] I screwed it up, my installation :(

2000-08-18 Thread Rybarczyk Mikolaj
I am not sure but maybe this is a simple problem with the PostgreSQL start-up script. The script is /etc/rc.d/init.d/postgresql. There is version checking in it, find line: if [ `cat /var/lib/pgsql/PG_VERSION` != '6.5' ] or something like that (it depends of your instalation). Then find

[ADMIN] Re: [GENERAL] I screwed it up, my installation :(

2000-08-18 Thread John Clark L. Naldoza
Hello Alan, >From /usr/doc/postgresql-7.0.2/README.rpm it says...;-) NOTE: The 7.0 RPMs are only being built under RedHat 6.2! They may or may not work under RedHat 6.0 or 6.1. But like you, I have come across the exact same thing...;-) _IF_ you don't have any real data and are willing to sta