Matthew Chambers wrote:
> Would something like this work best, or is it better to use pgdump?
>
> CREATE DATABASE newDatabase TEMPLATE oldDatabase ENCODING 'UTF8'
>
> Does using a template do a file system copy or just SQL copy everything over?
Using the old database as template will not change
On 15 Oct 2014, at 4:33, Abelard Hoffman wrote:
> I believe this query is well optimized, but it's slow if the all the blocks
> aren't already in memory.
>
> Here's example explain output. You can see it takes over 7 seconds to run
> when it needs to hit the disk, and almost all of it is rela
Hello and thank you for reading my post.
My question is about starting PostgreSQL clusters at boot time.
The OS is Debian Wheezy.
I have installed PostgreSQL from the sources (postgresql-9.3.5.tar.gz) at
http://www.postgresql.org/ftp/source/v9.3.5/.
In a shell and logged as "unprivileged_user" (
Hi,
2014-10-15 12:18 GMT+02:00 Léa Massiot :
> Hello and thank you for reading my post.
>
> My question is about starting PostgreSQL clusters at boot time.
>
> The OS is Debian Wheezy.
> I have installed PostgreSQL from the sources (postgresql-9.3.5.tar.gz) at
> http://www.postgresql.org/ftp/sour
It's perfect.
Thank you very much.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-start-several-PostgreSQL-clusters-at-boot-time-on-a-Debian-OS-tp5823085p5823088.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-gen
On 10/15/2014 03:18 AM, Léa Massiot wrote:
Hello and thank you for reading my post.
My question is about starting PostgreSQL clusters at boot time.
The OS is Debian Wheezy.
I have installed PostgreSQL from the sources (postgresql-9.3.5.tar.gz) at
http://www.postgresql.org/ftp/source/v9.3.5/.
I
HI,
PQerrorMessage pirints the error message like (no space available,etc). Does
postgres provide
any API which gives the error code listed in the below appendix;
http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html
I need the exact error code so that I can shutdown my application
"Roopeshakumar Narayansa Shalgar (rshalgar)" writes:
> HI,
> PQerrorMessage pirints the error message like (no space available,etc). Does
> postgres provide
> any API which gives the error code listed in the below appendix;
> http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html
Use
On 10/15/2014 02:17 AM, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
HI,
PQerrorMessage pirints the error message like (no space
available,etc). Does postgres provide
any API which gives the error code listed in the below appendix;
http://www.postgresql.org/docs/9.1/static/errcodes-ap
Thanks Tom,
But that's not what I am looking for.
I need the 'integer' errorcode equivalent of " errormsg string" returned by
PQerrorMessage.
/rK
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, October 15, 2014 10:07 PM
To: Roopeshakumar Narayansa Sha
On 10/15/2014 9:48 AM, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
I need the 'integer' errorcode
SQLSTATE Error codes are NOT integers, they are strings. note there's
stuff in there like 0100C, 01P01, etc.
--
john r pierce 37N 122W
somewhere on t
I was just reading the PL/Python docs section "42.7.1 Database Access
Functions" and saw this example:
CREATE FUNCTION usesavedplan() RETURNS trigger AS $$
plan = SD.setdefault("plan", plpy.prepare("SELECT 1"))
# rest of function
$$ LANGUAGE plpythonu;
The above example uses the plpy.prep
On 10/15/2014 02:39 PM, Jonathan Rogers wrote:
I was just reading the PL/Python docs section "42.7.1 Database Access
Functions" and saw this example:
CREATE FUNCTION usesavedplan() RETURNS trigger AS $$
plan = SD.setdefault("plan", plpy.prepare("SELECT 1"))
# rest of function
$$ LANGUA
Adrian Klaver writes:
> On 10/15/2014 02:39 PM, Jonathan Rogers wrote:
>> I was just reading the PL/Python docs section "42.7.1 Database Access
>> Functions" and saw this example:
>>
>> CREATE FUNCTION usesavedplan() RETURNS trigger AS $$
>> plan = SD.setdefault("plan", plpy.prepare("SELECT 1"))
On 10/15/2014 05:51 PM, Adrian Klaver wrote:
> On 10/15/2014 02:39 PM, Jonathan Rogers wrote:
>> I was just reading the PL/Python docs section "42.7.1 Database Access
>> Functions" and saw this example:
>>
>> CREATE FUNCTION usesavedplan() RETURNS trigger AS $$
>> plan = SD.setdefault("plan",
Dear All,
I am facing some issue during postgresql service stop.
Issue:-
[root@localhost postgresql-9.0.18]# runuser -l postgres -c
'/usr/pgsql/bin/pg_ctl stop -D '\''/var/lib/pgsql/data'\'' -s -m fast'
/usr/pgsql/bin/pg_ctl: error while loading shared libraries: libpq.so.5: cannot
open shared o
On 10/15/2014 8:10 PM, Yogesh. Sharma wrote:
I am facing some issue during postgresql service stop.
Issue:-
[root@localhost postgresql-9.0.18]# runuser -l postgres -c
'/usr/pgsql/bin/pg_ctl stop -D '\''/var/lib/pgsql/data'\'' -s -m fast'
/usr/pgsql/bin/pg_ctl: error while loading shared libr
On 10/15/2014 08:21 PM, John R Pierce wrote:
On 10/15/2014 8:10 PM, Yogesh. Sharma wrote:
I am facing some issue during postgresql service stop.
Issue:-
[root@localhost postgresql-9.0.18]# runuser -l postgres -c
'/usr/pgsql/bin/pg_ctl stop -D '\''/var/lib/pgsql/data'\'' -s -m fast'
/usr/pgsql
18 matches
Mail list logo
