[GENERAL] 9.2 Replication in Ubuntu ; need help

Hi, I am trying to setup replication with Postgresql 9.2 in Ubuntu on Amazon Ec2. But stuck in the process. Postgresql standby log is showing: 2013-09-12 14:45:47 UTC LOG: entering standby mode 2013-09-12 14:45:47 UTC LOG: redo starts at 1/3920 2013-09-12 14:45:47 UTC LOG: record with zero

Re: [GENERAL] 9.2 Replication in Ubuntu ; need help

Yes, I can access to the primary server perfectly. On Thu, Sep 12, 2013 at 11:55 AM, Suzuki Hironobu wrote: > Hi, > > > (13/09/12 23:53), AI Rumman wrote: > >> Hi, >> >> I am trying to setup replication with Postgresql 9.2 in Ubuntu on Amazon >> Ec2. >

[GENERAL] recover deleted data

Is there any way to recover deleted record in Postgresql 9.2 if we don't have any backup. Thanks.

[GENERAL] what is BIND in OS log for Postgresql

Hi, I got in my OS log using ps command as follows: postgres 17087 2770 0 Sep30 ?00:07:49 postgres: myapp appname 10.0.0.1(35607) BIND postgres 32545 2770 1 Oct01 ?00:19:09 postgres: myapp appname 10.0.0.1(35783) SELECT postgres 32546 2770 1 Oct01 ?00:15:25 postgres:

[GENERAL] when do I analyze after concurrent index creation?

Hi, I have a very basic question. If I create index concurrently, then do I need to analyze the table? If yes, when? Please let me know. Thanks.

[GENERAL] how to get the connected session pointer ( Archive * AH)

Hi, Is there a way in Postgresql C function to get the connected session pointer ( Archive * AH) and use it for further execution? Thanks.

Re: [GENERAL] how to get the connected session pointer ( Archive * AH)

:05 AM, Luca Ferrari wrote: > On Tue, Oct 22, 2013 at 1:32 AM, AI Rumman wrote: > > Hi, > > > > Is there a way in Postgresql C function to get the connected session > pointer > > ( Archive * AH) > > and use it for further execution? > > If I read pg_ar

[GENERAL] pg_start_backup('label',true) why do I need 2nd parameter?

Hi all, A few days back, I faced a problem where I *pg_start_backup('label') *was hang in the server forever. I stopped the process and then used *pg_start_backup('label',true) *and it worked. Now I am trying to investigate why I need to use true as second parameter and read the doc "There is an

Re: [GENERAL] Data Guard for Postgres?

Postgresql 9.2 streaming replication which is very much similar with Oracle Data Guard. On Fri, Dec 13, 2013 at 1:57 PM, Roy Anderson wrote: > Good day. I am inquiring as to whether there is a free solution > available that approximates, in Postgres, what Data Guard does for > Oracle DB. Can any

Re: [GENERAL] Question(s) about crosstab

Hi, Once I faced the same problem of adding new type and reqriting the query working with crosstab function. Then I created a dynamic crosstab function. You may have a look at it if it work out for you: http://www.rummandba.com/2013/03/postgresql-dynamic-crosstab-function.html Thanks. On Tue, D

[GENERAL] Seems like bug in 9.1.3, need to confirm.

HI, I am working on Postgresql 9.1.3. I executed the following query and got an error: select relname, pg_size_pretty(pg_table_size(relname::text)) as s from pg_stat_user_tables order by pg_table_size(relname::text) desc limit 10; ERROR: relation "tab_20130206" does not exist That table does n

[GENERAL] what does the error mean?

Hi, What does the error message mean? ERROR: unexpected chunk number 1 (expected 2) for toast value 179638221 in pg_toast_16700 Please let me know. Thanks.

[GENERAL] EMC SRDF technology for creating replication with Postgresql?

Hi, Did any of here use EMC SRDF technology for creating replication with Postgresql? Thanks.

