Re: [ADMIN] postgresql server crash on windows 7 when using plpython

On 9/08/2011 10:54 PM, c k wrote: Normal python functions returning text etc. are working but when conatining import sys from uuid import getnode as get_mac mac = get_mac() return mac fails. What will be the reason? You still haven't supplied the error message you get when you run this. In

Re: [ADMIN] Character set equivalent for AL32UTF8

On 2/08/2011 8:52 PM, RBharathi wrote: Hi, We plan to migrate data from Oracle 11g with characterset AL32UTF8 to a Postgres db. What is the euivalent charecterset to use in Postgress. We see only the UTF-8 option. What's AL32UTF8 ? That's not a standard charset name or widely recognised cha

Re: [ADMIN] Postgres process

On 9/08/2011 11:26 AM, iliya g wrote: Hi guys, I need some help discovering the processes that run on an instance. I know that there are many processes running on one instance and they are all called postges, but I was hoping you can help me find a way to uniquely identify each one of them. I wa

Re: [ADMIN] Postgresql 9.0.1 installation error

On 9/08/2011 2:31 PM, Venkat Balaji wrote: Hi Craig, Thank you very much for your reply ! Here is my reply - 1. We are using RHEL with the below version Linux version 2.6.18-194.26.1.el5 (mockbu...@x86-004.build.bos.redhat.com ) (gcc version 4.1.2

Re: [ADMIN] Fwd: Suspected Postgres Datacorruption

On 4/08/2011 1:14 AM, Sumeet Jauhar wrote: 1 . There was a system crash due to a hardware failure . A ) Isn’t Postgres database resilient enough to handle hardware system failure ? or it sometime results in a corrupt index for its tables ? I You should *always* be able to pull the plug out

Re: [ADMIN] [GENERAL] postgresql server crash on windows 7 when using plpython

Here is the actual function. create or replace function software.python_test() returns text as $body$ import sys from uuid import getnode as get_mac mac = get_mac() return mac $body$ language plpythonu volatile security definer; When running the same code from python prompt, it run correctly witho

Re: [ADMIN] [GENERAL] postgresql server crash on windows 7 when using plpython

On Tue, Aug 9, 2011 at 7:54 AM, c k wrote: > Dear Friends, > For client requirements, I am testing postgresql 9.0.4 on windows 7 with > plpython. First I installed python 2.7 and then added python installation > path to windows PATH variable. Then installed postgresql from one-click > installer.

Re: [ADMIN]

Hi, please don't answer this thread, I did the stupid mistake of forgetting the subject. Please, read this instead: http://archives.postgresql.org/pgsql-admin/2011-08/msg00055.php -- Diego Augusto Molina diegoaugustomol...@gmail.com ES: Por favor, evite adjuntar documentos de Microsoft Office. S

Re: [ADMIN] Read-only postgres instance

Creating a temp table is not a read-only operation. On Aug 9, 2011, at 11:19 AM, pasman pasmański wrote: > What with queries need temporary tables? -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admi

Re: [ADMIN] Read-only postgres instance

What with queries need temporary tables? 2011/8/5, Vladimir Protasov : > Hi, guys! > I want to completely disallow postgres to write WAL and turn it to read-only > instance WAL-compatible with another instance. > It is guarantied that there will be no write queries to the server, but I > need to b

Re: [ADMIN] Postgres process

Thanks, Tom. Let me look into this. Sent from Yahoo! Mail on Android

Re: [ADMIN] Read-only postgres instance

Vladimir Protasov wrote: > I want to completely disallow postgres to write WAL and turn it to > read-only instance WAL-compatible with another instance. > It is guarantied that there will be no write queries to the > server, but I need to be sure about WAL. Have you considered setting it up

Re: [ADMIN] Postgres process

Ahh,,, I missed this.. :) Thank you Tom for pointing to appropriate direction. Below command worked /usr/ucb/ps -ww --Raghav On Tue, Aug 9, 2011 at 9:15 PM, Tom Lane wrote: > Raghavendra writes: > > Still, my guess we cannot get the process description on SunOS. > > I surely hope you're not

Re: [ADMIN] Dump SQL DDL of all functions in DB

