On Tue, Apr 14, 2009 at 11:56 AM, vj harik...@gmail.com wrote:
I am new to postgreSQL and have a working experience with SQLite.
While i am creating a table, i want to use constraints or more so -
use checks to see that
I think that you will find that PostgreSQL has more than enough
On Tue, 14 Apr 2009 13:26:24 -0700
Steve Crawford scrawf...@pinpointresearch.com wrote:
Ivan Sergio Borgonovo wrote:
I still have to investigate if the tables are getting really
larger... but at a first guess there shouldn't be any good
reason to see tables getting so large so fast... so I
I've followed the implementation instructions at 24.4.2:
http://www.postgresql.org/docs/current/static/warm-standby.html
And I've used the archive/restore commands from the example in F23.2:
http://www.postgresql.org/docs/current/static/pgstandby.html
This all works great. The primary backs up
Hello,
I'm trying to use full text search against text that contains lots of
technical terms, and I'd like to add some custom stemming. I have many
occurrances of libblah or blahtool, and I'd like to remove the lib
and tool terms since they are meaningless search terms.
Is there an easy way to
On Apr 14, 2009, at 3:47 PM, Dan Hayes wrote:
I've followed the implementation instructions at 24.4.2:
http://www.postgresql.org/docs/current/static/warm-standby.html
And I've used the archive/restore commands from the example in F23.2:
On Tue, 14 Apr 2009, William Temperley wrote:
I could potentially run a database in each of these countries and
provide 100% uptime, obviously raising the issue of version conflicts
that would require hand-merging.
It sounds like you want an asynchronous master-slave database architecture
Excellent! Thanks. One other quick question... What would happen if I
didn't delete the recovery.conf file? Is that step just to prevent
accidentally restarting the server with it there?
On Tue, Apr 14, 2009 at 6:26 PM, Erik Jones ejo...@engineyard.com wrote:
On Apr 14, 2009, at 3:47 PM,
If you're using full page write = off, prefetching data page from
WAL speeds up the recovery too. I've proposed this patch but was
carried over to 8.5. I'm planning to release this as an external
tool, which will not work well with Hot Standby but will work in
usual recovery.
I'm not sure how
Hi everybody,
When I was working with Postgis , I had the following error:
*failed: ERREUR: VACUUM ne peut pas être exécuté à partir d'une fonction ou
d'une chaîne
contenant plusieurs commandes* ( VACUUM cannot be executed from a function
or from a chain containing several commands)
*Error
In response to ahmed soua :
Hi everybody,
When I was working with Postgis , I had the following error:
failed: ERREUR: VACUUM ne peut pas être exécuté à partir d'une fonction ou
d'une chaîne
contenant plusieurs commandes ( VACUUM cannot be executed from a function or
from a chain
wstrzalka wrote:
Why PG sort's my data in case insensitive manner?
masterdb=# select name, setting from pg_settings WHERE name ilike 'lc
%';
name | setting
-+-
lc_collate | en_US.UTF-8
Because that's what en_US.UTF-8 does. If you want computer-style
Why PG sort's my data in case insensitive manner?
masterdb=# SELECT name FROM enterprises ORDER BY name;
name
--
abc
AKS 514
aks518
AKSFree1
..
The worst (totally mess) example is:
masterdb=#
Richard Huxton wrote:
wstrzalka wrote:
Why PG sort's my data in case insensitive manner?
masterdb=# select name, setting from pg_settings WHERE name ilike 'lc
%';
name | setting
-+-
lc_collate | en_US.UTF-8
Because that's what en_US.UTF-8 does. If
ahmed soua escribió:
Hi everybody,
When I was working with Postgis , I had the following error:
*failed: ERREUR: VACUUM ne peut pas être exécuté à partir d'une fonction ou
d'une chaîne
contenant plusieurs commandes* ( VACUUM cannot be executed from a function
or from a chain containing
On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones kyn...@gmail.com wrote:
When I try to run
% psql
as the postgres user, I get the error
psql: FATAL: no pg_hba.conf entry for host [local], user postgres,
database
Hi
I need to make a change to a table that many stored procedures depend
on. Is there an automatic way of finding all the functions that depend
on a certain table?
I have tried the dependents and dependencies report in pgAdmin but these
do not include functions.
Thank you in advance,
Kaarel
At 07:57 PM 4/14/2009, Richard Huxton wrote:
wstrzalka wrote:
Why PG sort's my data in case insensitive manner?
masterdb=# select name, setting from pg_settings WHERE name ilike 'lc
%';
name | setting
-+-
lc_collate | en_US.UTF-8
Because that's what
Hello
no
but, you can search tablename in source code - all stored procedures
store src in pg_proc.prosrc column
regards
Pavel Stehule
2009/4/14 Kaarel Kitsemets k...@klaabu.com:
Hi
I need to make a change to a table that many stored procedures depend on. Is
there an automatic way of
On Mon, 2009-04-13 at 14:55 -0700, Christophe wrote:
On Apr 13, 2009, at 2:54 PM, Joshua D. Drake wrote:
Yes Vimeo can download and I will have it up soon.
Thank you! My work here is done. :)
And it is now up on vimeo.
http://www.vimeo.com/4144396
Joshua D. Drake
--
PostgreSQL -
Kynn Jones kyn...@gmail.com writes:
Is there a general way to get positive confirmation that a particular
pg_hba.conf has been re-read upon bouncing the server with
kill -HUP PID
Well, you could strace the postmaster and see what files it reads
in response to the signal.
I can't avoid it any longer and have to move an old RT2 installation to
a new machine. (I'll upgrade to RT3 on that machine.)
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script created
above to build the database
On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
I can't avoid it any longer and have to move an old RT2 installation to
a new machine. (I'll upgrade to RT3 on that machine.)
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) .
Joshua D. Drake j...@commandprompt.com writes:
On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script created
above to build the database on the new
Hi All
I'm wondering if anyone can share any insights or experience with
temporary versions of databases, allowing disconnected editing
during Internet downtime.
The use-case is that I run a Postgres database, hosted in the UK, but
used by scientists in several other countries - Ecuador,
Roderick A. Anderson wrote:
I can't avoid it any longer and have to move an old RT2 installation
to a new machine. (I'll upgrade to RT3 on that machine.)
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script
I have tried all possible variation of syntax I can imagine, like
host all all 202.18.10.0/24
ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
host all all 202.18.10.0/24 ldap
ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
host all all 202.18.10.0/24
John R Pierce wrote:
Roderick A. Anderson wrote:
snip /
make sure pg_hba.conf on the old machine allows you to connect from the
new machine's IP address as the user postgres (this may require setting
a database password for the postgres user on the old machine if the
'host' authentication
In response to Kaarel Kitsemets :
Hi
I need to make a change to a table that many stored procedures depend
on. Is there an automatic way of finding all the functions that depend
on a certain table?
Not really, but for functions written not in C you can ask the column
prosrc from the table
Joshua D. Drake wrote:
On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
I can't avoid it any longer and have to move an old RT2 installation to
a new machine. (I'll upgrade to RT3 on that machine.)
The plan calls for a pg_dump using my workstation using CREATE the
database and
On 14/04/2009 13:28, sandiphw wrote:
host all all 202.18.10.0/24
ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people;
I don't know anything about LDAP, I'm only scanning the PG docs, but
this version is missing the ldap method. It should be:
host all all 202.18.10.0/24 ldap
Tom Lane wrote:
Joshua D. Drake j...@commandprompt.com writes:
On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script created
above to build the database
On Tue, Apr 14, 2009 at 8:28 AM, sandiphw sandi...@hotmail.com wrote:
I have tried all possible variation of syntax I can imagine, like
host all all 202.18.10.0/24
ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
host all all 202.18.10.0/24 ldap
On Tue, Apr 14, 2009 at 12:22 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Kynn Jones kyn...@gmail.com writes:
On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones kyn...@gmail.com wrote:
as the postgres user, I get the error
On Tue, Apr 14, 2009 at 1:28 PM, sandiphw sandi...@hotmail.com wrote:
I have tried all possible variation of syntax I can imagine, like
host all all 202.18.10.0/24
ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
host all all 202.18.10.0/24 ldap
Kynn Jones escribió:
Is there a general way to get positive confirmation that a particular
pg_hba.conf has been re-read upon bouncing the server with
SHOW hba_file;
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Thank you.
That worked for me :)
Kaarel
Pavel Stehule wrote:
Hello
no
but, you can search tablename in source code - all stored procedures
store src in pg_proc.prosrc column
regards
Pavel Stehule
2009/4/14 Kaarel Kitsemets k...@klaabu.com:
Hi
I need to make a change to a table that
I still have to investigate if the tables are getting really
larger... but at a first guess there shouldn't be any good reason to
see tables getting so large so fast... so I was wondering if
anything could contribute to make a backup much larger than it was
other than table containing more
Dear all,
Benetl, a free ETL tool for files using postgreSQL, is out in version 2.7.
You can freely download it at : www.benetl.net
New functions, performance improved, you should update.
You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract,_transform,_load
Thanks
I like to keep a grants script around that will fix all of the
permissions in my enviornments (I've got heavy development going on so
i'm frequently dropping and recreating an environment, or duplicating
the schema elsewhere)
finding a list of sequences that i could build dynamic sql off of was a
On Tue, Apr 14, 2009 at 2:53 PM, Alvaro Herrera
alvhe...@commandprompt.comwrote:
Kynn Jones escribió:
Is there a general way to get positive confirmation that a particular
pg_hba.conf has been re-read upon bouncing the server with
SHOW hba_file;
That's handy. Thanks!
Kynn
Ivan Sergio Borgonovo wrote:
I still have to investigate if the tables are getting really
larger... but at a first guess there shouldn't be any good reason to
see tables getting so large so fast... so I was wondering if
anything could contribute to make a backup much larger than it was
other
Hi All,
I am new to postgreSQL and have a working experience with SQLite.
While i am creating a table, i want to use constraints or more so -
use checks to see that
1. the email address is valid [a basic check with no bells and
whistles is good enuf for me].
2. On a separate column entry, i
Greetings,
We recently upgraded from 7.4.1 to 8.3.6 postgre and have come across
what appears to be a postgre serverlog file handle leak.
Interestly enough, the serverlog file handles (over 100 of them) are
being maintained by our application server process. We are using JBoss
4.2.3 with
43 matches
Mail list logo