[GENERAL] When does pg_archivecleanup work?

As I have very low wal_keep_segments compare to my wal generation, I am collecting archive wal files at slave. Now in order to clean up archive wal collection directory at slave, I used "archive_cleanup_command". I watched that after archive wal files were pilling up at slave and after certain poin

Re: [GENERAL] Is it safe to stop postgres in between pg_start_backup and pg_stop_backup?

What we did in this kind of higher performance storage migration, setting up standby on that mounts and then executed a failover. On Thu, Apr 3, 2014 at 3:58 PM, Alan Hodgson wrote: > On Thursday, April 03, 2014 02:48:03 PM Steven Schlansker wrote: > > On Apr 2, 2014, at 3:08 PM, Jacob Scott w

[GENERAL] Is it good to have toast table for information schema table?

Hi, Is it good to have toast table for information schema table? I am using Postgresql 8.4 and current state is: *select datname, datfrozenxid from pg_database; * datname | datfrozenxid ---+-- template1 | 1462730397 template0 | 1462741467 postgres | 1562

[GENERAL] what should be the best autovacuum configuration for daily partition table

Hi, I have a table with daily partition setup where old partitions are static tables that is after each day we don't get any new data in old partitions. The database size is 2 TB and I am running with autovacuum on for Postgresql 8.4. Now, I am facing a problem where old tables are not being vacuu

[GENERAL] invalid byte sequence for encoding "UTF8": 0xf1612220

I am trying to migrate a database from Postgresql 8.2 to Postgresql 8.3 and getting the following error: pg_restore: [archiver (db)] Error from TOC entry 2764; 0 29708702 TABLE DATA originaldata postgres pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for encoding "UTF8": 0x

[GENERAL] What is the average salary for Postgresql DBA

Hey guys, If I get H1B visa as Postgresql DBA, then what may I expect to get as my salary? Does anyone have idea on this? Thanks.

Re: [GENERAL] What is the average salary for Postgresql DBA

sch wrote: > >> On Wed, May 18, 2011 at 10:52 PM, AI Rumman wrote: >> >>> Hey guys, >>> >>> If I get H1B visa as Postgresql DBA, then what may I expect to get as my >>> salary? >>> Does anyone have idea on this? >>> >>> T

[GENERAL] maximum size limit for a query string?

Is there any maximum size limit for a query string in Postgresql 9.0.1? If yes, what is it ?.

[GENERAL] system command in dblink?

Is it possible to execute system commands in dblink connections? I need to execute \i /tmp/test.sh in a remote connection from my psql client prompt. I connected with the remote db using dblink_connect. select dblink_connect('conn_1', 'dbname=newdb'); Any help please.

[GENERAL] how to install plpython?

Hi guys, I need to install plpython language in my db. testdb=# create language plpythonu; ERROR: could not access file "$libdir/plpython": No such file or directory -bash-3.2$ pwd /usr/pgsql-9.0/lib -bash-3.2$ ls pl* plpgsql.so testdb=# select * from pg_pltemplate; tmplname | tmpltrusted |

[GENERAL] duplicate key violate error

Hi, I got duplicate key violate error in the db log for the following query: INSERT INTO tab1 ( SELECT '1611576', '1187865' WHERE NOT EXISTS ( SELECT 1 FROM tab1 WHERE id='1611576' AND id2='1187865')) The error occured during production time. But when I manually executed the query

Re: [GENERAL] how to install plpython?

Okay. Thanks for the guidance. Could you please tell where I can get the postgresql-python lib files? On Tue, Jun 14, 2011 at 2:01 PM, Craig Ringer wrote: > On 14/06/11 15:33, AI Rumman wrote: > > Hi guys, > > > > I need to install plpython language in my db. > > How

[GENERAL] streaming replication trigger file

Hi all, I am a bit confused regarding streaming replication. I have two server: A and B. I set up replication successfully. But when the master A goes down, B are not acting as master. My recovery.conf as follows: standby_mode = 'on' primary_conninfo = 'host=10.0.0.91 port=5432 user=postgres' t

