Dear all,
Please help me.
Please show me how to reduce the size of the archived-log directory.
My postgres database only get 4gbyte but the archived-log directory reaches
several tens of gigabyte in one day.
please give me some advice.
Thanks a lot.
Dear all,
Please help me.
Please show me how to reduce the size of the archived-log directory.
My postgres database only get 4gbyte but the archived-log directory reaches
several tens of gigabyte in one day.
please give me some advice.
Thanks a lot.
--
Best Regards,
Hoàng Thanh Toàn,
D
Pumper wrote
> Hello All,
>
> I am an amateur at db's, but I have built several good ones with OO base.
> I have Postgresql and PgAdmin on Debian 6.
> I am impressed with the features of PgAdmin, but cannot find
> how to enter data with integrity. The only instances of a look-up table
> I have fo
On Wed, Mar 27, 2013 at 1:43 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> On Wed, Mar 27, 2013 at 10:53 PM, Keith Ouellette <
> keith.ouelle...@airgas.com> wrote:
>
>> Is there a way to dump only functions to a directory with each function
>> as its own file in SQL format?
>>
> AF
Try something like this:
for a in `echo "SELECT p.proname
FROM pg_catalog.pg_proc p
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE pg_catalog.pg_function_is_visible(p.oid)
AND n.nspname <> 'pg_catalog'
AND n.nspname <> 'information_schema'"|psql -A -t test`;
do echo "SELECT pg
On Wed, Mar 27, 2013 at 10:53 PM, Keith Ouellette <
keith.ouelle...@airgas.com> wrote:
> Is there a way to dump only functions to a directory with each function
> as its own file in SQL format?
>
AFAIK, there's no direct way to dump each function to a separate file.
However, you can use system-de
Is there a way to dump only functions to a directory with each function as its
own file in SQL format?
Thanks,
Keith
