[HACKERS] Postgresql, HA ?, Monitoring.
Dear Hackers, i'm using 7.1 in a production environment, porformace is very good, you've made a vesy good job. But there are problems, sometimes backend "failed to start": (mandrake 7.2, mod_perl 1.24, apache 1.3.14, Apache::DBI) (deadlock_timeout=2000 max_connections=300) DBI->connect(dbname=mydb) failed: Backend startup failed at /home/httpd/cgi-bin/e/lib/DBstuff.pm line 27. Our application is transactional, with a high degree of concurrency. I've already a silly monitor in perl that connects every minute to postgres to see if connection is ok, but sometimes it gives the error above. I'm asking to all of you the CORRECT sequence of actions to do a monitor that restarts postgresql in the most safe possible way. This for having a solution that gives a better overall uptime. For example i must do (??): 0. kill apache so that connection will terminate. 1.killall -TERM postmaster 2. wait for secs, or for what (?) 3. if postgres alive (ps -ef | grep postmaster...) than: killall -9 postmaster 4.restart postmaster 5. see if it'ok 6.restart apache etc. thanks in advance for your answers. vater mazzola, italy. valter mazzola _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[HACKERS] Schema Issue
I want to extract tables schema information, i've looked at src/bin/psql/describe.c but i cannot determine the datatype 'serial' and 'references' from pg_*, i understand that triggers are generated for serial and references, so how i can understand from my perl application the full schema ? thanks, valter _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] unanswered: Schema Issue
I want to extract tables schema information, i've looked at src/bin/psql/describe.c but i cannot determine the datatype 'serial' and 'references' from pg_*, i understand that triggers are generated for serial and references, so how i can understand from my perl application the full schema ? thanks, valter _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[HACKERS] Re: unanswered: Schema Issue
ok for serials, now i can extract from psql (\d tablename). But i'm not able to extract foreign keys from the schema. >From: Joel Burton <[EMAIL PROTECTED]> >To: "V. M." <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: unanswered: Schema Issue >Date: Thu, 26 Apr 2001 13:51:26 -0400 (EDT) > >On Thu, 26 Apr 2001, V. M. wrote: > > > > > I want to extract tables schema information, i've looked at > > src/bin/psql/describe.c but i cannot determine the datatype > > 'serial' and > > 'references' from pg_*, i understand that triggers are generated for > > serial > > and references, so how i can understand from my perl application the > > full > > schema ? > >SERIALs are just integers (int4). They don't use a trigger, but use a >sequence >as a default value. > >REFERENCES are not a type of data, but a foreign key/primary key >relationship. There's still a data type (int, text, etc.) > >You can derive schema info from the system catalogs. Use psql with -E for >examples, or look in the Developer Manual. > >HTH, > >-- >Joel Burton <[EMAIL PROTECTED]> >Director of Information Systems, Support Center of Washington > _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Re: unanswered: Schema Issue
read it, but i can determine only the related tables and not the fields of these tables that are related. valter >From: Joel Burton <[EMAIL PROTECTED]> >To: "V. M." <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: [HACKERS] Re: unanswered: Schema Issue >Date: Thu, 26 Apr 2001 14:42:31 -0400 (EDT) > >On Thu, 26 Apr 2001, V. M. wrote: > > > ok for serials, now i can extract from psql (\d tablename). > > > > But i'm not able to extract foreign keys from the schema. > >Yes you can. Read my tutorial on Referential Integrity in the top section >at techdocs.postgresql.org. > >-- >Joel Burton <[EMAIL PROTECTED]> >Director of Information Systems, Support Center of Washington > > >---(end of broadcast)--- >TIP 4: Don't 'kill -9' the postmaster _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Re: unanswered: Schema Issue
perhaps adding t.tgargs to your view enable me to extract parameters that are the related fields --- CREATE VIEW dev_ri AS SELECT * t.tgargs , t.oid as trigoid, c.relname as trig_tbl, t.tgfoid, f.proname as trigfunc, t.tgenabled, t.tgconstrname, c2.relname as const_tbl, t.tgdeferrable, t.tginitdeferred FROM pg_trigger t, pg_class c, pg_class c2, pg_proc f WHERE t.tgrelid=c.oid AND t.tgconstrrelid=c2.oid AND tgfoid=f.oid AND tgname ~ '^RI_' ORDER BY t.oid; a tgargs example is: fk_provincie_id_paesi_id_provin\000paesi\000province\000UNSPECIFIED\000id_provincia\000id\000 first field (fk_provincie_id_paesi_id_provin) is constraint name, and i can understand that: paesi(id_provincia) references provincia(id). valter >From: Joel Burton <[EMAIL PROTECTED]> >To: "V. M." <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: [HACKERS] Re: unanswered: Schema Issue >Date: Thu, 26 Apr 2001 14:42:31 -0400 (EDT) > >On Thu, 26 Apr 2001, V. M. wrote: > > > ok for serials, now i can extract from psql (\d tablename). > > > > But i'm not able to extract foreign keys from the schema. > >Yes you can. Read my tutorial on Referential Integrity in the top section >at techdocs.postgresql.org. > >-- >Joel Burton <[EMAIL PROTECTED]> >Director of Information Systems, Support Center of Washington > > >---(end of broadcast)--- >TIP 4: Don't 'kill -9' the postmaster _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[HACKERS] CVSup not working!
cvsup -L 2 postgres.cvsup Parsing supfile "postgres.cvsup" Connecting to postgresql.org Cannot connect to postgresql.org: Connection refused Will retry at 22:31:23 -- # This file represents the standard CVSup distribution file # for the PostgreSQL ORDBMS project # Modified by [EMAIL PROTECTED] 1997-08-28 # - Point to my local snapshot source tree # - Pull the full CVS repository, not just the latest snapshot # # Defaults that apply to all the collections *default host=postgresql.org *default compress *default release=cvs *default delete use-rel-suffix # enable the following line to get the latest snapshot #*default tag=. # enable the following line to get whatever was specified above or by default # at the date specified below #*default date=97.08.29.00.00.00 # base directory points to where CVSup will store its 'bookmarks' file(s) # will create subdirectory sup/ #*default base=/opt/postgres # /usr/local/pgsql *default base=/usr/local/cvsroot # prefix directory points to where CVSup will store the actual distribution(s) *default prefix=/usr/local/cvsroot # complete distribution, including all below pgsql # individual distributions vs 'the whole thing' # pgsql-doc # pgsql-perl5 # pgsql-src _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] Postgresql.exe 7.1 for M$ OS
Where i can find a wonderful installer for postgres 7.1 on our windows2000 advanced servers ? We use postgres on linux systems, But... I'm not able to find on the net a binary for Postgres 7.1. I don't want to compile, i want a simple installer. windows machines are 200 Million, if you'll make a maintained binary postgres version for windows probably more developers more bug fixing will be... It's critical. Also in the web site , will be wonderful if, on the navbar, the download links are always there (latest stable, jdbc, odbc, DBD::Pg) etc. thanks, valter _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[HACKERS] Child itemid in update-chain marked as unused - can't continue repair_frag
lindo=# vacuum analyze; NOTICE: Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS NOT THE SAME AS HEAP' (4). Recreate the index. NOTICE: Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS NOT THE SAME AS HEAP' (4). Recreate the index. NOTICE: Child itemid in update-chain marked as unused - can't continue repair_frag VACUUM what i must do here? thanks, valter _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[HACKERS] NOTICE: Child itemid in update-chain marked as unused...
sometimes i'm getting: NOTICE: Child itemid in update-chain marked as unused - can't continue repair_frag during a simple "vacuum", db is online. pg version 7.1, on debian linux kernel 2.4. what's the problem? thanks, valter m. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ---(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 list cleanly