[ADMIN] Another way to Replicate

Hi people, I would like to know if is possible to replicate in postgres applying binary logs (wal logs) like the same way is done on Oracle!! Did anybody tried to do that? Applying the simple ideia: - for each archived Wal logs, transfer to slave server; - after transfer, apply recover on postgre

[ADMIN] Install XML on Postgres 8.1

Hi, I need to install XML on Postgres 8.1. What's the simples steps that I can follow? I found on the internet, but there are many versions, packages and ways to install. What's the right way to install? Can we compare the same powerful like Oracle has on Xml? If you could help me!! Thanks in adv

[ADMIN] Case-sensitive

Hi, One developer asked me about case-sensitive, if its possible disable Postgres not consider when using comparative functions. Eg.: select * from people where upper(name) like upper('A%'); Is there any parameter that don't take in account case-sensitive, or any other way to treat?? Thanks

[ADMIN] System Area

Hi, I would like to know if Postgres has shared memory like Library Cache (avoid to do parse the same sql), Dictionary Cache (metadata information), Sort Area and so on? Oracle has this structures. And Postgres? I couldn't find anything about memory on Postgres. Thanks.

[ADMIN] Install Tsearch2

Hi, I need to install tsearch2, but I couldn't find a procedure (step-by-step). Could you recomend some site or some steps to install. I used PG 8 on Suse and Debian, and I installed postgres by source. Thanks in advance. _

Re: [ADMIN] Install Tsearch2

#x27;, '{simple}'); >> INSERT INTO pg_ts_cfgmap >> VALUES ('default_english', 'nlpart_hword', '{simple}'); >> INSERT INTO pg_ts_cfgmap >> VALUES ('default_english', 'part_hword', '{simple}'); >> INSERT INTO pg_ts_cf

Re: [ADMIN] ADMIN Install Tsearch2 - new dic

;{simple}'); >> INSERT INTO pg_ts_cfgmap >> VALUES ('default_english', 'nlword', '{simple}'); >> INSERT INTO pg_ts_cfgmap >> VALUES ('default_english', 'nlpart_hword', '{simple}'); >> INSERT INTO pg_ts_cfgm

[ADMIN] tsearch feature

Hi, Sorry for my question, but what's the feature on Oracle like tsearch? Can we consider a good difference PG under Oracle? Of course, PG we can developer our own application in any language. But, talking about text search, does Oracle has a similar feature? Thanks ___

[ADMIN] Hierarchical structure

Hi, I need to create a view using hierarchical structure. Let me explain how is designed the table and what's the expected result. TABLE: coo_nro integer coo_nro_father integer level integer DATA: 100 – null – 1 106 – null – 1 134 – 100 – 2 725 – 100 – 2 635 – 106 – 2 423 – 134 – 3 814 – 725 – 3

[ADMIN] Trigger using Tsearch

Hi for all, I just installed Tsearch and was trying to configure automatic update on such table using trigger and procedure. But I get error on inserting data on the table. Could you help me to find out what I am wronging? Procedure created: create or replace function fn_atualiza_tsearch_cid

[ADMIN] Strange behavior

Hi, some developers were using the database, and suddenly no one could connect. Just only some connections that was established before. As soon as I was advised, I noticed that no postgres process were present, just only connections and they could run queries normally. Like this: desenv:~# ps -ef

[ADMIN] Autostartup

Hi, How can I configure to auto-startup Postgres installed on Open Suse 10.1?? On other systems, just configure file start.conf to "auto". But on Suse ... Could you help me? Thank you ___ Yahoo! Mail - Sempre a melhor opção pa

[ADMIN] sequences

Hi, I tried to find, but I didn't, I would like to know what's the view to list all sequences! Thank you ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] Process

Hi, I have a Postgres server that has more than 500MB ( shared_buffers = 64000) and looking at TOP command, I couldn't understand why appears some process with 536m and other with 23m. What's the difference between? Wouldn't be all process with 536m, including client connections, but not allocati

[ADMIN] waiting status

Hi, I constantly get 'waiting' status when I execute some ddl statement and some client connections is in idle transaction. For example, try to remove not null constraint and has client connection in "idle in transaction" status. This situation always get TABLE waiting. Another situation, is to dr

[ADMIN] Return data from function

Hello, I need to create a function that find data over 3 tables, merge and return data. With example can be specified more clearly: 1.1 Find all addresses code; 1.2 For each addresses code, get address, complement and city on the first table; 1.3 For each addresses code, get address, complement a

[ADMIN] Get information from SMNP

Hi, Who knows any information if it's possible to get some information about Postgres via smnp protocol and how can I do this? Thank you. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[ADMIN] Tool to analyze statement sql

Hi people, I am suffering to work with tool that doesn't organize sql. On Pl/sql developer has a button called "sql beautiful" that organize on sql form (but windows). Do you have any suggestion for tools that do this running on linux (specially Suse)? Thanks for any help. Alexander --

Re: [ADMIN] Autostartup

Another option is to add commands on /etc/init.d/boot.local eg:vi /etc/init.d/boot.local add: /etc/init.d/postgresql start Regards. Michael Monnerie escreveu: > On Mittwoch, 28. März 2007 16:24 Alexander B. wrote: > >> How can I configure to auto-startup Postgres insta

[ADMIN] Return record on recursive call

Hi, I am creating a function that when finished the last level, should return for each row. I put raise notice to trace and the result is correct, but when I try to execute, an error is showed. "ERRO: wrong record type supplied in RETURN NEXT" I created other functions the same way and worked, b

[ADMIN] Searching in a string with index

Hi, When I search some words into a varchar column and this column has an index. Does Postgres use index?? The search is done this way: create table tb_gen_person ( pes_nro_doc numeric(14) not null, pes_name varchar(150) not null, constraint pk_person PRIMARY KEY(pes_nro_doc) ); create inde

[ADMIN] Configure pg_hba.conf

Hi people, I would like to configure pg_hba for any IP. I have several network mask, some times 192..., or 10, or 190 ..., ... ... How can I configure for any IP? Thanks Alexander ---(end of broadcast)--- TIP 9: In versions below 8.0, the