"Bradley Holbrook, Servillian Technology" writes: > Anyone know how to dump the DDL of every function in a schema into one file? > > Essentially, Iùd like to do something like: > > øfunctions ddl dump cmdù public functions.sql select pg_get_functiondef(p.oid) || ';' from pg_proc p join pg_namesp

Re: [ADMIN] PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable)

jtke...@verizon.net writes: > postgresql 8.4.8 64 bit /Ubuntu 10.4 64 bit > When I try to connect to postgresql from a local user on the same > machine that postgresql is running on I receive the following: > psql > Error: /pgdata/data is not accessible; please fix the directory > permissions (/pg

Re: [ADMIN] Postgres process

Raghavendra writes: > Still, my guess we cannot get the process description on SunOS. I surely hope you're not still running SunOS. If you mean Solaris, note what the manual says at http://www.postgresql.org/docs/9.0/static/monitoring-ps.html Tip: Solaris requires special handling. You must

[ADMIN] pg-8.4 dump database roles

Hi, I've been searching a way to fully restore a database with it's roles. I've got a cluster with many db's in which I don't have many privileges in addition. I need to migrate that database to a cluster of our possesion. I've been reading the docs in the section of the catalogs to figure out how

Re: [ADMIN] PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable)

I found something out but not sure I understand why this is causing an issue: find / -name psql -print -exec ls -l {} \; /usr/bin/psql -> ../share/postgresql-common/pg_wrapper /usr/lib/postgresql/8.4/bin/psql The search path was finding the first entry. When I put the "/usr/lib/p

Re: [ADMIN] Dump SQL DDL of all functions in DB

On 08/03/2011 04:35 PM, Bradley Holbrook, Servillian Technology wrote: > Anyone know how to dump the DDL of every function in a schema into one file? > > Essentially, I’d like to do something like: > > ‘functions ddl dump cmd’ public functions.sql The easiest way is probably to do a schema-only

Re: [ADMIN] Streaming replication between x86 and x86_64 hosts

Nope. SR supports with the same file-system architecture between Master and Slave. --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Thu, Aug 4, 2011 at 7:38 PM, pawcyk wrote: > Hi, > > I'm trying set up streaming replication between two different archite

Re: [ADMIN] Postgres process

I go with Kevin. Still, my guess we cannot get the process description on SunOS. --Raghav On Tue, Aug 9, 2011 at 8:18 PM, Kevin Grittner wrote: > iliya g wrote: > > > The problem is that when I run ps - ef l grep postgres, I only get > > postgres and not the process description. > > It's hard t

Re: [ADMIN] PD_ALL_VISIBLE flag set - autovacuum ignoring dead tuples

Tom Lanyon writes: > I'm seeing a heavy-update TOAST table which is not being effectively > autovacuum'd on 8.4.5. The stats collector shows n_dead_tup growing very > quickly, and autovacuum runs frequently, but never removes any dead tuples. > A manual vacuum does find many dead tuples (90+

[ADMIN] PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable)

postgresql 8.4.8 64 bit /Ubuntu 10.4 64 bit When I try to connect to postgresql from a local user on the same machine that postgresql is running on I receive the following: psql Error: /pgdata/data is not accessible; please fix the directory permissions (/pgdata/ should be world readable) whats

[ADMIN] postgresql server crash on windows 7 when using plpython

Dear Friends, For client requirements, I am testing postgresql 9.0.4 on windows 7 with plpython. First I installed python 2.7 and then added python installation path to windows PATH variable. Then installed postgresql from one-click installer. Server started and every thing was ok. Then I go to cre

Re: [ADMIN] Postgres process

iliya g wrote: > The problem is that when I run ps - ef l grep postgres, I only get > postgres and not the process description. It's hard to know what advice to give without more information. Could you post the output of the query shown on this page?: http://wiki.postgresql.org/wiki/Server_

[ADMIN] Streaming replication between x86 and x86_64 hosts

Hi, I'm trying set up streaming replication between two different architecture x86 (master) and x86_64 (slave). I fallowed guide http://wiki.postgresql.org/wiki/Streaming_Replication and stuck after copy data directory from master to slave. When I'm trying run postgres on slave I'm getting fallowi

