[GENERAL] Recovery with WAL

Where can I find information about recovery_target_time or recovery_target_xid. I have two servers db1 and db2, WAL files are copied from db1 to db2. Database will colapse at 17:10 and i wan't to recove base from 17:05, so where can I find info about recovery_time. Albert -- Sen

[GENERAL] user get notification when postgresql database updated

I am using javaScript app and PostgreSQL database. I have car_alert as a table contains id (FK of cars table) and userid (FK of users table) each car has a status ( status column in cars table ). car_alert is updating and having new records (car id and userid ) every time user choose car to be al

Re: [GENERAL] user get notification when postgresql database updated

Thanks for your response! it a browser based application. so would you advice me about the best way to poll the database for notifications ? I've been read about DB triggers but still can't tell if it will help me. -- View this message in context: http://postgresql.1045698.n5.nabble.com/user-

Re: [GENERAL] user get notification when postgresql database updated

another Q : my app should display notifications to each user depends on his selected cars. can i do that just using ajax and php ? -- View this message in context: http://postgresql.1045698.n5.nabble.com/user-get-notification-when-postgresql-database-updated-tp5600187p5606001.html Sent from the

[GENERAL] PostgreSQL Trigger and rows updated

am trying to update a table according to this trigger : CREATE TRIGGER alert AFTER UPDATE ON cars FOR EACH ROW EXECUTE PROCEDURE update_cars(); Trigger Function : CREATE FUNCTION update_cars() RETURNS 'TRIGGER' AS $BODY$ BEGIN IF (TG_OP = 'UPDATE') THEN

Re: [GENERAL] PostgreSQL Trigger and rows updated

Thanks you so much! it works great now -- View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-Trigger-and-rows-updated-tp5608591p5609895.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] Trigger.. AFTER and BEFORE with specific column changed

*I'm trying to follow this :* CREATE TRIGGER check_update *BEFORE* UPDATE ON accounts FOR EACH ROW WHEN (OLD.balance IS DISTINCT FROM NEW.balance) EXECUTE PROCEDURE check_account_update(); *but with AFTER instead of BEFORE. and I'm keep getting error on or near WHEN. does that be

Re: [GENERAL] Trigger.. AFTER and BEFORE with specific column changed

*i get:* Syntax error at or near 'WHEN' LINE 1: ... check_update AFTER UPDATE ON accounts FOR EACH ROW WHEN (OLD.balance IS DISTINCT FROM NEW.balance) -- View this message in context: http://postgresql.1045698.n5.nabble.com/Trigger-AFTER-and-BEFORE-with-specific-column-changed-tp5610712p561

[GENERAL] Restore data from old installation

have the data inside a database which was stored in that installation...is there a way through the directory /data? I tried something but i did not have success... Please help me Thanks Albert ---(end of broadcast)--- TIP 1: if posting/reading

[GENERAL] PostGreSql cannot start after windows update

Hi all! I have windows XP professional 2003. Yesterday evening I installed, while turning off my pc, some updates of the os and this morning the database server does not start!! May some have a trick to help me? I fund something on the web but too unspecific... Thanks!! -

Re: [GENERAL] PostGreSql cannot start after windows update

Dear Richard. I've now solved reading a French forum. I obtained an error 1069 service cannot start due to logon failure when I tried to start the server manually. Now: it's sufficient to go in the options of the user postgres (Local Users->postgres) and change the settings for the password to set

[GENERAL] Calling pg_dump from another application in safe mode

Hi, I'm wondering if there is a method to call pg_dump from an external application without changing the security level in pg_hba.conf from trust to md5. I'd like to pass my password not in clear but using a secure cryptographic method like md5. Any suggestion? Thanks! --

[GENERAL] Reserve a value in a serial type field

Hi all. I have this issue: I need to load a value for an integer field (with auto increment) which I implemented with a serial type and to avoid inserts with that value in this field. The task is for a distributed program I'm creating and I wonder if there is an efficient solution for it. I though

Re: [GENERAL] Reserve a value in a serial type field

Thanks Shane. I solved taking trace of the sequence value directly in the program...it is not a good solution but it works until I find a better one! ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archiv

[GENERAL] Paranthesis and Driver JDBC

Hi all! I use postgresql 8.0 and its driver for JDBC.A strange thing happens: when my application creates a query it is created always with a parenthesis more than expected, that is a query like this one: SELECT * FROM table_x WHERE (table_x.afield='a' and table_x.bfield='b')) order by table_x.a

[GENERAL] Transactions through JDBC

Hi all! Actually I have a client-server application with one server and many clients each one of which opens a different connection to the postgres database. In order to avoid those known problems with the execution of the different clients' operations at database, I implemented everything in this

