On Thu, Sep 11, 2014 at 08:40:21AM +0200, Rémi Cura wrote:
> It is also easy to backup (but very slow due to huge iso file).
- rsync when you plug in
- make a copy
- rsync to copy continously during work
(note that this rsynced copy will be inconsistent,
it only serves to speed up the last st
On Wed, 10 Sep 2014 14:19:45 -0700, John R Pierce
wrote:
>also, Windows disables writeback caching on external disks, this will
>greatly slow down update transactions.
Not exactly. By default, write caching is disabled for external
drives to support quick disconnect, i.e. yanking the device wi
Has anyone tried the OPM? I followed the installation instruction and in the
end I got a blank web page...
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of damien clochard
Sent: Tuesday, September 09, 2014 1:23 AM
To: p
Le 11/09/2014 09:21, Huang, Suya a écrit :
> Has anyone tried the OPM? I followed the installation instruction and in the
> end I got a blank web page...
>
Hi,
We're trying to improve our documentation and especially the install
instructions. Can you provide more information about your setup
"McGehee, Robert" writes:
> SELECT n.node, sum(students) as students
> FROM tree_tbl t, node_tbl n
> WHERE t.course ~ '.*' || n.node || '.*'
> GROUP BY n.node;
I'd write this as
SELECT n.node, sum(students) AS students
FROM tree_tbl t
JOIN node_tbl n ON t.course ~ ('*.' || n.node || '.*')::lque
Hello,
The server for my websites was recently changed and upgraded. I have ssh
access to the server and since the upgrade I am no longer able to use
"pg_dump" to perform scripted backups. I've written to the site's
support services, but until now, they've not been able to help (they've
responded
Hey,
if you are using postgis and postgis_topology,
there are specific backup/restore process.
Cheers,
Rémi-C
2014-09-11 12:49 GMT+02:00 Iain Mott :
> Hello,
>
> The server for my websites was recently changed and upgraded. I have ssh
> access to the server and since the upgrade I am no longer ab
Thanks Rémi-C for the quick reply. By coincidence my site does involve
mapping, however I wasn't aware that the server might be using postgis
and postgis_topology. In psql when I type "\d" i get the following:
public | comentarios | tabela | myusername
public | featuredata | tabela
Yep,
this means you are using postgis.
I don't know if you use postgis topology.
If you have a schema topology containing a topology table, then you also
have postgis_topology installed.
You can check this with this query : "SELECT postgis_full_version();"
Maybe the extensions have been created w
Thanks a lot. Here is the response to
=> SELECT postgis_full_version();
postgi
s_full_version
Wow, I was not expecting so many skillful feedbacks - Thanks to all
I am not closing the point yet since, as Steve Crawford suggested, the
solution I am looking for (as newbie) might not be optimal !-) So here is
more context.
All PCs run W7/64b (different hardware) and I will be the only u
On 09/11/2014 04:37 AM, Iain Mott wrote:
Thanks a lot. Here is the response to
=> SELECT postgis_full_version();
postgi
So what does pgAdmin show for ownership of the schemas?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Iain Mott writes:
> Here's what happens (the important error messages are in English):
> [~]# pg_dump mydatabase > dump.sql
> pg_dump: comando SQL falhou
> pg_dump: Mensagem de erro do servidor: ERROR: permission denied for schema
> topology
> pg_dump: O comando foi: LOCK TABLE topology.topolog
Thank you Damien, issues updated. https://github.com/OPMDG/opm-core/issues/2
-Original Message-
From: damien clochard [mailto:dam...@dalibo.info]
Sent: Thursday, September 11, 2014 5:36 PM
To: Huang, Suya; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Introducing Open PostgreSQL Mon
On 09/11/2014 05:50 AM, Steve Crawford wrote:
> 2. OS mismatch. Have you ensured that all client machines are running
> identical setups? The underlying files are not guaranteed portable
> between OS versions and 64/32-bit. In fact they probably won't be.
You can just run 32-bit Pg on both the 32-
On 09/11/2014 03:16 PM, George Neuner wrote:
>
> If the driver permits it and you [or your users] can be trusted to
> perform a safe unmount via the OS *before* disconnecting the device,
> then you can enable write caching for the device using the device
> manager. [Note that the device must be c
Hello,
>There are pros and cons to this approach. In general, I'd recommend
>using a simple view instead of trying to use the search_path- for
>example, prepared queries will look up the OID based on the current
>search_path. If you prepare a query, then change your search_path, and
>run tha
Vinayak writes:
> Is it possible to parse the CREATE SYNONYM statement and convert into CREATE
> VIEW statement using post_parse_analyze_hook? or is there any other idea to
> automate this process?
You will not be able to do it without modifying the grammar. SYNONYM
isn't even a keyword in stock
Hi all
(This is really about the EDB installer, but we don't have anywhere
better to discuss it than -general, so):
The PostgreSQL installer now uses the NETWORKSERVICE account on Windows
by default (as of 9.2), instead of creating a "postgres" account with
username and password. Which is a big i
On Wed, Sep 10, 2014 at 8:43 PM, Tom Lane wrote:
> You'd want to get a new version of the IANA timezone database files for
> that. Depending on what packaging you're using, this might be an
> operating-system update not a Postgres update. If you are relying
> on the Postgres copies, you'd have
20 matches
Mail list logo
