[ADMIN] Postgres service starts and then stops immediatly
Hi, -We are using Postgres 8.3.7 on Windows -We cannot start the Postgres service. The windows OS error message is: The PostgreSQL Server 8.3 service on Local Computer started then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service. -No logs in the postgres log file -When using pg_ctl, the postgres.exe is starting OK Please help, Thanks, Yuval Sofer BMC Software CTMD Business Unit DBA Team 972-52-4286-282 yuval_so...@bmc.commailto:yuval_so...@bmc.com
Re: [ADMIN] Postgres service starts and then stops immediatly
On 11/08/2011 6:00 PM, Sofer, Yuval wrote: Hi, -We are using Postgres 8.3.7 on Windows -We cannot start the Postgres service. The windows OS error message is: The PostgreSQL Server 8.3 service on Local Computer started then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service. -No logs in the postgres log file -When using pg_ctl, the postgres.exe is starting OK This sounds like permissions. Check and make sure that the postgres user has the rights to write to the data directory, including the log files. Has anything been changed lately? Restored/deleted/updated? System users modified? Domain policy changed? Check the Event Viewer for more information about the failure, see if there's anything there. What Windows version are you using? Why PostgreSQL 8.3.7 when the latest release is 8.3.15? You're missing a lot of bug fixes. -- Craig Ringer
Re: [ADMIN] initdb fails on AIX
-Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- ow...@postgresql.org] On Behalf Of Tom Lane Sent: Wednesday, August 10, 2011 4:22 PM To: CS DBA Cc: PG Admin Subject: Re: [ADMIN] initdb fails on AIX CS DBA cs_...@consistentstate.com writes: On 08/10/2011 01:16 PM, Tom Lane wrote: This means that initdb tried to execute postgres -V and didn't get any output. What happens when you try that directly? See below. One oddity, if I compile without the --with-openssl flag (for the configure command) then it works fine. exec(): 0509-036 Cannot load program ./postgres because of the following errors: 0509-150 Dependent module libcrypto.a(libcrypto.so.0.9.7) could not be loaded. 0509-022 Cannot load module libcrypto.a(libcrypto.so.0.9.7). 0509-026 System error: A file or directory in the path name does not exist. Well, yeah. It looks like there is something pretty broken about your openssl installation. At the very least you need a LD_LIBRARY_PATH (or local equivalent) pointing to wherever libcrypto.so is hiding ... but a reasonable installation of openssl should have taken care of that for you. Possibly you could build postgres with an rpath (or local equivalent) pointing to openssl's library directory. I used to have all sorts of problems with openssl on AIX (not just Postgres, but other packages I tried building with it). We had to build our own version to get it working with pretty much anything. Brad. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Postgres service starts and then stops immediatly
From: Sofer, Yuval [mailto:yuval_so...@bmc.com] Sent: Thursday, August 11, 2011 6:01 AM To: pgsql-admin@postgresql.org Cc: Zucker, Yehudit Subject: Postgres service starts and then stops immediatly Hi, -We are using Postgres 8.3.7 on Windows -We cannot start the Postgres service. The windows OS error message is: The PostgreSQL Server 8.3 service on Local Computer started then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service. -No logs in the postgres log file -When using pg_ctl, the postgres.exe is starting OK Please help, Thanks, Yuval Sofer BMC Software CTMD Business Unit DBA Team 972-52-4286-282 yuval_so...@bmc.com Yuval, Using pg_ctl, did you try to start PG as a service? e.g.: C:/PostgreSQL/8.4/bin/pg_ctl.exe runservice -N PostgreSQL -D C:/PostgreSQL/8.4/data -w Could it be that account used to start PG service doesn't have privileges to run as a service? Check in Local Security Settings under Local Policies/User Rights Assignments - make sure that Log on as a service granted to the account specified in PG service properties. Regards, Igor Neyman -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Master to Master replication options?
Hi All; I have a client that wants the following: - 2 masters (master to master replication) - multiple read only slaves off each master - the ability to failover in case of a master node failure to include re-directing the slaves off the failed master to now point to the remaining active master Questions: - Is Bucardo the only viable master to master solution? - Can I setup HOT standby's or SLONY off of a Bucardo master? - Can I shift a slave's 'master' without a full reset? Thanks in advance... -- - Kevin Kempter - Constent State A PostgreSQL Professional Services Company www.consistentstate.com - -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] replication from Oracle to PostgreSQL?
Hi All; Anyone know of tools / options that will allow Oracle to PostgreSQL replication? or at least a real time feed or dblink? Thanks in advance... -- - Kevin Kempter - Constent State A PostgreSQL Professional Services Company www.consistentstate.com - -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] replication from Oracle to PostgreSQL?
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote: Anyone know of tools / options that will allow Oracle to PostgreSQL replication? or at least a real time feed or dblink? EnterpriseDB's Postgres Plus Advanced Server has a realtime replication solution bundled. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [ADMIN] replication from Oracle to PostgreSQL?
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote: Anyone know of tools / options that will allow Oracle to PostgreSQL replication? or at least a real time feed or dblink? EnterpriseDB's Postgres Plus Advanced Server has a realtime replication solution bundled. Regards, That was the first thing I tried to push 'em towards... they shut it down cause it's not free (which is weird since they're not considering a real TCO, but they are the customer). -- - Kevin Kempter - Constent State A PostgreSQL Professional Services Company www.consistentstate.com - -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] replication from Oracle to PostgreSQL?
On 08/11/2011 08:41 AM, CS DBA wrote: Hi All; Anyone know of tools / options that will allow Oracle to PostgreSQL replication? or at least a real time feed or dblink? Thanks in advance... I believe EnterpriseDB Advanced Server does it (http://www.enterprisedb.com/) -- Chris Ernst Data Operations Engineer Zvelo, Inc. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] replication from Oracle to PostgreSQL?
On Thu, Aug 11, 2011 at 3:41 PM, CS DBA cs_...@consistentstate.com wrote: Anyone know of tools / options that will allow Oracle to PostgreSQL replication? or at least a real time feed or dblink? 2ndQuadrant has various in-house tools for fast migration from Oracle to PostgreSQL, but those aren't designed for long term co-existence, just for minimising the window of downtime at cutover. It's not been weaponised, so its not available for free download. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] replication from Oracle to PostgreSQL?
On 08/11/2011 08:41 AM, CS DBA wrote: Hi All; Anyone know of tools / options that will allow Oracle to PostgreSQL replication? or at least a real time feed or dblink? Thanks in advance... SymmetricDS is capable of doing replication one DB to another, but I've never used it so cannot speak from experience. Mark -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] PostgreSQL fails to bind IPv6 socket at startup on AIX platform
Hi All; we're trying to get PostgreSQL configured on an AIX box (AIX version 5). After some digging adding various paths to LD_LIBRARY_PATH (Thanks to help from Tom Lane) we were able to complete the source based build. However, when we try and start the db we get the following: $ pg_ctl start server starting $ LOG: could not bind IPv6 socket: The socket name is already in use. HINT: Is another postmaster already running on port 3116? If not, wait a few seconds and retry. I've verified via 'ps' that there are no postgres processes running, also there is no postmaster.pid file present in the $PGDATA dir Thoughts? Thanks in advance -- - Kevin Kempter - Constent State A PostgreSQL Professional Services Company www.consistentstate.com - -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] replication from Oracle to PostgreSQL?
On 08/11/2011 07:57 AM, CS DBA wrote: On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote: Anyone know of tools / options that will allow Oracle to PostgreSQL replication? or at least a real time feed or dblink? EnterpriseDB's Postgres Plus Advanced Server has a realtime replication solution bundled. Regards, That was the first thing I tried to push 'em towards... they shut it down cause it's not free (which is weird since they're not considering a real TCO, but they are the customer). I would aimagine it would be pretty simple to fork the triggers that do replication in Londiste or Slony (as long as everything else was PostgreSQL) to be able to replicate from Oracle to PostgreSQL. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http://www.postgresqlconference.org/ @cmdpromptinc - @postgresconf - 509-416-6579 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] streaming replication questions
I've got three Linux systems (each with Fedora15-x86_64 running PostgreSQL-9.0.4). I'm attempting to get a basic streaming replication setup going with one master two standby servers. At this point, the replication portion appears to be working. I can run an 'update' statement on the master, and view the result with a 'SELECT' on both standby servers. I've mostly been working off the information presented here: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial http://wiki.postgresql.org/wiki/Streaming_Replication plus the official Postgresql website documentation, with copious googling for other sources when something didn't make sense. 0) I've successfully setup the WAL archiving on the master, and set archive_timeout=61. However, what I'm seeing is that new files are not getting generated every 61 seconds, but instead only when some kind of SQL is invoked which writes to the database, or every 305 seconds (whichever comes first). I know this is the case because I wrote a script which is being invoked via the archive_command option, and that script is logging both the timestamp and filenames each time it is invoked. How can I debug this? 1) Both of the wiki links above comment that the restore_command may not be necessary if wal_keep_segments is large enough (mine is set to 128). I was going to setup the restore_command anyway, as I'm not yet confident enough about streaming replication and failover with postgresql to take chances, although the fact that i have two standby servers makes this setup a bit more complex. However, can anyone comment about whether its ever truly safe 100% of the time to run without a restore_command ? 2) Can anyone who is currently running with more than one standby comment how they're automating the failover process? I've read a few comments about setting up something like heatbeat and/or pgpool (or even writing custom scripts), but I'm not finding any well documented solutions. many thanks in advance! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] PostgreSQL fails to bind IPv6 socket at startup on AIX platform
On 11-08-11 02:24 PM, CS DBA wrote: Hi All; we're trying to get PostgreSQL configured on an AIX box (AIX version 5). After some digging adding various paths to LD_LIBRARY_PATH (Thanks to help from Tom Lane) we were able to complete the source based build. However, when we try and start the db we get the following: $ pg_ctl start server starting $ LOG: could not bind IPv6 socket: The socket name is already in use. HINT: Is another postmaster already running on port 3116? If not, wait a few seconds and retry. Have you tried a different port? Something else (other than postgresql) could be using port 3116. Failing that have you tried setting listen_address to only bind to an ipv4 address to see if it makes a difference? (I don't think I've ever tried ipv6 with postgresql on our AIX machines) I've verified via 'ps' that there are no postgres processes running, also there is no postmaster.pid file present in the $PGDATA dir Thoughts? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] replication from Oracle to PostgreSQL?
On 08/11/2011 03:58 PM, Joshua D. Drake wrote: I would imagine it would be pretty simple to fork the triggers that do replication in Londiste or Slony (as long as everything else was PostgreSQL) to be able to replicate from Oracle to PostgreSQL. That's the approach taken by some of our in-house tools. simple wouldn't be the right word to describe the process that went into building them though. You have to get the basics working, then worry about non-deterministic statements (random, timestamps, etc.), sequencing, all of the stuff any statement based replication can be faced with--except now there's the quirks of two databases to worry about. One of the reasons Slony and Londiste statement extraction works as well as it does is because new functions were added to PostgreSQL 8.3 for them, to make it easier to get the sort of snapshot information needed to grab consistent copies of data. That problem comes back again when the origin database isn't a PostgreSQL one too. There are a couple of ways to solve this problem, but all of them are complicated enough that they're only sitting in commercial/consultant projects right now (in addition to ones mentioned here already, I'm sure Continuent has some applicable stuff too). I think Kevin's customer may be in for a surprise at how much it will cost to duplicate this feature set from scratch--I'd be surprised to see that total come in under what licensing an already built package would sell for. Companies who aren't willing to throw some money toward buying/customizing at least some PostgreSQL software, if it allows escaping from Oracle licensing, should reconsider their strategy. Not everything you'll want to make a conversion easy is going to be free. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] replication from Oracle to PostgreSQL?
On 11/08/2011 10:57 PM, CS DBA wrote: On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote: Anyone know of tools / options that will allow Oracle to PostgreSQL replication? or at least a real time feed or dblink? EnterpriseDB's Postgres Plus Advanced Server has a realtime replication solution bundled. Regards, That was the first thing I tried to push 'em towards... they shut it down cause it's not free (which is weird since they're not considering a real TCO, but they are the customer). Using Oracle ... and objecting to not free? *boggle* There are lots of ETL tools available, and there's always the roll-your-own queue-based trigger replication system option. Of course, both options would probably cost more than buying EDB's already built and tested version... -- Craig Ringer -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin