Re: [GENERAL] empty pg_stat_replication when replication works fine?

inary database copy, or some older WAL logs left over either in archive or pg_xlog, or some corrupted index in pg_catalog?) during several test-cycles.. Any other idea how can oid of users could be different from the one appearing in pg_stat_get_activity()? (see details below) Andrej --de

Re: [GENERAL] empty pg_stat_replication when replication works fine?

as described, do not reflect ps -ef list of postgres processes and running SQL client/replication information) What may be additionally useful information before restarting the master? Regards, Andrej 2016-05-25 23:22 GMT+02:00 Andrej Vanek : > Streaming replication set-up, > > one mast

[GENERAL] empty pg_stat_replication when replication works fine?

s wal-receiver process running - replication works (tried to create a table- it appears in all databases) Question: - why is pg_stat_replication empty? Andrej ---details [root@l2bmain ~]# tail /opt/pg_data/postgresql.conf max_wal_senders = 5 hot_standby = on wal_keep_segments

Re: [GENERAL] pg_basebackup: return value 1: reason?

kup -U pgreplic -h db-other-site -w -D /opt/geo_stdby_data -c fast -vvv -X stream &>> /tmp/log Result: variant 2. works fine with return code 0 (with strace) variant 1. fails with error code 1 (without strace) Any ideas? Andrej --details Output: Variant 2: DEBUG:

Re: [GENERAL] pg_basebackup: return value 1: reason?

which fails to do some its work (pg_basebackup: could not wait for child process: No child processes)- probably due to some failing system call. How can I report to clusterlabs: What system call fails in pg_basebackup? Best Regards, Andrej 2016-04-17 1:09 GMT+02:00 Adrian Klaver : >

Re: [GENERAL] pg_basebackup: return value 1: reason?

it works. It fails just when launched from a script fired by crm_mon -d -E my-script Regards, Andrej 2016-04-16 1:18 GMT+02:00 Jerry Sievers : > Andrej Vanek writes: > > > Hello, > > > > I tried to run pg_basebackup. Return value is 1. > > > > How to find o

Re: [GENERAL] pg_basebackup: return value 1: reason?

Best Regards, Andrej 2016-04-16 1:17 GMT+02:00 Adrian Klaver : > On 04/15/2016 03:28 PM, Andrej Vanek wrote: > >> Hello, >> >> I tried to run pg_basebackup. Return value is 1. >> >> How to find out its reason? >> (I suspect that some wal after backup is missi

[GENERAL] pg_basebackup: return value 1: reason?

Hello, I tried to run pg_basebackup. Return value is 1. How to find out its reason? (I suspect that some wal after backup is missing- but how to find out the real reason? How to fix it?) thanks, Andrej --details: environment: CentOS 6.7, postgres 9.5.1 ( PostgreSQL 9.5.1 on x86_64

Re: [GENERAL] deadlock of lock-waits (on transaction and on tuple) using same update statement

Hi, retested: yes, this is still an issue in 9.3.5, same deadlock errors occured. Do you need to extract some simplified reproducible testcase? Best Regards, Andrej

Re: [GENERAL] deadlock of lock-waits (on transaction and on tuple) using same update statement

Hi, now I've checked release-notes of 9.3.5 (my version 9.3.4)- found a fix which probably could lead to my deadlocks: > Fix race condition when updating a tuple concurrently locked by another process (Andres Freund,Álvaro Herrera) How can I make sure I've run into this bug?

Re: [GENERAL] deadlock of lock-waits (on transaction and on tuple) using same update statement

etween Any idea? thanks, Andrej

[GENERAL] deadlock of lock-waits (on transaction and on tuple) using same update statement

set LOCK_COLUMN = 1 where (SBO_GRP = '15') Is this an expected behaviour, or maybe a bug? Thanks, Andrej ---details case is reproducible via my application. I was unable to reproduce it via psql sessions (locking worked fine). I was unable to reproduce it vi

Re: [GENERAL] hidden junk files in ...data/base/oid/

ta loss. Do you know whether there is such cluster agent already available? Best Regards, Andrej 2014-05-27 16:09 GMT+02:00 Alvaro Herrera : > Andrej Vanek wrote: > > Hello, > > > > solved. > > This is not a postgres issue. > > > > The system was used in

Re: [GENERAL] hidden junk files in ...data/base/oid/

database synchronization (full on-line backup of master database to slave node) before starting postgres in hot-standby mode on slave the node... Best Regards, Andrej

[GENERAL] hidden junk files in ...data/base/oid/

the whole database size. Question: Where does the 70GB hidden files in ...data/base/oid/ come from? Which postgres process could generate them? Some missed maintenance from my side? A bug? Anybody else experienced such issue? Thanks, Andrej -details: ...data/base/oid file listing shortened:

Re: [GENERAL] Using Postgresql as application server

-I /usr/include/postgresql/ -I /usr/include/httpd -lpq -o mod_libpq.so -n MOD_LIBPQ mod_libpq2.c using postgresql 9.0.4 & apache 2.2.19 Cheers, Andrej -- 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] Book

Thanks all - book ordered :} -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Book

