[GENERAL] best solution to backup full user databse

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 v.tols...@selfip.ru Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-general

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

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 v.tols...@selfip.ru wrote: Hello. I'm new with postgresql

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

On Mon, 2010-04-19 at 09:39 -0600, Scott Marlowe wrote: On Mon, Apr 19, 2010 at 9:34 AM, Vasiliy G Tolstov v.tols...@selfip.ru wrote: 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

[GENERAL] cidr data type question

-net.html ) -- Vasiliy G Tolstov v.tols...@selfip.ru 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

Re: [GENERAL] cidr data type question

В Пнд, 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 network in this table? (for all networks

Re: [GENERAL] cidr data type question

В Пнд, 02/11/2009 в 13:29 +0100, Harald Fuchs пишет: In article 1257149236.3426.9.ca...@localhost, Vasiliy G Tolstov v.tols...@selfip.ru writes: 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

[GENERAL] log slow queries and hints

[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 v.tols...@selfip.ru Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] auth problem

appears in syslog: cannot use authentication method crypt because password is MD5-encrypted How can i use crypted passwords with pgsql? -- Vasiliy G Tolstov v.tols...@selfip.ru Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] auth problem

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

[GENERAL] postgresql error

~ # cat /proc/sys/kernel/shmmax 33554432 calipso ~ # cat /proc/sys/kernel/shmall 2097152 what is wrong with server? Thank You. -- Vasiliy G Tolstov v.tols...@selfip.ru Selfip.Ru -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] postgresql error

В Пнд, 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 Intel(R) Xeon(R) CPU E5420 @ 2.50GHz

Re: [GENERAL] postgresql error

On Mon, 2009-09-28 at 10:22 -0400, Tom Lane wrote: Vasiliy G Tolstov v.tols...@selfip.ru 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...@calipso ~ $ psql psql: FATAL: semctl(1048608