On 23/10/2017, 17:17, "George Neuner" wrote:
>Doesn't GCloud provide a way to export drive images?
[He asks naively, never having used it.]
Nope – just the dd method (although this doesn’t work on VMWare, so you need to
use a VWM utility on a Win pc to get it). I’m pretty sure Google use
OK, cheers.
How can I remove the db so I can restore it properly?
From: Scott Mead
Date: Monday, 23 October 2017 at 16:35
To: Martin Moore
Cc: Michael Nolan , "pgsql-general@postgresql.org"
Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare
On Mon, Oct 2
It was running – not sure how dd handles this. Maybe badly… ☺
From: Michael Nolan
Date: Monday, 23 October 2017 at 15:52
To: Martin Moore
Cc: rob stone , "pgsql-general@postgresql.org"
Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare
On Mon, Oct 23, 2017
restore, in which case how
do I ‘drop’ the DB without postgres running?
Ta,
Martin.
On 23/10/2017, 00:51, "rob stone" wrote:
On Sun, 2017-10-22 at 15:13 +0100, Martin Moore wrote:
> 2017-10-22 14:08:28 UTC [2479-1] LOG: 0: database system
> shutdown
I’ve migrated a running Debian Jessie system from a Google Compute instance to
a VMWare ESXi 6.5 system.
Postgres won’t start, although returns [ok] :
/etc/init.d/postgresql start 9.6
[ ok ] Starting postgresql (via systemctl): postgresql.service.
2017-10-22 14:08:28 UTC [2479-1] LOG: 0:
PostgreSQL?
Thanks for the attention.
Not an 'official' tool, but if you're familiar with OEM then EnterpriseDB does
PostgreSQL Enterprise Manager.
https://www.enterprisedb.com/products/edb-postgres-platform/edb-postgres-enterprise-managerpem
--
Martin Goodson
"Have y
occurring. I’m hoping there’s something I’m unaware of as
this shouldn’t happen!
What could this be? I don’t have any logs at present as I removed the insert
statement some time ago, but need to get this issue resolved.
Thanks,
Martin.
--
Sent via pgsql-general mailing list (pgsql-general
On 19/07/2017 11:52 PM, Tom Lane wrote:
Evan Martin writes:
I have an application that imports a lot of data and the does some
queries on it to build some caches in the database, all in one long
transaction. One of those cache updates repeatedly calls a plpgsql
function, which internally does
I have an application that imports a lot of data and the does some
queries on it to build some caches in the database, all in one long
transaction. One of those cache updates repeatedly calls a plpgsql
function, which internally does some SQL queries. Sometimes this is
much, much slower than us
thanks for your help, which is exceptionally clear and detailed.
MM
On 6/18/17, 3:03 PM, "Adrian Klaver" wrote:
>On 06/18/2017 01:00 PM, Martin Mueller wrote:
>> Did you mean that "/users/martin/Library
>> ApplicationSupport/Postgres/var9.5/base/" is above or
Did you mean that "/users/martin/Library
ApplicationSupport/Postgres/var9.5/base/" is above or below the data
directory? As I understand it Postgres is the highest Postgres specific
directory. It contains just one child directory, var-9.5, which has a lot of
subdirectories, inclu
hopeless that way. Is Postgres more like INNO than ISAM when it
comes to table storage?
On 6/18/17, 12:58 PM, "pgsql-general-ow...@postgresql.org on behalf of Karsten
Hilbert" wrote:
>On Sun, Jun 18, 2017 at 05:30:44PM +, Martin Mueller wrote:
>
>> Thank for this very hel
6/18/17, 11:13 AM, "Adrian Klaver" wrote:
>On 06/18/2017 06:16 AM, Martin Mueller wrote:
>> Why not a PostgreSQL-database somewhere in the cloud? Good question, but
>> it's a question of money and performance. I used MySQL for many years and
>> then m
ce, I'd have to spend a lot of money that I don't
have. Dropbox costs $120 a year for a terabyte of storage, which is very
affordable.
On 6/18/17, 2:43 AM, "pgsql-general-ow...@postgresql.org on behalf of Andreas
Kretschmer" wrote:
>
>
>Am 18.06.2017 u
stored in my homedirectory
/users/martin/Library ApplicationSupport/Postgres/var9.5/base/. I have read
things on the Web about backing up data to Dropbox (I have 80GB of data) .
But that means that my data sit first in the base directory, then in the
Dropbox directory from which they are
On 15/06/2017 05:27, Andreas Kretschmer wrote:
Am 15.06.2017 um 01:18 schrieb Martin Goodson:
I'm just wondering how people may have implemented this. Do people
setup pgbouncer nodes on the database servers themselves, on
application servers, in the middle tier between the applicatio
On 14/06/2017 19:54, Rory Campbell-Lange wrote:
On 14/06/17, Martin Goodson (kaema...@googlemail.com) wrote:
The new master's repmgr promote script will execute commands to pause
pgbouncer, reconfigure pgbouncer to point to the new database address, and
then resume.
You could just mov
screaming 'Why on earth is this
idiot not using X instead?' :)
Any input would be greatly appreciated.
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going
t I'm relatively
confident that should be OK, I was getting good results on my little
ubuntu box at home ...
Of course, I said the same think about compiling it :)
Huge thanks to EVERYONE who helped on this! If anyone is going to be at
PG Day UK, I'll buy you a drink :)
Regards
d Quadrant? Is this a 'bug' of some kind, or just a
really weird edge case? :)
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it.&quo
wxrwxrwx 1 root root 21 May 16 17:06 /lib64/libldap.so ->
libldap-2.4.so.2.10.3
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."
On 17/05/2017 16:15, Adrian Klaver wrote:
On 05/17/2017 07:26 AM, Martin Goodson wrote:
On 16/05/2017 18:46, Adrian Klaver wrote:
Per Tom's suggestion try
ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2
Hello. Apologies for the delay in replying - medical appointment this
mo
(0x7f20fe6d2000)
/lib64/ld-linux-x86-64.so.2 (0x7f20ffe14000)
(I noticed there was a second file in there with roughly the same name
... ish. Just in case it might be relevent, I did that one too :) )
Hope that info's helpful!
Regards,
Martin.
--
Sent via pgsql-general m
On 16/05/2017 16:39, Martin Goodson wrote:
On 16/05/2017 15:58, Adrian Klaver wrote:
/bin/ld: warning: libssl.so.1.0.0, needed by
/db_demo/app/postgres/9.6.2-3/lib/libpq.so, may conflict with
libssl.so.10
/lib64/libldap_r-2.4.so.2: undefined reference to `ber_sockbuf_io_udp'
collect2:
)
Many thanks for all the help so far. It's been very, very, helpful. I'm
sure it's nearly there ...
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?
On 16/05/2017 14:42, Adrian Klaver wrote:
On 05/16/2017 04:36 AM, Martin Goodson wrote:
On 15/05/2017 00:17, Martin Goodson wrote:
Tomorrow I'll have to see about getting that set-up on an RHEL 7 box :)
Thank you so much, everybody, for your help! It's been invaluable!
Regard
On 15/05/2017 00:17, Martin Goodson wrote:
Tomorrow I'll have to see about getting that set-up on an RHEL 7 box :)
Thank you so much, everybody, for your help! It's been invaluable!
Regards,
Martin.
*Sigh*. And things were going so well. With Adrian and Devrim's help I
/9.6.3/lib/postgresql'
/bin/mkdir -p '/opt/PostgreSQL/9.6.3/share/postgresql/contrib'
/usr/bin/install -c -m 755 repmgr_funcs.so
'/opt/PostgreSQL/9.6.3/lib/postgresql/repmgr_funcs.so'
/usr/bin/install -c -m 644 .//uninstall_repmgr_funcs.sql
repmgr_funcs.sql '/opt/Post
On 14/05/2017 19:26, Devrim Gündüz wrote:
Hi Martin,
On Fri, 2017-05-12 at 16:13 +0100, Martin Goodson wrote:
/usr/bin/ld: cannot find -lselinux
/usr/bin/ld: cannot find -lssl
/usr/bin/ld: cannot find -lcrypto
/usr/bin/ld: cannot find -lgssapi_krb5
/usr/bin/ld: cannot find -lz
collect2: error
On 12/05/2017 18:57, Adrian Klaver wrote:
On 05/12/2017 09:19 AM, Martin Goodson wrote:
On 12/05/2017 16:59, Adrian Klaver wrote:
Configuring Automatic failover using Replication Manager 2.0 on
PostgreSQL 9.3.5
http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html
on how easy it was and how much of an idiot I am, or my
abject failure and how much of an idiot I am :)
Many thanks!
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
On 12/05/2017 16:48, Adrian Klaver wrote:
On 05/12/2017 08:30 AM, Martin Goodson wrote:
On 12/05/2017 16:18, Joshua D. Drake wrote:
Thanks for the response. The problem is I'm kind of stuck with using
EnterpriseDB's community edition installers. It's a company policy. I
On 12/05/2017 16:18, Joshua D. Drake wrote:
On 05/12/2017 08:13 AM, Martin Goodson wrote:
Hello.
Yesterday I had problems getting repmgr installed, since our PostgreSQL
installs to a non-standard place, and doesn't use any postgresql
repositories/packages. The responses I got generally s
; failed
make: *** [repmgrd] Error 1
Any ideas what I am doing wrong? I can only assume I'm missing something
really, really, obvious. Every single book and article I've seen simply
states 'Just quickly install repmgr then ...' - it's driving me nuts
that I can't get this thing installed, let alone working :)
Any help/advice/suggestions/pointing-outs-of-the-obvious would be
greatly appreciated.
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."
res/9.6.2-3/bin
Is there a simple way to use repmgr from the package, perhaps by
copying/linking files from that location to ours? (e.g. copying/linking
some files from lib, bin, contrib, etc).
Or am I looking at having to compile the source? I'm told it should be
'simple'
On 18/03/2017 01:22, Adrian Klaver wrote:
On 03/17/2017 06:07 PM, Martin F wrote:
Hi,
I just started last week to build postgresql from source. (So this may
well be something I did wrong on my side)
Do you really want to build the latest dev version?
Yes, I want the latest, and I understand
Hi,
I just started last week to build postgresql from source. (So this may
well be something I did wrong on my side)
I am on branch master
Revision: f7819baa618c528f60e266874051563ecfe08207
Date: 17/03/2017 18:58:06
I did build with
make clean distclean
./configure --prefix=/deploys/postg
On 03/03/2017 17:33, Tom Lane wrote:
Martin F writes:
The select with filter choose an IMHO better plan
Index Only Scan using tbl_foo_date on public.tbl_foo
But the bigger picture here, which would become more obvious if you were
working with a non-toy amount of data, is that you're a
On 03/03/2017 17:33, Tom Lane wrote:
Martin F writes:
Index Cond: (tbl_foo.id IS NOT NULL)
only "id" is the pk, and declared "not null".
So why this index condition?
You're right that we could observe that the NOT NULL is implied by a table
constraint and drop it,
for the "where" part)
To check this I tried
explain analyze verbose select min(created_at), min(id) filter(where
created_at >= '2017-01-15') from tbl_foo;
and it gives an index only as well.
Out of interest, anyone with 9.6.2, does it yield the same results?
On 03/03/2
for the "where" part)
To check this I tried
explain analyze verbose select min(created_at), min(id) filter(where
created_at >= '2017-01-15') from tbl_foo;
and it gives an index only as well.
Out of interest, anyone with 9.6.2, does it yield the same results?
On 03/03/2
Hi.
I am new, and not sure which mailinglist this should go to, so I start
with the general list. (please advice, if I should send this to a more
specific list)
This is tested with postgresql 9.5.5 (Maybe someone can confirm, if it
is the same with later versions, saving me the work to upgrade
occurs on 9.3, 9.4 and 9.5 which leads me to believe it’s an
environment/architecture issue.
I’m kinda stuck now!
Any help gratefully received.
Rgds,
Martin.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
is an ORM simpler
> than SQLAlchemy, and the Phoenix toolkit for the UI.
Flask has a simple SQLAlchemy wrapper now. It is also based on bootstrap
though I don't know how the widget set compares with Phoenix,
Martin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
cations/office/kexi/
And if that's no good http://flask.pocoo.org/ is simpler than Django.
Martin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 31/10/2016 8:26 PM, Melvin Davidson wrote:
I have tried using an event trigger to detect table creation (ie:
tg_event_audit_all ) however, that does not parse the schema_name and
objid
as does pg_event_trigger_dropped_objects(), so I am not sure that is a
practical way to audit.
Event trig
If I have a query that reads from system tables like pg_class,
pg_namespace, pg_attribute, pg_type, etc. and I'd like to cache the
results in my application is there any fast way to detect when any
changes have been made to these system catalogs? I don't need to know
exactly what has changed.
i'm tryng to access to a db that is on a my server.
The port is 5432 open and accept tcp/ip connections.
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x274D/10061) Is the
server running on host "I
Sameer Kumar wrote on 04/21/2016 13:56:52:
> From: Sameer Kumar
> To: Martin Kamp Jensen/DK/Schneider@Europe, pgsql-general@postgresql.org
> Date: 04/21/2016 14:00
> Subject: Re: [GENERAL] Invalid data read from synchronously
> replicated hot standby
>
>
> O
Adrian Klaver wrote on 04/21/2016 16:03:55:
> From: Adrian Klaver
> To: Martin Kamp Jensen/DK/Schneider@Europe, pgsql-general@postgresql.org
> Date: 04/21/2016 16:09
> Subject: Re: [GENERAL] Invalid data read from synchronously
> replicated hot standby
>
> O
setup is sane (and expected to work), we will work on setting up a
minimal reproduce that avoids our complete system. We are thinking that a
scripted Ansible/Vagrant setup makes sense.
Best regards,
Martin
> On Oct 10, 2015, at 3:44 PM, Adrian Klaver wrote:
>
> On 10/10/2015 12:02 PM, Chuck Martin wrote:
>>
>>> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote:
>>>
>>> On 09/05/2015 02:27 PM, Chuck Martin wrote:
>>>>> On Sep 5, 2015, at 4:
> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote:
>
> On 09/05/2015 02:27 PM, Chuck Martin wrote:
>>> On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote:
>>>
>>> On 09/05/2015 11:00 AM, Chuck Martin wrote:
>
>>>>
>>>> I had
> On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote:
>
> On 09/05/2015 11:00 AM, Chuck Martin wrote:
>> Thanks for responding Adrian.
>>
>> After writing this, I noticed that the list is configure to reply to sender.
>> I hope this is not inappropriate. P
inside the transaction block doesn't prevent the constraint violation,
either.
On 28/04/2015 2:16 PM, John McKown wrote:
On Mon, Apr 27, 2015 at 7:45 AM, Evan Martin
mailto:postgre...@realityexists.net>>wrote:
I submitted the following bug report through the web form a few
d
I submitted the following bug report through the web form a few days
ago. It's causing problems in my application and I've been unable to
find a way to get around it. If someone here, familiar with PostgreSQL
internals, could suggest a workaround I'd really appreciate it!
I have a deferred EX
Thanks Vincent for your response. I had used the wrong set up program.
Martin
-Original Message-
From: Vincent Veyron [mailto:vv.li...@wanadoo.fr]
Sent: Wednesday, March 11, 2015 12:57 PM
To: Martin Caverly
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] FW: Instal
for fresh installation.
[cid:image001.png@01D05A5D.64405360]
Thanks
From: selenama...@gmail.com [mailto:selenama...@gmail.com] On Behalf Of Selena
Deckelmann
Sent: Monday, March 09, 2015 11:31 AM
To: Martin Caverly
Subject: Re: Installation
Please contact
pgsql-general@postgresql.org
Hello,
I'm using PostgreSQL 9.2.8 via Npgsql 2.2.0. When a query times out it
returns error 57014 with the message "canceling statement due to
statement timeout". I use the message to detect the timeout and re-try
in some cases. It seems a bit wrong to rely on the message, though - I
presume
You are right that I need an intermediate step. I will probably use a CSV
parser that is liberal in what it accepts, but writes out strict CSV data
suitable for postgres.
Thanks for the help.
On 17 September 2014 15:40, Adrian Klaver wrote:
> On 09/17/2014 06:48 AM, Martin Waite wr
Hi Adrian,
I apologise - I meant 9.4
regards,
Martin
On 17 September 2014 14:35, Adrian Klaver wrote:
> On 09/17/2014 03:03 AM, Martin Waite wrote:
>
>> Hi,
>>
>> I have a postgresql 7.4 server and client on Centos 6.4. The database
>> server is using UTF-8 enc
ted behaviour ?
Is it the case that the server does the actual CSV parsing, and that given
that my server is in UTF8, I am therefore limited to single-byte UTF8
characters ?
regards,
Martin
library.
Kind regards, Martin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
18 jul 2014 kl. 17:31 skrev Dennis Jenkins :
> On Fri, Jul 18, 2014 at 10:16 AM, Andrew Pennebaker
> wrote:
> Could we please have the PostgreSQL lexer treat #!... on the first line of a
> file as a comment? This would enable .psql scripts to be run with dot-slash
> notation preferred by many
+1
Skickat från min iPhone
> 18 jul 2014 kl. 17:58 skrev Adrian Klaver :
>
>> On 07/18/2014 08:52 AM, Karsten Hilbert wrote:
>> On Fri, Jul 18, 2014 at 08:32:53AM -0700, Adrian Klaver wrote:
>
>>
>> I think the OP is talking about executable scripts so both of
>>
>>$> psql -f the-file.sql
Hi!
Never mind this one.
Wrong config of synchronous replication by me.
It looks good once I got the replication setup correctly.
Kind regards, Martin
13 jul 2014 kl. 23:10 skrev Martin Gudmundsson :
> Hi!
> I wanted to test synchronous bi-dircetional replication
local_dsn = 'dbname=bdrdemo user=postgres port=5432’
It seems to work fine. Bringing down one node stalls the other one, just like
synch rep should.
But the view pg_stat_replication view shows async in sync_state column.
Shouldn’t this really be sync?
Kind regards, Martin
--
Sent via p
13 jul 2014 kl. 21:54 skrev Martin Gudmundsson :
>
>> I think we (as in postgres) will probably get the ability to run
>> individual transactions in such a mode, but you surely wouldn't want to
>> run every transaction in it.
>>
>
> So, would then
> I think we (as in postgres) will probably get the ability to run
> individual transactions in such a mode, but you surely wouldn't want to
> run every transaction in it.
>
So, would then these transactions be ”2-phase”?
I mean either all nodes commit the transaction or none of them do?
Or o
12 jul 2014 kl. 12:33 skrev Andres Freund :
> On 2014-07-12 18:22:30 +0800, Craig Ringer wrote:
>> On 07/12/2014 02:24 PM, Martin Gudmundsson wrote:
>>> Any ideas giving BDR an option to be synchronous. I mean in ”close
>>> quarters” with low latency it should wor
kept low. But if there could be a mix of synch and async nodes in a
BDR group, it could cover more HA.
Hope that explains a bit more what I’m thinking about.
Currently I’m just looking at what BDR could give us here, so it’s nice to
understand your plans. No real projects ongoing currently.
12 jul 2014 kl. 14:48 skrev Andres Freund :
> On 2014-07-12 14:37:02 +0200, Martin Gudmundsson wrote:
>>> It's possible to do it to a streaming replication sync standby, but also
>>> to another BDR node. The logical decoding facility added in 9.4 allows
>>> l
12 jul 2014 kl. 04:58 skrev Craig Ringer :
> On 07/12/2014 02:42 AM, Martin Gudmundsson wrote:
>> Hi all!
>> I was wondering if there are any specific load balancing/failover
>> functionality planned for client drivers connection to a BDR group. In my
>> case th
>>
>> Because BDR is asynchronous multi-master _replication_ though, clients
>> are expected to be aware of some of the anomalies that can occur. A
>> naïve client that just picked a random BDR server and did the next
>> transaction on it would be very likely to cause unwanted replication
>> anom
12 jul 2014 kl. 13:45 skrev Andres Freund :
> On 2014-07-12 13:23:08 +0200, Martin Gudmundsson wrote:
>>
>> 12 jul 2014 kl. 12:33 skrev Andres Freund :
>>
>>> On 2014-07-12 18:22:30 +0800, Craig Ringer wrote:
>>>> On 07/12/2014 02:24 PM, Martin Gudmun
automatic client failovers, in the case there is a server side failover.
Anyone who knows if there is anything in progress regarding this?
Kind regards, Martin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
> My extension has a config table that is dumped by pg_dump and
> populated by pg_restore.
> However, this table has triggers on it that I would like not to do
> anything if the table is being populated by pg_restore. I want the
> triggers to operate only if the user is manipulating the table
>
pgsql-general-ow...@postgresql.org wrote on 17/03/2014 12:50:20:
> From: José Pedro Santos
> To: Postgres Ajuda ,
> Date: 17/03/2014 12:56
> Subject: [GENERAL] Dump Database
> Sent by: pgsql-general-ow...@postgresql.org
>
> Dear all,
>
> I'm trying to dump my database using the following comm
Hi All,
I have a database schema where if row is deleted from one table the rows
it references in another table should also be deleted, unless still
referenced by something else.
Eg. Table A has foreign key to table B. When I delete a row from A I
also want to delete the referenced row in B,
#x27;s possible that I've lost data somewhere.
Is there anything sensible I can do beyond restoring from the last good
backup?
Thanks
Martin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 04/02/2014 19:56, David Johnston wrote:
No, they cannot. If the arguments change you are dealing with an entirely
new object. And often you end up keeping the old function around for
backward-compatibility.
Of course, I understand that it's a different object, technically, but
from the user
In a nutshell: I think the difficulty of dropping functions is
inconsistent with the difficulty of dropping other objects and I'd like
to see this inconsistency fixed.
So I don't agree with the suggestion of matching function names using a
regex, since that's not supported for other types of o
ads of a
given function name..."
Regards,
Evan
On 03/02/2014 19:09, Tom Lane wrote:
Evan Martin writes:
Is there any easy way to drop a function (all overloads of it) without
knowing the parameter types?
Something along the lines of
do $$
declare fname text;
begin
for fname in sel
Hi All,
Is there any easy way to drop a function (all overloads of it) without
knowing the parameter types? If not, it would be good to see it added.
When I change a function definition I just want to run the SQL script
that defines it and have any existing function replaced. CREATE OR
REPLA
I'd like to rename one of the labels of an enum in PostgreSQL 9.2 This
can easily be done by updating pg_enum, as described at
http://tech.valgog.com/2010/08/alter-enum-in-postgresql.html but I'd
like to understand: what is the danger of doing so? If, as the post
says, the data only references
though, and such pain points are unnecessary. Backups and restores
should "just work". They do in MSSQL and I think they can in Postgres, too.
Regards,
Evan
On 04.09.2013 23:26, David Johnston wrote:
Evan Martin wrote
When I use pg_restore with --clean to restore a PostgreSQL 9.2.
Johnston wrote:
Evan Martin wrote
Also, even without --clean I get 3 errors:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 6755; 2618 4417788 RULE
geometry_columns_delete em
pg_restore: [archiver (db)] could not execute query: ERROR: rule
ould
want any existing function with the same signature to be overwritten.
On 04.09.2013 18:20, Adrian Klaver wrote:
On 09/04/2013 07:02 AM, Evan Martin wrote:
Also, even without --clean I get 3 errors:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Erro
d NOT do
> this. I must confess, it seems so straightforward that I feel like I
> must be missing something.
I do something similar with my OpenERP setup. The only caveat I have is
that foreign key constraints don't work with partitioned tables.
Martin
--
Sent via pgsql-genera
When I use pg_restore with --clean to restore a PostgreSQL 9.2.4database
into a new, blank database it generates thousands of error messages like
this:
pg_restore: [archiver (db)] could not execute query: ERROR: schema
"myschema" does not exist
Command was: DROP INDEX myschema.some_index
t=# create table v(item text, lifetime tstzrange, value text,
test(# exclude using gist (item with =, lifetime with &&));
CREATE TABLE
test=#
Is there any reason that the required uuid access method isn't implemented?
How hard is it to implement this?
Thanks,
Martin
--
Sent via
xperience creates the smallest diffs (actually ed scripts).
Apply them with
patch -e
Martin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ield values for
NEW or OLD? (I need it to check users permissions at row level, etc.)
I tried NEW.((created).by), NEW.(created.by), NEW.created.by and nothing
works...
Could you help me please?
Thanks in advance.
Martin
but I'm quite newbie...
Regards,
-Mensaje original-
De: Vincent Veyron [mailto:vv.li...@wanadoo.fr]
Enviado el: viernes, 07 de junio de 2013 14:41
Para: Aitor Gil Martin
CC: pgsql-general@postgresql.org
Asunto: Re: [GENERAL] Open bytea files (images, docs, excel, PDF) stored in
Postg
Hi,
I,ve got a clients table in PostgreSQL. Each client has different
documents (more than 7.000 files in total in different extensions JPG,
XLS,DOC,PDF...) stored in a bytea field in another PostgreSQL Table. My
intention is to create a form using Microsoft Access (or some other
software) to be a
Which versions of Postgres support LOB?
Which versions of Postgres does Hibernate 3.2.6..(Gavin left no clues in the
Hibernate docs)?Thanks!
Martin Gainty
__
Jogi és Bizalmassági kinyilatkoztatás/Verzicht und
Vertraulichkeitanmerkung/Note de déni
Hi Guys
anyone know where I can zip or tar version of PostgreSQL 8.4 ?
Thanks!
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité.
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
number
I am unableto answer your query without those details
Martin Gainty
__
alteration or disrupt this transmission of electronic transmissions is a
violation of US Federal Statutes and will be prosecuted to the fullest extent
of applicable Federal
ured tables (eliminates
> the need to write lots of special parsers to be able to impose
> structure on what would otherwise be unstructured "bytes")
> MG>so do you reduce CPU or IO when you take a java variable final int foo=1;
> and insert foo as a const column in a t
until 1 Jan 2013! so...why doesn't Postgres port to embedded systems?
Martin Gainty
__
...place long-winded disclaimer here... Date: Thu, 27 Dec 2012 08:45:22 +1300
From: gavinflo...@archidevsys.co.nz
To: adrian.kla...@gmail.com
CC: mgai...@hotmai
1 - 100 of 690 matches
Mail list logo