[ADMIN] Dump SQL DDL of all functions in DB

Anyone know how to dump the DDL of every function in a schema into one file? Essentially, I'd like to do something like: 'functions ddl dump cmd' public functions.sql Bradley A Holbrook Sr. Web Developer Servillian Technology Ltd http://www.servillian

[ADMIN] PD_ALL_VISIBLE flag set - autovacuum ignoring dead tuples

I'm seeing a heavy-update TOAST table which is not being effectively autovacuum'd on 8.4.5. The stats collector shows n_dead_tup growing very quickly, and autovacuum runs frequently, but never removes any dead tuples. A manual vacuum does find many dead tuples (90+ % of the table) to remove,

[ADMIN] Characterset Equivalent for AL32UTF8 in Postgres

Hi, We are planning to migrate our db from Oracle 11g r2 presently using characterset AL32UTF8 to Postgress. We would like to know the equivalent character set information for postgress for AL32UTF8. Regards, rbharathi -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make c

[ADMIN] migration wizard faild

EnterpriseDB - MySQL to PostgreSQL Migration Wizard system:windows db:MySQL ver 4.0 I try... connection ok 4. Source schema "No schema/tables in this view" Not support MySQL ver 4.0 ? or is it some other problems? best regards Gustav -- Sent via pgsql-admin mailing lis

[ADMIN] Read-only postgres instance

Hi, guys! I want to completely disallow postgres to write WAL and turn it to read-only instance WAL-compatible with another instance. It is guarantied that there will be no write queries to the server, but I need to be sure about WAL. Is it possible? -- Best regards, Vladimir Protasov. --

[ADMIN] Fwd: Suspected Postgres Datacorruption

Hi All , Can you please help me out with the following questions . Our application is running on Postgres 7.4.X . I agree that this is a very old version of Postgres and we should have upgraded . The issue that we faced is that 1 . There was a system crash due to a hardware failure . 2 .

[ADMIN] my table is empty, pg_relation_size(name) return 38 MB

Hi Team, Though my table is empty, pg_relation_size(name) return 38 MB. I use below query to determine tables disk usages. SELECT nspname || '.' || relname AS "Table", pg_total_relation_size(C.oid) "Size", pg_size_pretty(pg_total_relation_size(C.oid)) AS "Total size" FROM pg_class C L

[ADMIN] Character set equivalent for AL32UTF8

Hi, We plan to migrate data from Oracle 11g with characterset AL32UTF8 to a Postgres db. What is the euivalent charecterset to use in Postgress. We see only the UTF-8 option. Please let me know. RBharathi -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to yo

Re: [ADMIN] Postgres process

Only active 'postgres' process you can see with description, rest will be in 'IDLE'. Moreover, which operating system you are in.. --Raghav On Tue, Aug 9, 2011 at 7:54 PM, iliya g wrote: > Thanks, Raghavendra. > > The problem is that when I run ps - ef l grep postgres, I only get postgres > and

Re: [ADMIN] Postgres process

Thanks, Raghavendra. The problem is that when I run ps - ef l grep postgres, I only get postgres and not the process description. I can't see what kind of process it is and if it is a logger process or writer or stats collector. I get this at he end: .../pgsql/bin/postgres Sent from Yaho

Re: [ADMIN] Postgres process

Hi, I need some help discovering the processes that run on an instance. I know > that there are many processes running on one instance and they are all > called postges, but I was hoping you can help me find a way to uniquely > identify each one of them. I want to discover what the process name is

Re: [ADMIN] Postgresql 9.0.1 installation error

Hi, I tried installing without "--with-openssl" option. The installation was successful and ./psql is working perfectly ok. So, i suspect this is because of enabling openssl option. Thanks Nag On Tue, Aug 9, 2011 at 12:01 PM, Venkat Balaji wrote: > Hi Craig, > > Thank you very much for your re

[ADMIN] LDAP configuration

Hello, I need help on configuring LDAP for PostgreSQL 9.0.1. The Postgres cluster should allow only LDAP connections from remote clients. I have PG-9.0.1 built with LDAP option. Please help ! Thanks Nag