Re: [GENERAL] [lapug] LAPUG Social - Tuesday Evening July 14
Depending on the details, I'd love to attend. Any more specifics, by chance? On 7/11/09, Richard Broersma richard.broer...@gmail.com wrote: Josh Berkus and David Fetter will be in West Los Angeles area the beginning of next week. This would be a good opportunity to get together to enjoy dinner and drinks with PostgreSQL's community leaders. Please reply to the LAPUG mailing list if you would like to attend. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via lapug mailing list (la...@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/lapug -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postmaster never finishes starting up, silent to boot
On Tue, Mar 17, 2009 at 11:27 PM, Scott Marlowe scott.marl...@gmail.com wrote: Hard to say with what you've told us so far. what more should I post/need? I was suspecting that as well as I've never had postgres be silent and not work -- I've also never let a db fill its disk and get f'ed like this. should I just let the pg_ctl start run it's course? for a 35GB+ database how long should I wait? is there no way to log the status of what the postgres daemon is actually doing while I wait? what's the standard course of action for a postgres instance that filled its disk and shut itself down -- if there is one? apologies for the admittedly amateur questions but I haven't been able to find much for the situation I'm in. thanks, aaron - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] postmaster never finishes starting up, silent to boot
Greetings, I've gotten myself in a pickle and had a postgresql (8.2) instance fill its disk completely and shutdown itself down. I've moved the entire data directory to a new, larger slice however postmaster never finishes starting. Despite configuring postgresql.conf for excessive 'verboseness' nothing gets outputted to syslog or the --log specified file. I have a feeling I'm just not hitting the right search terms, but shouldn't I be able to simply start a fully copied data directory without issue? at the very least I'd expect some kind of output to some kind of log. I have to kill it with a 'pg_ctl stop -D /mnt/data -m i' -- immediate is the only one that actually kills it; and I get this in syslog: Mar 17 22:36:49 rtg postgres[1879]: [8-1] WARNING: terminating connection because of crash of another server process Mar 17 22:36:49 rtg postgres[1879]: [8-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server Mar 17 22:36:49 rtg postgres[1879]: [8-3] process exited abnormally and possibly corrupted shared memory. Mar 17 22:36:49 rtg postgres[1879]: [8-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. Mar 17 22:36:49 rtg postgres[1879]: [8-5] CONTEXT: xlog redo zeropage: 16645 there are no other postgres instances running on this machine; actually there is nothing else but the OS running on this machine. Appreciate a cluebat hit. thanks, aaron.glenn - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] In the belly of the beast (MySQLCon)
On Thu, Apr 17, 2008 at 11:29 AM, Joshua D. Drake [EMAIL PROTECTED] wrote: Hello, I am currently chilling at MySQLCon. If any other Elephant riders who are doing a little Dolphin hunting are about... I am in Ballroom E about to give a talk on what Mysql can learn from PostgreSQL. is there a live video feed those of us not attending can watch? I've got my popcorn in the microwave already... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How can I avoid PGPool as a single point of failure?
On Jan 29, 2008 6:30 PM, Chander Ganesan [EMAIL PROTECTED] wrote: Is it possible to point two servers running PGPool at the same two database servers? If so, I seem to recall reading about being able to use some kind of virtual IP address to split the traffic to both. CARP...I've never tried to use it for such a thing (I've used it for firewall redundancy in the past..which is what I think it was designed for), but I'm fairly certain you could do so without too much trouble. CARP *and* pfsync. this late at night off the top of my head I can't see any blatantly obvious reason this wouldn't work (with at least pgpool that is, dunno about your data) aaron.glenn ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] Experiences with 3PAR
I'm curious if anyone on the list has any hands on performance experience with running PostgreSQL on 3PAR appliances (big and small). If you do, please contact me offlist - I'll be happy to summarize for the list archives. Thanks, Aaron ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Database corruption with Postgre 7.4.2 on FreeBSD 6.1?
On 7/26/06, aurora [EMAIL PROTECTED] wrote: From your experience do you expect the database would run into this from time to time that requires DBA's interventions? Is so it would become a problem for our customers because our product is a standalone system. We don't intend to expose the Postgre database underneath. wy Is there a particular reason you're using 7.4.2? At the very least, I would be using 7.4.13. regards, aaron.glenn ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] [Slightly OT] data model books/resources?
Anyone care to share the great books, articles, manifestos, notes, leaflets, etc on data modelling they've come across? Ideally I'd like to find a great college level book on data models, but I haven't come across one that even slightly holds definitive resource-type status. Feel free to reply off list to keep the clutter down - I'd be happy to summarize responses for the list. Thanks, aaron.glenn ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] [Fwd: Sun backs open-source database PostgreSQL | Topic: everything | ZDNet News Alerts]
*Sun backs open-source database PostgreSQL* This is going to make PostgreSQL a much easier sell to PHB's (at least, in my experience) aaron.glenn ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] pg_dump with low priority?
On 10/24/05, CSN [EMAIL PROTECTED] wrote: nice comes to mind: nice pg_dump ... as mentioned earlier...nice isn't going to do anything for I/O. PITR (point in time recovery) would be, in my opinion, the best solution to this problem. aaron.glenn ---(end of broadcast)--- TIP 1: 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
Re: [GENERAL] License question[VASCL:A1077160A86]
On 10/4/05, Richmond Dyes [EMAIL PROTECTED] wrote: From my understanding of the license for Postgresql, there is no licensing fees as long as you are not selling it yourself for a profit. Completely incorrect. You can do whatever you like with PostgreSQL; you just can't sue anyone when things go south. aaron.glenn ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] License question[VASCL:A1077160A86]
On 10/4/05, Welty, Richard [EMAIL PROTECTED] wrote: Aaron Glenn wrote: Completely incorrect. You can do whatever you like with PostgreSQL; you just can't sue anyone when things go south. _and_ you need to preserve the copyright notices. excellent point. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] PostgreSQL as a filesystem
On 4/18/05, Christopher Nelson [EMAIL PROTECTED] wrote: This isn't a high-priority question. and if I can latch on to this non-priority question with another in a similar vain: what sort of RDBMS do huge transactional systems like Tandy's use? I've read that everything is a database, similar to the unix paradigm everything is a file. Just curious, aaron.glenn ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] What talk would get you to go to OSCon?
On Tue, 8 Feb 2005 14:29:08 -0500, Robert Treat [EMAIL PROTECTED] wrote: Slony Yes. High Availability Yes. If you have other ideas please feel free to chime in, we'd really like to see an uptick in postgresql attendees. Will Bruce and Tom be attending this year like they did in 2002? Regards, aaron.glenn ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] download postgreql problem
On Tue, 19 Oct 2004 16:24:06 -0400, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Internet explorer. That would be your problem right there. IE's handling of FTP sessions is notoriously quirky. Do yourself a favor and download a shareware FTP program, or open up a DOS prompt. Regards, aaron.glenn ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] clustering
Google slony Regards, aaron.glenn On Thu, 14 Oct 2004 10:29:11 +0530, Nageshwar Rao [EMAIL PROTECTED] wrote: Hi, We would like use Postgresql as our database. For high availability is it possible to cluster DB in Postgresql. Appreciate if you can let me know how this can be achieved. Else is there any other way to achieve High Availability in POstgresql as this is mission critical system. Thanks Nageshwar Rao 91-80-25522059 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] PostgreSQL CE started
What is the PostgreSQL project's official stance/view/comment on this? aaron.glenn On Thu, 14 Oct 2004 10:48:26 +0900 (JST), Tatsuo Ishii [EMAIL PROTECTED] wrote: Hi all, We, Software Research Associates, Inc., have started PostgreSQL CE (PostgreSQL Certificated Engineer), on Oct 1st. PostgreSQL CE is an entry level PostgreSQL engineer certification program. We expect at least several hundreds of people will take the examin by April 2005. We also hope that PostgreSQL CE makes PostgreSQL more and more popular. For the present examins are held in about 100 test centers in Japan and the examin itself is written in Japanese. However since we have a partnership with Pearson VUE (http://www.pearsonvue.com/) to operate the examin, it is possible that PostgreSQL CE could be taken effect in US and/or rest of the world. Software Research Associates, Inc.(http://www.sra.co.jp/index-en.html) is headquartered in Tokyo and is doing lots of PostgreSQL businesses. -- Tatsuo Ishii ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]