[GENERAL] I screwed it up, my installation :(
Hi all, First a bit of background, I am using RH6.1 on intel and my window manager is HelixGnome with Sawfish. Now, I sure hope someone can help me, I started with a functioning pgsql 6.5.2-1 and decided to upgrade it with the current version 7.0.2-2. I saw on the Download page the comment about initdb and tried to find info about it, ending up in the Installation How-To so I followed it. On the first couple of attempts to install I kept getting an error saying that libpq.so.2 was needed by the current installation and hOpla, but logging in as root (yeah I know, real dumb) and running the installation from there the packages seemed to install ok (I downloaded the whole set of packages because I want to really explore what I can do with pgsql). But then my problems really seemed to start (or at least now become apparent) because then when I tried to restart the postmaster service I got an error saying: Checking postgresql installation: old version. Need to Upgrade.See /usr/doc/postgresql-7.0/README.rpm for more information. I tried to uninstall the old version but I can't using rpm or Gnorpm (which usually crashes anyway), I now realise the installation of the new version seems to have failed despite the fact that when it installed all the packages hash marks indicated the progress. So now it seems I am in a limbo-land where I cant go either one way or the other :-( Before anyone tells me I went about this a**e-about-face you are absolutely right and I am suitably shamed (never done anything so stupid before -- on this computer that is ;-) So please help me, I am desperate. Alan -- AlphaByte: PO Box 1941, Auckland, New Zealand Specialising in:Graphic Design, Education and Training, Technical Documentation, Consulting. http://www.alphabyte.co.nz --- -- AlphaByte: PO Box 1941, Auckland, New Zealand Specialising in:Graphic Design, Education and Training, Technical Documentation, Consulting. http://www.alphabyte.co.nz
[GENERAL] serialization
I am trying to get data from a table in postgres database through a RemoteObject.But I am getting Exception: java.io.NotSerializableException: postgresql.jdbc2.Connection Does postgres support serialization. Can you help me out. Chequemail.com - a free web based e-mail service that also pays!!! http://www.chequemail.com
[GENERAL] Re: Tables Question
try ...mydatab=>\dt good luck! Glenn... <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > How can I retrieve the "names" of all the tables in my database ? > > TIA
Re: [GENERAL] Modifying triggers in database in use...
> On Wed, 16 Aug 2000, Daniel Sjölie wrote: > > > What bothers me is how > > hard it is to update functions (primarily triggers) in a nice way. > > > > Using a procedural language is a lot easier but I find it a real pain to > > edit functioins created in this way since they're only stored in the > > database. You have to retrieve them, edit them and then update them. > > On 2000-08-17 07:40:36, Bob Parkinson wrote: > How about keeping the stuff in an external file, then drop the function > and trigger, and do a psql -d the_database -f the_code to reload. > > If you drop functions you must also drop the trigger associated with it > (it one exists). Well, yeah, that's pretty much what I meant here: > > Is there a nice way to keep the source elsewhere and reload it in some > > simple way? I tried editing database dumps but that feels really bad. I was hoping for a better way but I guess it works... (I don't like to have to drop everything just to tune a variable in a function, (I think) I've seen signs that some things (cached oids?) make (some) trouble when You do this) What I'd really like would be something like specifying the source file where the function is stored when You create the function instead of the actual code - kinda like You specify an object file when You define a C function... It doesn't feel like an unreasonable feature to me... > This bit has been in the archives recently. I'm having trouble finding it... pointers? /Daniel (not subscribed) -- Now take a deep breath, smile and don't take life so seriously... :)
RV: [GENERAL] Tables Question
> How can I retrieve the "names" of all the tables in my database ? In Postgres 7: >From psql: \dt or \d for all objects >From SQL: select * from pg_tables where tablename not like 'pg_%';
[GENERAL] OID decreasing?
Hello, In this table one can see that OID 178502 was created after OID 178593. Is this normal behaviour? I thought that OID sequences kept going up. oid | login | price |created +---+---+ 178383 | vindex| 32500 | 2000-08-14 16:21:04+02 178384 | cunctator | 33000 | 2000-08-17 09:03:17+02 178432 | papy | 33500 | 2000-08-17 09:15:15+02 178465 | vindex| 34000 | 2000-08-17 09:15:59+02 178496 | papy | 34500 | 2000-08-17 09:21:33+02 178497 | vindex| 35000 | 2000-08-17 09:21:33+02 178499 | papy | 65000 | 2000-08-17 12:27:09+02 178501 | vindex| 75000 | 2000-08-17 12:27:09+02 178502 | papy | 77500 | 2000-08-17 12:27:09+02 178528 | papy | 35500 | 2000-08-17 12:26:02+02 178529 | vindex| 36000 | 2000-08-17 12:26:02+02 178561 | papy | 55000 | 2000-08-17 12:26:25+02 178562 | vindex| 57500 | 2000-08-17 12:26:25+02 178592 | papy | 6 | 2000-08-17 12:26:52+02 178593 | vindex| 62500 | 2000-08-17 12:26:52+02 -- Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.org Linux: The Ultimate NT Service Pack
Re: [GENERAL] Regression Tests
On Thu, Aug 17, 2000 at 05:00:49PM +0800, Paul Juliano wrote: > installing PL/pgSQL .. createlang: missing required argument PGLIB > directory I don't know about this one. > Also, when I do: > > make runcheck > > the following message is in the postmaster.log > > IpcSemaphoreCreate: semget failed (No space left on device) > key=65432015, num=16, permission=600 > This type of error is usually caused by an improper > shared memory or System V IPC semaphore configuration. > For more information, see the FAQ and platform-specific > FAQ's in the source directory pgsql/doc or on our > web site at http://www.postgresql.org. > FATAL 1: InitProcGlobal: IpcSemaphoreCreate failed Simplest solution: quit the other postmaster, then make runcheck. Otherwise double your IPC settings - depending on the OS this might involve building a new kernel. Cheers, Patrick
[GENERAL] Regression Tests
Hi, I've installed PostgreSQL 7.0.2 on Solaris following the INSTALL file that comes with the source. When I do: make runtest it gives out the following error message in regress.out: postmaster must already be running for the regression tests to succeed. The time zone is set to PST8PDT for these tests by the client frontend. Please report any apparent problems to [EMAIL PROTECTED] See regress/README for more information. === dropping old regression database... = DROP DATABASE === creating new regression database... = CREATE DATABASE === installing languages... = installing PL/pgSQL .. createlang: missing required argument PGLIB directory (This is the directory where the interpreter for the procedural language is stored. Traditionally, these are installed in whatever 'lib' directory was specified at configure time.) failed Also, when I do: make runcheck the following message is in the postmaster.log IpcSemaphoreCreate: semget failed (No space left on device) key=65432015, num=16, permission=600 This type of error is usually caused by an improper shared memory or System V IPC semaphore configuration. For more information, see the FAQ and platform-specific FAQ's in the source directory pgsql/doc or on our web site at http://www.postgresql.org. FATAL 1: InitProcGlobal: IpcSemaphoreCreate failed
[GENERAL] optimization in C
in C, I work on a database (4 table). COPY FROM file ; SELECT, INSERT, UPDATE, DELETE for a result in the last table. COPY TO file ; in the file, are stored 1 informations. -> It's slowly !!! Can you help me for optimization this? I didn't use Oid, trigger and function SQL. Thanks. Jerome.
Re: [GENERAL] Tables Question
Hi, > How can I retrieve the "names" of all the tables in my database ? Not sure what you are using but if you use DBI perl interface you can use this two functions : $sth = $dbh->table_info; @names = $dbh->tables; They works well with DBD::Pg. In psql simply type \d. this is certainly not what you are asking. Regards
