Hi,
I'm a beginner with pgsql and have the following problem. I have written
a pl/python procedure to query geolocations (with the library geopy). It
inserts them into a table. All this works perfectly.
The problem is the configuration with the network connections. I'm using
pgsql in a private la
Hey,
Thanks for the reply, this helped me very much.
Kind Regards,
Aviel Buskila.
בתאריך 17 באוג' 2015 08:49, "Jony Cohen" כתב:
> Hi,
> The clone command just clones the data from node2 to node1, you need to
> also register it with the `force` option to override the old record. (as if
> you're b
I want to index the textual representations of a table's rows.
You can cast a row to text by using the name of the table where you would
usually use the name of a column, like "table_name::text". But this is not
immutable and so can't be used in an expression index.
I can easily make a pl/perl f
On Thu, Aug 20, 2015 at 9:50 AM, Laurent Laborde
wrote:
> Friendly greetings !
>
> I'm wondering if anyone tried the following hot backup process, and if it
> works :
> pg_start_backup()
> zfs snapshop
> pg_stop_backup()
>
> copy the snapshot to the backup server.
>
That is how I currently handl
On 2015-08-20 07:50, Laurent Laborde wrote:
> I'm wondering if anyone tried the following hot backup process, and if it
> works :
> pg_start_backup()
> zfs snapshop
> pg_stop_backup()
>
> copy the snapshot to the backup server.
I have done this with AWS EBS snapshots, created new volumes from th
Friendly greetings !
I'm wondering if anyone tried the following hot backup process, and if it
works :
pg_start_backup()
zfs snapshop
pg_stop_backup()
copy the snapshot to the backup server.
Thx :)
PS : the WAL will still be archived the usual way.
--
Laurent "ker2x" Laborde
On Wed, Aug 19, 2015 at 5:55 AM, tonymark09 wrote:
> Hello,
>
> Is preparing a statement using PQexec and executing it is much slower that
> using other API such as PQprepare and PQexecPrepared?
PQexec can be faster than a combination of PQprepare and
PQexecPrepared particularly if you only need