[GENERAL] pg_rman in Windows - is it possible?

Could anyone please tell me whether I can use pg_rman in my Windows environment? Or is there any similar type of application for windoes Postgresql?

Re: [GENERAL] pg_rman in Windows - is it possible?

not revise it for some reasons. > (If you can make patch for revising them, welcome.) > > > (2011/07/01 18:18), AI Rumman wrote: > >> Could anyone please tell me whether I can use pg_rman in my Windows >> environment? Or is there any similar type of applicat

[GENERAL] \i command in dblink

I have a file as follows: \set counter 10 \set name_test 'abc' This file is used to set some psql client variables. My problem is that, how I can call this file from dblink connection. That is, I need to use \i in dblink connection. Any idea please. -- Sent via pgsql-general mailing list (pgs

[GENERAL] include directives in postgresql.conf

Can anyone please tell me that how to use 'include directives' in Postgresql.conf? http://www.postgresql.org/docs/8.4/interactive/config-setting.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsq

[GENERAL] "FATAL: role "postgres" does not exist" after recover

I am using database Postgresql 9.0.1. For some reasons, my database was crashed. At first I found: DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 0, but the server was compiled with PG_CONTROL_VERSION 903. I solved it by copying pg_control from a new cluster Then I got, FA

[GENERAL] Postgresql 9.0.1 Corrupted

*Database Version:* Postgresql 9.0.1 *OS:* Linux rumman.dhaka 2.6.18-92.el5xen #1 SMP Tue Jun 10 19:55:54 EDT 2008 i686 i686 i386 GNU/Linux *Installed from:* Source configure *Problem:* When I try to connect to postgres, I got - psql: FATAL: role "postgres" does not exist In fact, it seems to me t

[GENERAL] Convert mysql to postgresql

I have to convert some mysql queries to postgresql. Is there any good tools for this task?

[GENERAL] max_stack_depth error, need suggestion

I am using Postgresql 9.0.1 in Centos 5. Yesterday, I got the error inlog: 2011-08-16 10:57:34 EDT [3868]: [1-1] user=vcrm,db=vtigercrm504 ERROR: stack depth limit exceeded 2011-08-16 10:57:34 EDT [3868]: [2-1] user=vcrm,db=vtigercrm504 HINT: Increase the configuration parameter "max_stack_depth"

[GENERAL] How to apply Postgresql Patch

Hi, I want to learn how to apply patch in Postgresql? Recently, I got the docs http://archives.postgresql.org/pgsql-hackers/2011-08/msg00581.php. I want to apply the patch. Any guideline please?

[GENERAL] how to use all the options of EXPLAIN?

Could anyone please tell me how to use all the options of explain in Postgresql 9. http://www.postgresql.org/docs/9.0/static/sql-explain.html I can use EXPLAIN ANALYZE. FORMAT: explain (format yaml) select * from tab1; QUERY PLAN --- - Pl

Re: [GENERAL] how to use all the options of EXPLAIN?

wrote: > On 15/09/11 15:43, AI Rumman wrote: > >> Could anyone please tell me how to use all the options of explain in >> Postgresql 9. >> http://www.postgresql.org/**docs/9.0/static/sql-explain.**html<http://www.postgresql.org/docs/9.0/static/sql-explain.html> >>

[GENERAL] Is there any way to import a portion of a large database

I have a production Postgresql 9 database of 2 TB+. For development purpose, I have to import this database in development server where I have only 1 TB of disk space. No more space can be added at present. Is there any way so that I might import the whole schema definition of the database with a p

[GENERAL] Permission for pg_shadow.

I have an application which query on the pg_shadow view. But the user that I was provided by my hosting server does have permission to do that. I checked that only superuser can query in pg_shadow view. But hosting service provider will not give me superuser permission. Is there any other alternati

[GENERAL] Is it possible to send data in client end?

I am using Postgresql 9.1. I know that COPY is used to export data as csv. But COPY creates file in server end. I need to create a file in client end. My application uses php. Is there any tool for it?

[GENERAL] is there any query so that I may find the list of columns those have rules?

I am getting the following error: ALTER TABLE base_table ALTER COLUMN base_table_field1 TYPE numeric(10,6); ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view master_view depends on column "base_table_field1" I know that I have a view based in the "base_tabl

[GENERAL] Where should I start for learn development

Hello, I have been working with Postgresql for the last 3 years. Before that I worked with Oracle, Mysql and other databases. Now, its time to learn the internals of Postgresql system. I downloaded the source code and imported it in my eclipse environment. But I have very limited knowledge on C pr

[GENERAL] I cannot insert bengali character in UTF8

I am using database with UTF8 and LC_CTYPE set as default value in Postgresql 9.1. But I cannot insert bengali character in a column. Query Failed:INSERT into tracker (user_id, module_name, item_id, item_summary) values ('1','Leads','353','বাংলা টেস্��...')::ADODB error::->ERROR: invalid byte sequ

Re: [GENERAL] I cannot insert bengali character in UTF8

WOW. Great informative answer. Thanks. On Fri, Jul 20, 2012 at 7:11 PM, Christian Ullrich wrote: > * AI Rumman wrote: > > I am using database with UTF8 and LC_CTYPE set as default value in >> Postgresql 9.1. >> But I cannot insert bengali character in a column. >>

Re: [GENERAL] Where should I start for learn development

should start by writing simple C functions as extension and then for more. Thanks to all again. On Tue, Jul 3, 2012 at 7:32 PM, Craig Ringer wrote: > On 07/03/2012 07:50 PM, AI Rumman wrote: > > Hello, > > I have been working with Postgresql for the last 3 years. Before that I >

[GENERAL] should I increase default_statistics_target

Using explain analyze of a large query I found that in every step there are a lot difference between the number of rows between actual and estimated. I am using default_statistics_target 200. Should I increase it?

[GENERAL] deadlock detected

Hi all, I am using Postrgesql 9.1 I got a message in my log: ERROR: deadlock detected DETAIL: Process 20265 waits for ShareLock on transaction 27774015; blocked by process 20262. Process 20262 waits for ShareLock on transaction 27774018; blocked by process 20265. Process 20265:

[GENERAL] pg_restore error with out of memory

I am going to restore a 6 Gb database in my development machine which is running on Centos 5.6 with memory 1 GB. During restoration I got error as follows: LOG: checkpoints are occurring too frequently (22 seconds apart) HINT: Consider increasing the configuration parameter "checkpoint_segments

Re: [GENERAL] pg_restore error with out of memory

I modified the shared_buffer=50 MB and maintenance_work_mem = 50 MB But still getting the same error. On Thu, Dec 13, 2012 at 7:36 PM, Kevin Grittner wrote: > AI Rumman wrote: > > I am going to restore a 6 Gb database in my development machine > which is running on Centos 5.6 with

[GENERAL] pg_xlog is getting bigger

Hi, I am working on a Postgresql 9.0 server. I have no replication and archive mode setup. But I found that the pg_xlog is getting bigger and bigger. Right now it is 20 GB. How should I recover these spaces? Please let me know. Thanks.

Re: [GENERAL] pg_xlog is getting bigger

On Wed, Dec 19, 2012 at 7:52 PM, Adrian Klaver wrote: > On 12/19/2012 04:12 PM, Tom Lane wrote: > >> Adrian Klaver writes: >> >>> Well the question is how long have those idle transactions been around? >>> >> >> Idle transactions shouldn't have anything to do with pg_xlog bloat. >> What causes xl

[GENERAL] Is there any plugin for Nagios, which sends Postgresql ERROR information with SQL query in mail?

Is there any plugin for Nagios, which sends Postgresql ERROR information with SQL query in mail?

[GENERAL] int2vector

What is int2vector data type? Is it possible to use it as an array? Any one please.

[GENERAL] PGPOOL II 2.3.3 encryption

Is it possible to send encrypted text at all the nodes in replication mode for PGPOOL II 2.3.3? Any help please.

[GENERAL] Postgresql with open-ssl support

How can I be sure that Postgresql Server has been installed with open-ssl support? Any help please.

[GENERAL] postgresql ssl

I have my postgresql 8.3.8 database and application server in the same network over the WAN. I need to enable data encryption using SSL. Is there any step-by-step guide to complete this task?

[GENERAL] SSL error

I have created server.crt and server.key using the Postgresql documentation. Followings are the commands: --- openssl req -new -text -out server.req openssl rsa -in privkey.pem -out server.key rm privkey.pem openssl req -x509 -in server.req -text -key serv

Re: [GENERAL] SSL error

I change the pg_hba.conf as below: hostssl allall10.0.0.34/32 md5 But still the same problem. On Tue, May 4, 2010 at 5:03 PM, Thom Brown wrote: > On 4 May 2010 11:50, AI Rumman wrote: > >> I have created server.crt and server.key using the Postgresql >

[GENERAL] How can I be confirm that data is encrypted over the network using SSL

I have configured SSL connection between client/server using self-signed certificate. -- Password: Welcome to psql 8.3.8, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for hel

[GENERAL] how to get the deleted data

Unauthorized user deleted some critical data from the database. I don't have any log. Is it possible to get what was the command used to delete the data?

[GENERAL] lobj_lock_table structure

I am using Pgpool II 2.3.3 with Postgresql 8.3.8 in replication mode with SSL support. I am facing problem in lob object replication. I found that lobj_lock_table is required. What should be the structure of lobj_lock_table?

[GENERAL] Urgent please: PGPOOL II 2.3.3 hang in ssl mode

I am using Pgpool II 2.3.3 with Postgresql 8.3.8. When I use command \l at postgresql client the query is working perfectly. But if I used the command from pgpool II client which is connected with postgresql in ssl mode, it gets hang. Again if I use the command from pgpool II client in non-ssl m

Re: [GENERAL] question about unique indexes

Use unique index as follows: create unique index unq_idx on table_name (coalesce(country_id,0), coalesce(state_id,0), coalesce(city_id,0),coalesce(postal_code_id,0) ); On Mon, May 10, 2010 at 6:09 AM, Jonathan Vanasco wrote: > -- running pg 8.4 > > i have a table defining geographic locations

[GENERAL] table partition or index

For how many records I should go for a table partition instead of using just index? Any idea please.

[GENERAL] shared_buffer advice

I have a server with Dual-Core 4 cpu and 32 GB RAM. This is the database server. Only Postgresql 8.1 is running on it with multiple databases. How should I plan for shared_buffers and effective cache size? Any idea please.

Re: [GENERAL] Working with pages of data (LIMIT/OFFSET keyword)

I am using a PHP client. Is there a way to do the above task with php? On Thu, Jun 17, 2010 at 11:38 PM, Francisco Figueiredo Jr. < franci...@npgsql.org> wrote: > I would go with 2). > > Npgsql supports multiple resultsets. You can pass a query separated by > semicolon ';' or you can use a proce

