On 12/07/2015 09:27 AM, Antony Gelberg wrote:
Hi all,
We want to run 9.3 on the above distro, which comes with 9.4 as standard
(in the distribution). However, we note that there are only 9.5 packages
in the postgresql 15.10 repository. Can somebody flip the switch to
build these? We really aren'
You should be able to add the pgdg repository to your system and then
install through apt as normal. Scroll down to the "PostgreSQL APT
repository" section on this page:
http://www.postgresql.org/download/linux/ubuntu/
Cheers,
Steve
On Mon, Dec 7, 2015 at 9:27 AM, Antony Gelberg
wrote:
> Hi all
Hi all,
We want to run 9.3 on the above distro, which comes with 9.4 as standard
(in the distribution). However, we note that there are only 9.5 packages in
the postgresql 15.10 repository. Can somebody flip the switch to build
these? We really aren't ready to upgrade to 9.4 at the present time.
On 12/07/2015 06:04 AM, Tony Nelson wrote:
Thank you very much, this is working perfectly. I copied a couple over
and the server applied them, and is waiting for the next set.
To prevent this sort of thing in the future I would still take a look at
the restore_command, for the following reaso
Melvin Davidson wrote:
> As long as you have 00010089002C and the subsequent WALs in your
> archive directory, then you should
> be able to simply scp them to you second slave's pg_xlog directory.
Nice idea ;-)
wasn't sure if that works, but yes, nice.
Andreas
--
Really, I'm not
Thank you very much, this is working perfectly. I copied a couple over and the
server applied them, and is waiting for the next set.
Tony
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Monday, December 07, 2015 8:59 AM
To: Tony Nelson
Cc: Andreas Kretschmer; pgsql-general@postgresql.
On 12/07/2015 05:50 AM, Tony Nelson wrote:
-Original Message-
Tony Nelson wrote:
2015-12-07 08:24:50 EST FATAL: requested WAL segment
00010089002C has already been removed
Can I simply copy the file from my archive directory back to the WAL
directory?
I'm afraid th
As long as you have 00010089002C and the subsequent WALs in
your archive directory, then you should
be able to simply scp them to you second slave's pg_xlog directory.
On Mon, Dec 7, 2015 at 8:50 AM, Tony Nelson wrote:
>
>
> > -Original Message-
> > Tony Nelson wrote:
> >
>
> -Original Message-
> Tony Nelson wrote:
>
> > 2015-12-07 08:24:50 EST FATAL: requested WAL segment
> > 00010089002C has already been removed
> >
> >
> >
> > Can I simply copy the file from my archive directory back to the WAL
> directory?
>
> I'm afraid that won't work, be
Tony Nelson wrote:
> 2015-12-07 08:24:50 EST FATAL: requested WAL segment 00010089002C
> has already been removed
>
>
>
> Can I simply copy the file from my archive directory back to the WAL
> directory?
I'm afraid that won't work, because of the master knows nothing about
this
Hi all,
I have a small problem of my own making. I have a simple streaming replication
setup, one master and two slaves. One slave is in the same rack as the master,
the other is across a "slow" link in another server room.
Last night I executed some updates that caused a lot of changes. The
Great, thanks!
On 4 December 2015 at 12:17, Bill Moran wrote:
> On Fri, 4 Dec 2015 09:41:24 +
> Tim Smith wrote:
>
>> When I use "preparedStatement.setString(5,ip);" to send values to a
>> stored function, it obviously gets sent to postgres as "character
>> varying".
>>
>> Postgres obviously
12 matches
Mail list logo