[ADMIN] Re: Bugs in PostgreSQL v7.1 rpms for RedHat

2001-04-19 Thread Jacopo Silva
- Original Message - From: "Lamar Owen" <[EMAIL PROTECTED]> To: "David Lizano" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 7:29 PM Subject: Re: Bugs in PostgreSQL v7.1 rpms for RedHat > Works here, for some reason. But I'll check it. I run these very RP

Re: [ADMIN] Bugs in PostgreSQL v7.1 rpms for RedHat

2001-04-19 Thread Vilson farias
[root@dgtao data]# /etc/rc.d/init.d/postgresql stop Stopping postgresql service: pg_ctl: cannot find /var/lib/pgsql/data/postmaster.pid Is postmaster running? [root@dgtao data]# Here too on my RedHat 6.2, but happens because I changed my postgres data dir to /home/postgres/data and there were a /

Re: [ADMIN] Bugs in PostgreSQL v7.1 rpms for RedHat

2001-04-19 Thread David Lizano
Ok, I have installed version 7.0.3 and 7.1 from RPM in Red Hat 6.2 (both in the same system), and I don't have had any trouble with the first one, but all this with the second one. >David Lizano wrote: > > I have installed PostgreSQL v7.1 in RedHat from RPM's and I have find some > > bugs: >

Re: [ADMIN] Can't do pg_dump(all)

2001-04-19 Thread lbottorff
Please ignore the syntax in my example. It doesn't work with any combination, right or wrong bangh <[EMAIL PROTECTED]> on 02/11/2001 12:30:21 PM To: Larry Bottorff/Harvey@Harvey cc: Subject: Re: [ADMIN] Can't do pg_dump(all) I think you should enter: pg_dump db_name > afile.out n

Re: [ADMIN] Bugs in PostgreSQL v7.1 rpms for RedHat

2001-04-19 Thread Lamar Owen
David Lizano wrote: > I have installed PostgreSQL v7.1 in RedHat from RPM's and I have find some > bugs: > Stopping the service: > === > When '/etc/rc.d/init.d/postgresql stop' try to stop 'postmaster' can't find > the 'postmaster.pid' file, and don't stop the postmaster daemon. > Y

Re: [ADMIN] Trouble with DBD-Pg

2001-04-19 Thread Tom Lane
Christoph Lange <[EMAIL PROTECTED]> writes: > install_driver(Pg) failed: Can't load > '/soft/perl/lib/site_perl/sun4-solaris/auto/DBD/Pg/Pg.so' for module DBD::Pg: >ld.so.1: /soft/local/bin/perl: fatal: > libpq.so: open failed: No such file or directory! Probably you have not told ldconfig where

[ADMIN] Can't do pg_dump(all)

2001-04-19 Thread lbottorff
I've had this problem for a while now in different forms: Basically, I can't get any of the utilities to recognize anything. I just tried %pg_dump > afile.out and got this error message: psql: connectDBStart() -- connect() failed: No such file or directory Is the postmaster running at 'lo

Re: [ADMIN] ERROR: cannot open relation config

2001-04-19 Thread Tom Lane
"Barnes, Sandy (Sandra)" <[EMAIL PROTECTED]> writes: >> 3) creating a database named 'config' >> 4) creating the table 'config' in the database named 'config' Can't reproduce any problem with that here. What PG version are you using, anyway? What's the exact series of commands you're issuing?

[ADMIN] Help with postgres functions

2001-04-19 Thread Fabio Alberto Sobral
Dear Sirs, I have a timestamp atribute in my table and I want to get only the date of this atribute. How can I do this? Does the extract or date_part functions resolve my problem? Regards, Fabio Sobral. ---(end of broadcast)--- TIP 5: Ha

[ADMIN] Trouble with DBD-Pg

2001-04-19 Thread Christoph Lange
Hi experts, I am trying to replace another database with PostgreSQL in an existing CGI-Perl-script. Unfortunately the following failure message stopped my enthusiasm right at the beginning. install_driver(Pg) failed: Can't load '/soft/perl/lib/site_perl/sun4-solaris/auto/DBD/Pg/Pg.so' for module

[ADMIN] Debian packages for 7.1 ???

2001-04-19 Thread Thomas Weholt
Where can I find debian packages for PostgreSQL 7.1 ?? Thomas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[ADMIN] ERROR: cannot open relation config

2001-04-19 Thread Barnes, Sandy (Sandra)
> In the postgresql [/etc/rc.d/init.d] script we are > > 1) initializing the database > 2) starting postmaster > 3) creating a database named 'config' > 4) creating the table 'config' in the database named 'config' > > Everything looks good until I try to access the