Re: [GENERAL] How to Get Column Names from the Table

Use: \d tablename On Wed, Jul 7, 2010 at 3:08 PM, venkat wrote: > Dear All, > >How to get Column Names from Table in PostgreSQL. > > Thanks and Regards, > > Venkat >

[GENERAL] column depends on sequence

I need to write a query to find the primary key column_names that depend on sequences. Any help please.

[GENERAL] Implicit CAST is not working in Postgresql 8.4

I migrated data from Postgresql 8.1 to Postgresql 8.4 using pg_dump. But now I found that, most of the queries in my applicaiton are being failed. Invesitigating the problem, I found that no function is available in the DB to CAST INT to TEXT etc. Most of the queries are failed because implicit ca

[GENERAL] Query tune, index is not using

I am using two similar queries where one query is using index and other is not. I don't know why. explain analyze select ticketstatus from ticketstatus inner join role2picklist on role2picklist.picklistvalueid=ticketstatus.picklist_valueid where roleid!='H1' order by sortid QUERY PLAN --

Re: [GENERAL] transaction logging in the form of SQL statements

Use log_min_duration_statement=0 at postgresql.conf file to log every statement. On Tue, Jan 12, 2010 at 7:50 AM, Omar Mehmood wrote: > Is there any way to enable transaction logging in the format of SQL > statements for committed transactions only ? In other words, a way to log > all the SQL

