Bruce Momjian writes:
> On Wed, May 28, 2014 at 04:56:53PM -0700, Adrian Klaver wrote:
>> So for my edification, does that mean -O ' -c
>> config_file=/etc/postgresql/9.3/main/postgresql.conf' could cause a
>> problem or that starting Postgres outside pg_upgrade could cause a
>> problem, or both
On Wed, May 28, 2014 at 04:56:53PM -0700, Adrian Klaver wrote:
> On 05/28/2014 08:15 AM, Bruce Momjian wrote:
> >On Wed, May 28, 2014 at 12:05:54PM -0300, Leonardo M. Ramé wrote:
>
> >>
> >>Sorry guys, one of the in-site tech support guys started the postgresql
> >>service while we were trying to
On 05/28/2014 08:15 AM, Bruce Momjian wrote:
On Wed, May 28, 2014 at 12:05:54PM -0300, Leonardo M. Ramé wrote:
Sorry guys, one of the in-site tech support guys started the postgresql
service while we were trying to do the upgrade. Looks like this was the
cause of the failure.
OK. We block
On 05/27/2014 09:47 AM, saqibrafique wrote:
fm_db_Server1=# *select to_hex(to_number(substr(from_ip, 1, 3), '999')) as
price from operator;*
/ERROR: function to_hex(numeric) does not exist
LINE 1: select to_hex(to_number(substr(from_ip, 1, 3), '999')) as p...
^
There's no to
Zhemin Zhou writes:
> We met a problem after running the website for one week. We used a
> function to convert and save binary files into the database (as bytea).
> This function worked well in the old version but sometimes makes the new
> version of postgres crash. This random crash is not fil
So I'm sure I'm doing something wrong, or this is maybe a novice question,
On My Mac, I set log_collector=on, archive_command='echo hello %p %f'
And awesome, my postgres log files get the output from my archive command.
On Windows, this does not work (Using postgres 9.3..4)
Only way to get outpu
with check
/usr/lib/postgresql/9.3/bin/pg_upgrade --check -b
/usr/lib/postgresql/8.4/bin/ -B /usr/lib/postgresql/9.3/bin/ -d
/mnt/datos/ -D /mnt/datos/datos_9.3/main/ -o ' -c
config_file=/etc/postgresql/8.4/main/postgresql.conf' -O ' -c
config_file=/etc/postgresql/9.3/main/postgresql.conf'
On Mon, May 26, 2014 at 12:24 AM, Andres Freund wrote:
> Any chance you're using a 9.3 configuration file instead of the one
> generated by initdb?
> dynamic_shared_memory_type defaults to 'posix' if not specified in the
> config file (on platforms supporting it). If initdb detects that 'posix'
>
hi guys,
I am trying to convert a simple char value to HEX but I am getting Error.
*MyTable:*
CREATE TABLE mytable (from_ip CHAR(20), to_ip CHAR(20));
*I have below values in the Table:*
fm_db_Server1=# select * from operator;
from_ip|to_ip
---
Hi all
We have been using postgreSQL version 8.1.11 for 6 years and have to
move our website to another server recently. We did not manage to get
the version 8.1.11 thus have to use version 8.4.12 in the new server.
This version is still quite old but we cannot make the databases running
in
On Wed, May 28, 2014 at 12:05:54PM -0300, Leonardo M. Ramé wrote:
> On 2014-05-28 07:39:33 -0700, Adrian Klaver wrote:
> > On 05/28/2014 07:24 AM, Claudio Biasatti wrote:
> > >with check
> > >
> > >/usr/lib/postgresql/9.3/bin/pg_upgrade --check -b
> > >/usr/lib/postgresql/8.4/bin/ -B /usr/lib/post
On 2014-05-28 07:39:33 -0700, Adrian Klaver wrote:
> On 05/28/2014 07:24 AM, Claudio Biasatti wrote:
> >with check
> >
> >/usr/lib/postgresql/9.3/bin/pg_upgrade --check -b
> >/usr/lib/postgresql/8.4/bin/ -B /usr/lib/postgresql/9.3/bin/ -d
> >/mnt/datos/ -D /mnt/datos/datos_9.3/main/ -o ' -c
> >con
On 05/28/2014 07:24 AM, Claudio Biasatti wrote:
with check
/usr/lib/postgresql/9.3/bin/pg_upgrade --check -b
/usr/lib/postgresql/8.4/bin/ -B /usr/lib/postgresql/9.3/bin/ -d
/mnt/datos/ -D /mnt/datos/datos_9.3/main/ -o ' -c
config_file=/etc/postgresql/8.4/main/postgresql.conf' -O ' -c
config_fil
On Wed, May 28, 2014 at 10:19:24AM -0300, Leonardo M. Ramé wrote:
> Hi, we are trying to upgrade from 8.4 to 9.3, but at the end of the
> process we've got the error:
>
> command: "/usr/lib/postgresql/9.3/bin/pg_resetxlog" -o 2429057
> "/mnt/datos/datos_9.3/main" >> "pg_upgrade_utility.log" 2>&1
On 05/28/2014 06:19 AM, Leonardo M. Ramé wrote:
Hi, we are trying to upgrade from 8.4 to 9.3, but at the end of the
process we've got the error:
command: "/usr/lib/postgresql/9.3/bin/pg_resetxlog" -o 2429057 "/mnt/datos/datos_9.3/main" >>
"pg_upgrade_utility.log" 2>&1
pg_resetxlog: lock file «p
On 05/28/2014 02:04 AM, Dmitry Samonenko wrote:
On Tue, May 27, 2014 at 6:10 PM, Tom Lane mailto:t...@sss.pgh.pa.us>> wrote:
Would you provide some evidence for these claims? If the keepalive
stuff
didn't work, somebody would certainly have noticed by now.
Sure. I'll try to provi
Hi, we are trying to upgrade from 8.4 to 9.3, but at the end of the
process we've got the error:
command: "/usr/lib/postgresql/9.3/bin/pg_resetxlog" -o 2429057
"/mnt/datos/datos_9.3/main" >> "pg_upgrade_utility.log" 2>&1
pg_resetxlog: lock file «postmaster.pid» exists
Is a server running? If not
Hello,
thanks for your answer.
I've identified problems in my cluster agent script. It is a custom written
script with built in automated recovery of failed slave. It was written in
time when postgres 9.1 streaming replications feature was just in beta
release and there was no postgres agent for
On Tue, May 27, 2014 at 6:10 PM, Tom Lane wrote:
>
> Would you provide some evidence for these claims? If the keepalive stuff
> didn't work, somebody would certainly have noticed by now.
>
>
Sure. I'll try to provide it.
> Our general approach to network-error handling is that dropping a
> con
Hello
2014-05-27 20:30 GMT+02:00 Paul Jones :
> I have written a user-defined type that allows direct import and printing
> of
> DB2 timestamps.It does correctly import and export DB2 timestamps,
> butI'm wondering ifsomeone could tell me if I made anymistakes in
> the C code, particularly w.r.t
20 matches
Mail list logo