[GENERAL] max. size for a table

Thank you very much. Best Regards Albert ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] Prefix search on all hstore values

ex that can be used to determine if a query string is a prefix of ANY of the values in the hstore? From reading the documentation the closest I've gotten is a gin index after converting the values to an array, but that doesn't seem to work with prefix searching. Any pointers would be much appreciated! Thanks, Albert

Re: [GENERAL] Prefix search on all hstore values

Thanks for the suggestions! My requirements can be relaxed to full text search, but the problem I had with that approach is I have strings in Chinese, and postgres doesn't seem to support it. Calling to_tsvector() on Chinese characters always returns an empty vector. A separate table will defini

[GENERAL] Please Post

I am working with PostgreSQL 9.1.3 - I setup a master and standby - Initiated replication and verified that it was occurring - Failed over from master to standby and verified that the database could be updated on the new master - I then configured the former standby as a master, the former master a

[GENERAL] Why PostgreSQL is better than other commerial softwares?

it's free, powerful and have others, thanks. -Albert. __ Get Your Private, Free Email at http://www.hotmail.com

[GENERAL] Date convertion problem.

Hi, I have a problem about date convertion. I insert a value which attribute is date, like this: insert into example values ('19 Mar 1999'); How do I show the date become 1999/3/19? Thanks in advance, Albert. __ Get Your Pri

[GENERAL] Does Apache has PostgreSQL module?

Hi, I know there is a ApacheMysql module. Has ApachePostgres module? -Albert __ Get Your Private, Free Email at http://www.hotmail.com

[GENERAL] SQL Regular expression

to do, thanks in advance. -Albert __ Get Your Private, Free Email at http://www.hotmail.com

[GENERAL] Cannot compile JDBC.

va:10: Package postgresql.util not found in import. import postgresql.util.*; ^ 4 errors make: *** [postgresql/Connection.class] Error 1 Would anyone help me how to solve the problem, thanks. -Albert __ Get Your Private, Free Email at

[GENERAL] Query buffer problem.

r max length of 2 exceeded query line ignored Segmentation fault (core dumped) Would anyone know how to solve this problem, thanks in advance. -Albert __ Get Your Private, Free Email at http://www.hotmail.com

Re: [GENERAL] jdbc question

ight also want to try : //String url = "jdbc:postgresql://gina/testdb"; String url = "jdbc:postgresql://127.0.0.1:5432/testdb"; //Connection con = DriverManager.getConnection(url, "", ""); Connection con = DriverManager

[GENERAL] query plan in pg7.4 vs 8.0.3

the cause. If 'citext' is the culprit, how can I migrate a very large database which uses this datatype extensively. Any help is greatly appreciated. Thanks, -albert === In Pg 8.0.3-- EXPLAIN select * from snp_quality_overview limit 10;

Re: [GENERAL] query plan in pg7.4 vs 8.0.3

I just re-checked, and all the same index definitions are on both tables. Cheers, -albert On 17.6.2005, at 14:20, Tom Lane wrote: Albert Vernon Smith <[EMAIL PROTECTED]> writes: I am in process of migrating a database from Pg 7.4.3 to Pg 8.0.3. I dumped and reloaded the data, and

[GENERAL] optimizer not optimizing

uot;outer".snp_id) Filter: ((assembly)::text = 'reference'::text) (10 rows) What could be the reason for this behavior??? (I posted something similar a little while back, but I've still not solved this issue.) Thanks, -albert ---(

Re: [GENERAL] optimizer not optimizing

Yes, I did an analyze, and see this behavior. -albert On 30.6.2005, at 20:39, Joshua D. Drake wrote: Albert Vernon Smith wrote: I am in process of migrating from Pg 7.4.5 to 8.0.3. I have the same data loaded in to the two. However, when I do a query on my 8.0.3 installation, I am

[GENERAL] insert serial numbers

(SELECT one.one_id FROM one WHERE (new.text = one.text)) WHERE (new.two_id = two.two_id); The following does work, but it updates all rows with the same text. I'd rather be more efficient, and only work with the current row.: CREATE RULE two_insert AS ON INSERT TO two DO UPDATE tw

Re: [GENERAL] insert serial numbers

xt = two.mytext); On 3.1.2006, at 16:07, codeWarrior wrote: Don't use reserved words for column names. "Albert Vernon Smith" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I have two tables, listed as below. I'm inserting values for "text"

Re: [GENERAL] insert serial numbers

BEFORE INSERT OR UPDATE ON two FOR EACH ROW EXECUTE PROCEDURE return_one_id() Voila! -albert On 3.1.2006, at 14:36, Albert Vernon Smith wrote: I have two tables, listed as below. I'm inserting values for "text" into table "two" (which must already exist as "te