[GENERAL] location for pg_default tablespace

I am new at Postgresql. Previously I used to work with Oracle. I am surprised to see that the location for pg_default tablespace in my database for a Postgresql cluster is null. Could anyone please tell me what is the location of default tablespace in postgresql and how could I find it?

Re: [GENERAL] location for pg_default tablespace

Thanks. But actually I want to know that why the value in spclocation is null is pg_tablespace for pg_default. Moreover, $PGDATA/pg_tblspc has no file. Could you please tell me why? On Tue, Jan 12, 2010 at 11:26 AM, John R Pierce wrote: > AI Rumman wrote: > >> I am new a

Re: [GENERAL] location for pg_default tablespace

11:50 AM, Greg Smith wrote: > AI Rumman wrote: > >> But actually I want to know that why the value in spclocation is null is >> pg_tablespace for pg_default. >> Moreover, $PGDATA/pg_tblspc has no file. >> Could you please tell me why? >> > > PostgreSQL

[GENERAL] large string storage in Postgresql

Hello all, I have to store 2 GB text in the database. Previously I was using Oracle database with CLOB data type. Could anyone please tell me how can I do it in Postgresql 8.0 or later?

Re: [GENERAL] large string storage in Postgresql

I have an individual text string of 2 GB. I may use Postgresql 8.4 also. But what data type should I use to store this column value of 2GB? On Sun, Jan 17, 2010 at 12:08 PM, Craig Ringer wrote: > On 17/01/2010 1:51 PM, AI Rumman wrote: > >> Hello all, >> I have to store 2 GB te