Can anyone recommend "PostgreSQL 9.0 High Performance" by G. Smith? Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise. http://www.georgedillon.com/web/html_email_is_evil.shtml -- Sent via pgsql-general mailing

Re: [GENERAL] Regular disk activity of an idle DBMS

This message has been digitally signed by the sender. Re___GENERAL__Regular_disk_activity_of_an_idle_DBMS.eml Description: Binary data Hi-Tech Gears Ltd, Gurgaon, India Sent using "PostMaster" by QuantumLink Communications Get your

Re: [GENERAL] Regular disk activity of an idle DBMS

Nothing changes there. When OpenFire, Courier-MTA and Apache are restarted, a few numbers change, but othrewise they remain unchanged pretty long. There is no obvious activity that could trigger a disk write 20 times a minute... How many databases are in your pg cluster? There are currently 19

Re: [GENERAL] Regular disk activity of an idle DBMS

urned, tup_fetched from pg_stat_database ; Nothing changes there. When OpenFire, Courier-MTA and Apache are restarted, a few numbers change, but othrewise they remain unchanged pretty long. There is no obvious activity that could trigger a disk write 20 times a minute... Andrej smime.p7s Descripti

[GENERAL] Regular disk activity of an idle DBMS

Stopping all daemons that connect to PostgreSQL (OpenFire, Apache, Courier-MTA) does not change anything. Any hints would be very helpful. There is actually no performance or usability issue. I just want to *understand* what is going on. Andrej smime.p7s Description: S/MIME Cryptographic Signature

Re: [GENERAL] Preventing OOM kills

>  done >  sleep 60 > done > > Is there a Better Way?  Thanks in advance. Add more RAM? Look at tunables for other processes on the machine? At the end of the day making the kernel shoot anything out of despair shouldn't be the done thing. Cheers, Andrej -- Sent

Re: [GENERAL] Using column aliasses in the same query

ECT x/y AS z FROM tab WHERE y <> 0 AND x/y > 2 > > No big deal, since there are lots of other ways to do this. That's an accurate observation, but has nothing to do w/ what the original poster was looking for, nor does it refute Toms argument against the OPs suggestion. Chee

Re: [GENERAL] Is Postgres 9 supported on Ubuntu Desktop10LTS?

ht answer. Is Pgsql9 supported on > Ubuntu10LTS? Having googled this (I don't use Ubuntu, and compile postgres from source) I found this after about 1 minute ... https://launchpad.net/~pitti/+archive/postgresql Cheers, Andrej -- Sent via pgsql-general mailing list (pgsql-general@postgr

Re: [GENERAL] postgresql install problem

ing? What OS? Which postgres version? Cheers, Andrej -- 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] regexp match in plpgsql

On 23 February 2011 11:55, Gauthier, Dave wrote: > I would expect to see... > > "ShouldBeOK99 is a match" > > "Should_Fail_match77 is not a match" Why would you expect that? Both strings match at least one character from the character class? Cheers, Andrej

Re: [GENERAL] iPad and Postgresql...

ut have you considered http://phppgadmin.sourceforge.net/ ? > Thanks, > > Jerry Cheers, Andrej -- 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] CSV-bulk import and defaults

gh, low CPU overhead. > Thanks in advance, > Thomas Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise. http://www.georgedillon.com/web/html_email_is_evil.shtml -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] Please Help...

Now if you told people the OS, and the version of Postgres maybe ... ? -- 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] Cannot Start Postgres After System Boot

