9:26 AM, Paul Jungwirth
wrote:
> Oh this has happened to me before. :-) On SB1 you need to set
> archive_mode to always (not on). Otherwise it is ignored when running as a
> standby.
It looks to me like this feature was not added until 9.5 and Eric is
running 9.3 :(
> On 11/10/2017 09:10
I'd come to the same conclusion Jeremy had about 9.5 being the first version
with the 'always' option for archive_mode. Looking at pg_receivexlog, that
might work, but with me being a total noob I'm wary of the various steps I'd
have to take in going from:
Master -> streaming replication to
I have a standby db server (SB1) that will soon become the master. SB1 is set
up with streaming replication from the current master. I'm trying to set up a
third server (SB2) as a slave/standby to SB1, so that when SB1 becomes the
master, there will be a standby for it. First step is to get W
Quoting Tom Lane <[EMAIL PROTECTED]>:
"Eric D. Nielsen" <[EMAIL PROTECTED]> writes:
I've confirmed from the commandline using
psql -h -p -U database
"psql: could not connect to server: Connection refused
That's not a Postgres problem. You do not ha
I recently resized a virtual machine hosting an instance of
PostGreSQL. After the resize and the required reboot, PostGreSQL
seem to be acting a little odd.
As a local user, I can connect to my databases. but my Java
applications can now longer connect to the database. (I get the
standa
On Aug 2, 2005, at 11:33 PM, Tom Lane wrote:
"Eric D. Nielsen" <[EMAIL PROTECTED]> writes:
... simplest way I thought would be to have the testing tools drop/
create
the testing database on every test case, and then populate the
database from a specified file. However I do
I'm trying to setup a "safe" testing database environment for some
unit testing of a web application. I would like to have the unit
tests restore the database to a known state before every test. The
simplest way I thought would be to have the testing tools drop/create
the testing database
> Stephan Szabo wrote:
> On Wed, 29 Jun 2005, Richard Huxton wrote:
> > Eric D. Nielsen wrote:
> > > I've come into a situation where I will often need to merge two primary
> > > keys, with numerous foreign keys hanging off of them. For instance:
> >
I've come into a situation where I will often need to merge two
primary keys, with numerous foreign keys hanging off of them. For
instance:
CREATE TABLE people (
peopleid SERIAL PRIMARY KEY,
firstname TEXT NOT NULL,
lastname TEXT NOT NULL
);
CREATE TABLE users (
username TEXT PRIMAR
would
assume I should "upgrade" to 7.3.4, and see if that fixes enough that I
can generate a database dump. Afterwards bring it forward t0 the 8.0
series.
Eric
On Apr 12, 2005, at 10:09 PM, Tom Lane wrote:
"Eric D. Nielsen" <[EMAIL PROTECTED]> writes:
PANIC: XLogWrit
After an extended vacation from development activities on my computer,
I tried to get back to work, but the PostGreSQL backend was no longer
running. (Normally its part of my startup scripts.)
I tried su'ing over to postgres and running pg_ctl start. No luck,
seems like it lost the path. Typ
Quoting Peter Eisentraut <[EMAIL PROTECTED]>:
> Eric D Nielsen wrote:
> > I recently tried to upgrade from the 7.2.1 PostGreSQL package on
> > Debian Stable to the 7.4.6 PostGreSQL package on Debian Testing. The
> > automatic update failed, message included below.
I recently tried to upgrade from the 7.2.1 PostGreSQL package on Debian Stable
to the 7.4.6 PostGreSQL package on Debian Testing. The automatic update
failed, message included below. The documentation for manual upgrades
references a script which does not appear to exist (postgresql-dump) in the
however it looks very useful for mapping their concepts to SQL.
Eric
On Friday, Oct 15, 2004, at 20:25 US/Eastern, George Essig wrote:
Eric D. Nielsen wrote:
I'm in the process of adding more historic information to one of my
databases. I've liked the theoretical treatment of the conce
I'm in the process of adding more historic information to one of my
databases. I've liked the theoretical treatment of the concept in
"Temporal Data and the Relational Model", by Date, Darwen, & Lorentzos.
A lot of it is not realizable without a lot of user defined
types/functions/etc. I was
> From: Greg Stark <[EMAIL PROTECTED]>
> Subject: Re: Need some advice on appropriate PL strategy...
> Message-ID: <[EMAIL PROTECTED]>
>
> "Eric D. Nielsen" <[EMAIL PROTECTED]> writes:
> > I guess I could alternatively just code up a simple mai
I'm in the process of implementing a "monitor this" type feature on a
web-application. When something changes on the monitored item an email
to the subscriber is generated. I'd like to do this via triggers
instead of application logic. As far as I can tell pl/pgsql does not
include any metho
Hello, we're installing PostGreSQL 7.1.3 on a RH 7.1 system and we need
the --with-python option. The ./configure step works fine, but gmake fails on
the first occurence of an #include . We added a
- --with-includes=/path/to/Python/includes, but doesn't seem to solve the
problem. What else sho
Please ignore if this is a resend, but I got an error message on my mail that
was unreadable in my mail reader.
We are install PostGreSQL 7.1.3 on a RH 7.1 system with python. ./configure
works fine, but gmake fails on the first file that has a #include
with a file not found error. We've trie
19 matches
Mail list logo