[GENERAL] pg_database_size

What does pg_database_size resturs? Bytes or KB? Please tell.

[GENERAL] query a table from one database to another

I am using Postgresql 8.3 I have two databases: db1 db2 db1 holds a table tab1. Is it possible to get the value of the above tab1 in db2 database? Regards

Re: [GENERAL] query a table from one database to another

type casts. Please tell me why? I am using Postgresql 8.3 On Wed, Jan 27, 2010 at 10:45 PM, Joshua Tolley wrote: > On Wed, Jan 27, 2010 at 02:52:58PM +0600, AI Rumman wrote: > >I am using Postgresql 8.3 > > > >I have two d

[GENERAL] stat collector is not using

I am using Postgresql 8.1. I set stats_start_collector = on But I found statistics collector is not using; show stats_start_collector; stats_start_collector --- on (1 row) select * from pg_stat_user_indexes where idx_scan > 0; relid | indexrelid | schemaname | relname | i

[GENERAL] table size is not changed

I deleted 7 rows from a table and then execute vacuum analyze . But table size not yet changed. I am using Postgresql 8.1. Could anyone please tell me what the problem is?

[GENERAL] overhead for stats_row_level

Could any one please tell me what the overhead will be on the database server and instance if I set stats_row_level = on at Postgesql 8.1.

[GENERAL] pg_stat_user_indexes and pg_stat_user_tables description?

Could anyone please tell me where may I get the details of the following views: pg_stat_user_indexes pg_stat_user_tables I want to know the meaning of every column like idx_tup_read and idx_tup_fetch.