nnot start a > new postgresql process. I just stumbled upon your post from two years ago; has your setup changed since then? Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise. http://www.georgedillon.com/web/html_email_is_evil.shtml --

Re: [GENERAL] Cannot Start Postgres After System Boot

or something else is > using port 5432. I concur on both accounts; I would like to see the output of the actual script, though, when it refuses to start; and also a netstat -anp | grep 5432 Cheers, Andrej -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Cannot Start Postgres After System Boot

next > time. I can also provide the 'start' section of the Slackware init file so I > could learn why it's not working properly. Please do - provide the section, I mean. > TIA, > > Rich Cheers, Andrej -- Please don't top post, and don't use HTML e-Mai

Re: [GENERAL] error migrating database from 8.4 to 8.3

rises the "major". So 8.4 to 8.3 isn't going to fly. Export/import is the only option. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing

Re: [GENERAL]

psqlodbc.msi, > it shows May I ask why you're trying to install an ancient version? The latest in the 8.3.x branch is 8.3.9 > I would be grateful if you would let me know about it. > > Many thanks, > > Vijayalakshmi Vijaya sankar Cheers, Andrej -- Please don't top

Re: [GENERAL] array element replace ?

h kind of is what you're asking in your example), but: http://www.postgresql.org/docs/8.4/static/arrays.html Specifically section 8.14.4. Modifying Arrays Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.e

Re: [GENERAL] data dump help

illy like a "select *" on the table and then gets a hissy fit because the data doesn't match the expectations any longer? Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.

Re: [GENERAL] log_temp_files confusion

2010/1/14 Filip Rembiałkowski : > I would like to log usage of temporary files for sort/join operations, but > only when size of these files exceeds some threshold. > > So I set in postgresql.conf (this is 8.4.2) > log_temp_files = 4MB Just a wild guess... the DOCU says it's an integer, not an INT

Re: [GENERAL] ora2pg and DBD::Pg

termediate files". > Thank you for your help, > Regards, > Alexandra Cheers, Andrej -- 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] sudoku in an sql statement

oersr(> + ( ( lp - 1 ) / 3 ) * 6 > broersr(> , 1 ) > broersr(> ) > broersr(> ) > broersr-> select s > broersr-> from x > broersr-> where ind = 0; > s > --- > (0

Re: [GENERAL] sudoku in an sql statement

2009/11/5 marcin mank : > btw2: is SQL with 'with recursive' turing-complete ? Anyone care to > try a Brainf*ck interpreter ? :) Sick, sick puppy! :} Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://w

Re: [GENERAL] another can't connect

at port I think Chris meant "What about iptables rules for established connection?" ... Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing

Re: [GENERAL] prepared statements and DBD::Pg

statements, or it can just send the entire query to the server each time. The best way is automatically chosen for each query. This will be sufficient for most users: keep reading for a more detailed explanation and some optional flags. Queries that do not begin with the word "SELECT", "INSERT

Re: [GENERAL] Postgresql installation with ssh connection.

. ran into this ;} http://yum.pgsqlrpms.org/ Cheers, Andrej -- 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] [GENEAL] dynamically changing table

t SCREAMS "design flaw!!" ... as pointed out above, an approach with the "new columns" being rows in a separate table sounds quite sane. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/h

Re: [GENERAL] pgsql announce now on twitter

2009/3/5 Joshua D. Drake : > Not sure what the complainer is talking about here. pgsql-announce is > moderated so spam should be almost nil. Isn't she the one who keeps complaining about the reply-to-all on the list and isn't subscribed because of the volume? ;} -- Sent via pgsql-general mailing

Re: [GENERAL] Slow database creation

indows-expert by any stretch of the imagination, but could there be some anti-virus products involved at the customer site? > Rob Richardson > Product Engineer Software Cheers, Andrej -- 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] Question about COPY command

e all the formatting right, you may need something like sed or awk to make them match ... Of course it also depends on the complexity of "database"; if you have several tables w/ referential integrity then copy obviously wouldn't be the right tool for the job. > Thanks > Jos

[GENERAL] Automatic CRL reload

I can't validate the certificate with an expired CRL." Presumably, pg_ctl restart fixed this problem. It would be great if PostgreSQL could reload the CRL when necessary, just like Apache httpd does. Could this be appended to the 8.4 wishlist, please? Best regards, Andrej Podzime

