Re: [GENERAL] best solution to backup full user databse

2010-04-19 Thread Vasiliy G Tolstov
On Mon, 2010-04-19 at 09:39 -0600, Scott Marlowe wrote: > On Mon, Apr 19, 2010 at 9:34 AM, Vasiliy G Tolstov > wrote: > > On Mon, 2010-04-19 at 09:18 -0600, Scott Marlowe wrote: > >> pg_dump? > > > > Yes. But this tool can dump all domains, triggers, proced

Re: [GENERAL] best solution to backup full user databse

2010-04-19 Thread Vasiliy G Tolstov
On Mon, 2010-04-19 at 09:18 -0600, Scott Marlowe wrote: > pg_dump? Yes. But this tool can dump all domains, triggers, procedures and functions belongs to specific database ? > > On Mon, Apr 19, 2010 at 9:07 AM, Vasiliy G Tolstov > wrote: > > Hello. I'm new with postgre

[GENERAL] best solution to backup full user databse

2010-04-19 Thread Vasiliy G Tolstov
Hello. I'm new with postgresql (before using mysql). Mysql support to dump all triggers, relations, stored procedures from specific databse to one file. How about this in postgresql? -- Vasiliy G Tolstov Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] cidr data type question

2009-11-02 Thread Vasiliy G Tolstov
В Пнд, 02/11/2009 в 13:29 +0100, Harald Fuchs пишет: > In article <1257149236.3426.9.ca...@localhost>, > Vasiliy G Tolstov writes: > > > Hello. > > I have table with cidr data type column (table is white/black list of > > networks). > > > Does

Re: [GENERAL] cidr data type question

2009-11-02 Thread Vasiliy G Tolstov
В Пнд, 02/11/2009 в 00:34 -0800, John R Pierce пишет: > Vasiliy G Tolstov wrote: > > Hello. > > I have table with cidr data type column (table is white/black list of > > networks). > > > > Does it possible to query - is the some address contains in any cidr &g

[GENERAL] cidr data type question

2009-11-02 Thread Vasiliy G Tolstov
/functions-net.html ) -- Vasiliy G Tolstov Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] log slow queries and hints

2009-10-28 Thread Vasiliy G Tolstov
p postgres[18072]: [5-2] user=dbu_vase_1,db=db_vase_1 HINT: Use the escape string syntax for backslashes, e.g., E'\\'. How can i disable this hints, or (i'm use drupal for this database) fix queries? -- Vasiliy G Tolstov Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] auth problem

2009-10-12 Thread Vasiliy G Tolstov
В Пнд, 12/10/2009 в 15:04 +0300, Peter Eisentraut пишет: > > Use --auth=md5. > Why? crypt is deprecated? -- Vasiliy G Tolstov Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailp

[GENERAL] auth problem

2009-10-12 Thread Vasiliy G Tolstov
ssage appears in syslog: cannot use authentication method "crypt" because password is MD5-encrypted How can i use crypted passwords with pgsql? -- Vasiliy G Tolstov Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

Re: [GENERAL] postgresql error

2009-09-28 Thread Vasiliy G Tolstov
On Mon, 2009-09-28 at 10:22 -0400, Tom Lane wrote: > Vasiliy G Tolstov writes: > >> some time (meybe every four day) postgresql get error to all clients > >> what try to connect , a can attach strace to it: > > >> 1. What error? > > > postg...@calips

Re: [GENERAL] postgresql error

2009-09-28 Thread Vasiliy G Tolstov
В Пнд, 28/09/2009 в 13:11 +0200, Martijn van Oosterhout пишет: > On Mon, Sep 28, 2009 at 02:33:36PM +0400, Vasiliy G Tolstov wrote: > > Hello! > > > > I'm using postgresql (8.0.15) on Gentoo Linux (2.6.27.29-titan #2 SMP > > Sun Aug 16 15:12:53 MSD 2009 x86_64 Inte

[GENERAL] postgresql error

2009-09-28 Thread Vasiliy G Tolstov
8) = 0 select(5, [3 4], NULL, NULL, {60, 0} calipso ~ # cat /proc/sys/kernel/shmmax 33554432 calipso ~ # cat /proc/sys/kernel/shmall 2097152 what is wrong with server? Thank You. -- Vasiliy G Tolstov Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)