[GENERAL] index is not using

I have created a index create index leadaddress_phone_idx on leadaddress(regexp_replace((phone)::text, '[^0-9]*'::text, ''::text, 'g'::text)); But the index is not using. explain select * from leadaddress where regexp_replace(phone,'[^0-9]*','','g') like '%2159438606';

[GENERAL] string reverse fucntion?

I am using Postgresql 8.1. I have to reverse a string like 'abc' to 'cba'. Is there any function to do this?

[GENERAL] more than 2GB data string save

How to save 2 GB or more text string in Postgresql? Which data type should I use? Please any suggestion.

Re: [GENERAL] more than 2GB data string save

wrote: > > > On Tue, Feb 9, 2010 at 9:38 PM, AI Rumman wrote: > >> How to save 2 GB or more text string in Postgresql? > >> Which data type should I use? > > > > If you have to you can use either the lo interface, or you can use > > bytea. Large Object (i.e

[GENERAL] when a table was last vacuumed

If it possible to find out when a table was last vacuumed?

Re: [GENERAL] when a table was last vacuumed

But I am using Postgresql 8.1 and here no clumn named last_vacuum. On Wed, Feb 10, 2010 at 4:12 PM, Guillaume Lelarge wrote: > Le 10/02/2010 10:48, AI Rumman a écrit : > > If it possible to find out when a table was last vacuumed? > > > > SELECT schemaname, relname, last_va

[GENERAL] Why am I getting this error in DB

Why am I getting this error in DB? - number of page slots needed (858976) exceeds max_fsm_pages (356656)

Re: [GENERAL] Why am I getting this error in DB

How should I calculate the value of max_fsm_pages? Thanks On Wed, Feb 17, 2010 at 11:25 AM, Ben Chobot wrote: > On Feb 16, 2010, at 9:17 PM, AI Rumman wrote: > > > Why am I getting this error in DB? > > > > - number of page slots needed (858976) exceeds max_fsm_pages (3

[GENERAL] about effective_cache_size

* What is the difference between shared_buffers and effective_cache_size? * If I set effective cache size 1GB for db1 and 500 MB for db2, then what will happen to the system memory usage? Anyone please tell me.

[GENERAL] change path of /tmp/.s.PGSQL.5432

Is it possible to change the path of the file: /tmp/.s.PGSQL.5432 I am using postgresql 8.1 and / has no space.

[GENERAL] text search in 8.1

Does Postgresql 8.1 support Full Text Search? If yes, please provide the link about documentation.

Re: [GENERAL] text search in 8.1

postgresql-libs-8.1.11-1.el5_1.1 postgresql-contrib-8.1.11-1.el5_1.1 Please tell me how can I install textsearch here. On Mon, Feb 22, 2010 at 3:20 PM, David Fetter wrote: > On Mon, Feb 22, 2010 at 02:47:00PM +0600, AI Rumman wrote: > > Does Postgresql 8.1 support Full Text Search? &

[GENERAL] tsearch2 gives NOTICE: word is too long

When I am using the query: select length(description), to_tsvector('default',description) as c from crmentity ; Getting error: NOTICE: word is too long Postgresql 8.1. Could anyone please tell me why?

[GENERAL] current transaction id

How to find the current transaction id of the database?

[GENERAL] need a query

I have data as followos: Table: contact column: phone as varchar +1 (800) 863-3950 ext. 517 +1.510.291.6100 ext2347 +1.714.545.8886 ext 144 714.545.8887 ext 144 714.545.8898 +1.510.291.6101 I need to extract only the phone numbers using a SQL query like: +1 (800) 863-3950 ext. 517 --- 80

[GENERAL] compare two schemas

I have to compare two schamas in two different Postgresql databases to identify the mismatch between the production and development environment databases. Is there any good tool? Any suggestion please.

[GENERAL] Postgresql 8.1

Please tell me the link to download Postgresql 8.1

<    1   2   3   >