Re: [GENERAL] In memory Database for postgres

could have the data files reside in a RAM disk. Which OS are you planning to do this on? > Thanks, > Avin. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general

Re: [GENERAL] [OT] newsreader issue? (Was: bytea encode performance issues)

On 04/08/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote: > One last thing. I'd rather my emails just get dropped silently if > that's the minimum someone can do. Use a valid email address that > goes to /dev/null and I'll be happy. You may miss a few things sent > directly to you, but since th

Re: [GENERAL] [OT] newsreader issue? (Was: bytea encode performance issues)

On 04/08/2008, Lew <[EMAIL PROTECTED]> wrote: > Was the message to which you responded posted to the newsgroup? It isn't > appearing in my newsreader. > > Who wrote the message you quoted (you failed to cite the source)? He was quoting Alban Hertroys, and it appeared on the general mailing list

Re: [GENERAL] Problems Restarting PostgreSQL Daemon

installed, and if so, which one comes first in the PATH? > Rich Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Problems Restarting PostgreSQL Daemon

On 27/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote: > Well, that's the problem, Andrej. I have that script, and it worked fine > with postgres-6.x through -8.1, but failed to correctly start the > postmaster after the system reboot. I thought we had established that t

Re: [GENERAL] Problems Restarting PostgreSQL Daemon

regards, tom lane Cheerw, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- 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] Problems Restarting PostgreSQL Daemon

On 27/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote: > Andrej, Hi Rich, > I found the thread in the archives for June of this year. > > Re-reading the posted results of running initdb I tried a different > approach to starting the server. Instead of using pg_ctl

Re: [GENERAL] Problems Restarting PostgreSQL Daemon

On 23/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote: > Andrej, Hi Rich, > Unless others consider this topic to be not appropriate for the list, I > don't mind a public conversation. I thought that I attached the script to > my original message; regardless, here'

Re: [GENERAL] Problems Restarting PostgreSQL Daemon

tgres packages I'd like to ask where that script came from :) and how you installed postges in the first place. Happy to communicate of the list if you prefer that. > TIA, > > Rich Cheers, Andrej -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] plperl installation

h distro? And how did you install, from source? > Thanks > -JD Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) T

Re: [GENERAL] Need some help

On 01/07/2008, Jamie Deppeler <[EMAIL PROTECTED]> wrote: > trying to install Postgresql 8.3 and i keep getting these errors > > libodbc.so is needed > libodbcinst.so is needed > > Hopefully someone can help me I'll hazard a guess and assume you're using some sort of Linux :} ...which distro are

Re: [GENERAL] Bottom Posting

to get a good understanding of what a thread is about without having to read the lot top to bottom. May not match your individual preference, but then that's not what the list is about, either. > Bob Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} M

Re: [GENERAL] Open Source CRM - Options?

On 28/05/2008, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > How does Zope/Plone fit in there as an alternative in your opinion? :) > Do you really want the answer to that? :P Of course! I know a few people who swear by it (and I've never had to use it ...) -- Please don't top post, and do

Re: [GENERAL] Open Source CRM - Options?

/Plone fit in there as an alternative in your opinion? :) > Kevin Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Stored procedures in C

selkovjr/postgres/tutorial/html/exttut-getstart.html > Thanks in advance... > Regards, > > Emiliano Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

able commands. For any value of shell IN {bash, tcsh, zsh}. sh (default on solaris) and ksh won't, and neither will cmd.exe But I (as a user of bash) see your point. > Cheers, > > Steve Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your

Re: [GENERAL] Schema design question

attributes won't be all that varried (int, float, text, > boolean, date, etc.). And a somewhat unorthodox suggestion for the list ... would it be worthwhile considering a different storage mechanism all together, like maybe an LDAP directory type of thing? The query language is admittedl

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

a good number of years now (since v7, I think) and have become quite accustomed to the names of the tools in use, have never observed any clashes with other tools, and as a Linux/Unix sys-admin type of person never had a problem with mistaking createuser for useradd or adduser. And I'll sti

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

--- > a) vacuumdb - shell command > b) VACUUM - SQL command > c) autovacuum > d) What is vacuum? c, b, a ... in this order. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm --

Re: [GENERAL] table size and storage location

On 25/03/2008, chuckee <[EMAIL PROTECTED]> wrote: > Thanks but I still get the error 'ERROR: relation "capture" does not exist' > when trying these two alternative functions you mention above. There is > definitely a table called 'capture' in my database! Are you sure you're connected to the ri

Re: [GENERAL] How to "use" database?

he script. Does it just create tables, or does it supposedly create a database as well? > Cheers, > Anton Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-gener

Re: [GENERAL] Need help to migrate pqSQL db 8.0.3 to 8.2.6

On 26/03/2008, Tri Quach <[EMAIL PROTECTED]> wrote: > Hi Andrej, Hi Tri! > I am running on Linux, Red Hat 3. > I have hard time to use pg_dump command. Can you give me the syntax of > pgdump? Not a syntax-problem; to use pg_dumpall you need to be the postgres (superuse

Re: [GENERAL] Need help to migrate pqSQL db 8.0.3 to 8.2.6

version on a different port than 5432 and have it use a different base directory) have both versions running at the same time. What OS & version are you running PG on? And if you can, use 8.2.7 > Thank you for your help. > > Tri Cheers, Andrej -- Please don't top post, and d

Re: [GENERAL] [postgis-users] how many min. floating-points?

how many min. floating-points? Cc: "PostGIS Users Discussion" <[EMAIL PROTECTED]> 8<8<8<8<SNIP8<8<8<8< Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :}

Re: [GENERAL] [postgis-users] how many min. floating-points?

On 21/03/2008, Colin Wetherbee <[EMAIL PROTECTED]> wrote: > Dunno about that. On the PostGIS list, he said: > > "i got an old box supporting only 1 floating-point" > > Maybe he means an FPU? *boggle* Maybe floating-point registers on the FPU? So many options

Re: [GENERAL] postgre vs MySQL

) uses postgres, the only official attribution (I've seen the binaries in the file-system) is that their product uses port 5432 in the manual. Cheers, Andrej P.S.: This is all really starting to belong to advocacy :} -- Please don't top post, and don't use HTML e-Ma

Re: [GENERAL] postgre vs MySQL

hat then? Could it be marketing or the sad results of a avalanche effect? Geee, there's a thought. > cheers, > Rahul. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sen

Re: [GENERAL] Dump format for long term archiving.

ons to the original source. My gut-feeling is that trying to keep data as a "moving target", with some redundancy in terms of storage and hardware, and updating the appropriate means every few years (financial life-cycle?) is a sensible method :} Cheers, Andrej -- Please don'

Re: [GENERAL] Trigger to run @ connection time?

#x27;s main package. This needs to be done for each connection" is meant to work. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] split pg_dumpall backups per database

t.sql); do dump.sh ${i} out.sql ${i}.sql; done Of course you won't be getting the creation of specific roles or anything that way. > Thanks, > Luca Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.america

Re: [GENERAL] PHPs PDO, apache and "never ending sessions"

deed set to true; I was playing with the "hatshop" database and application from the "Beginning PHP and PostgreSQL E-Commerce" Apress book. And found that config.php has "define('DB_PERSISTENCY', 'true');". Thanks for pointing me in the right direct

[GENERAL] PHPs PDO, apache and "never ending sessions"

it under normal circumstance, am I just supposed to increase the number of allowed connections and not worry about apache holding sessions open even after the "client" has long gone? Versions of products in question: apache2 2.2.8 (Unix) PHP 5.2.5 postgres 8.3 Cheers, Andrej -- Ple

Re: [GENERAL] Requiring a password

e.g.: psql -U username dbname To the best of my knowledge the authentication shouldn't be affected by the transport ... > Thank you! > > > Ralph Smith Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://w

Re: [GENERAL] Trouble running PostgreSQL server / Server must be started under certain locale.

y doesn't have 8.3 officially yet (I don't think). What other repositories did you tie in with your apt? > Cheers (from Christchurch) > > Olmec Cheers, Andrej ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner wi

Re: [GENERAL] Trouble running PostgreSQL server / Server must be started under certain locale.

ou do the installation/un-install of both versions? What data-directory is/was which version using? > I am learning slowly though. > > Olmec Cheers from sunny Wellington, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.

Re: [GENERAL] Trouble running PostgreSQL server / Server must be started under certain locale.

ore > > (it looks like the locale is set to {blank} ???) > > Not sure what I should do here. Removing mostprest to an older version > might be the way to go? That was Richards suggestion for Geoff who had the problem. What OS are you running PostgreSQL on? > Olmec Sinclair Cheers

Re: [GENERAL] Understanding ps -ef "command" column

On 23/02/2008, David Jaquay <[EMAIL PROTECTED]> wrote: > When I do a ps -ef, in the command column, I see: > > postgres: postgres dbname 10.170.1.60(57413) idle This doesn't resemble any "ps -ef" output I've ever seen. What OS is this on, what&#x

Re: [GENERAL] Are indexes blown?

rough completely ... that's not going to give us the desired result... Try this: for z in `seq 1 3600`; do top -b -d 1 -n 1| awk -f top.awk; done | tee topoutput Not sure whether it's going to give us the desire granularity of time... Cheers, Andrej -- Please don't top pos

Re: [GENERAL] Where is the system-wide psqlrc on RHEL4?

L4, the system-wide psqlrc > is in /etc/sysconfig/pgsql/ Another alternative (quick & dirty) would have been to strace -o whereisit psql and grep psqlrc whereisit > -- Dean Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes con

Re: [GENERAL] ERROR: COPY quote must be a single ASCII character

The answer is simple no. I know I can to some preprocessing on input files using awk, sed etc. but don't want to change the structure of the file. Colin Wetherbee wrote: Andrej Kastrin wrote: ||5354235||,||some text...|| ||1234567||,||some text...|| ||1234568||,||some text...|| Th

[GENERAL] ERROR: COPY quote must be a single ASCII character

'||'; but the error: ERROR: COPY quote must be a single ASCII character Any solution? Thank you in advance. Best, Andrej ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Reload only specific databases from pg_dumpall

ommand line twice. :} And I didn't like the idea of # writing/saving two separate scripts - shoot me :D # # It creates two temporary files that it hopefully wipes after a # successful run. # hacked up by andrej function usage { echo "Usage: $0 databasename inputfile outputfile" echo

Re: [GENERAL] Reload only specific databases from pg_dumpall

Or, for the heck of it: sed -n -e '/DATABASE smarlowe/p' -e '141,334p' test.sql > clean.sql ;} Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---

Re: [GENERAL] Postgres with daemontools or similar

-Mail and pager alerts. Monitoring the postmasters presence and the ability to connect to 5432 Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---(end o

Re: [GENERAL] "pg_ctl: cannot be run as root"

ing to restart the postgres server, I get this: ... > PS: Running Leopard on MacPro. I don't know MacOS very well, and it's been a while that I last had my hands on MacOS X (>2 years). Are you saying that you use MacOS as user root by default, rather than as a non privileged account? Che

Re: [GENERAL] Is PostGreSql's Data storage mechanism "inferior"?

license (for varied reasons) I think that OpenSource hardliners like RMS would argue that the BSD license is *NOT* in the true spirit of OpenSource *BECAUSE* of what you list as a bonus of it ... the locking down of benefits reaped from OpenSource not getting back into the stream. Cheers, Andrej

[GENERAL] Members-choice award at LinuxQuestions.org

http://www.linuxquestions.org/questions/2007-linuxquestions.org-members-choice-awards-79/database-of-the-year-610185/ Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---(e

Re: [GENERAL] How to automate password requests?

into ~/.pgpass . You best forget about the thought of having a shell variable with the password ;} > Regards > Marten Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.

Re: [GENERAL] Hijack!

On 12/15/07, Richard Huxton <[EMAIL PROTECTED]> wrote: L > Leif B. Kristensen wrote: O > I > me too. L > t > > ' > On Wednesday 12. December 2007, Gregory Stark wrote: > s >> "Alvaro Herrera" <[EMAIL PROTECTED]> writes: >>>> Thomas Kellerer wrote: > n Joshua D. Drake, 11

Re: [GENERAL] Import LDAP data to a Postgres database

and getting LDAP tree data into any RDBMS can be done, but it won't be trivial once you get to tree objects that have more than one value per attribute, i.e. you'll have to map those attributes into separate tables. > Thanks to all. Cheers, Andrej -- Please don't top post,

Re: [GENERAL] Sharing static data among several databases

's the customer's data which needs to be isolated. I appreciate that. But realistically if you had locked information isolation down via permissions and appropriate views the information for each customer would be as safe as it would using separate databases or even servers. Cheers, An

  1   2   >