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 occu
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"
sor
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=# S
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.UT
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 conta
On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe wrote:
> On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones 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 "postgres", SSL off
> >
>
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 en_US
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 :
> 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 f
Kynn Jones writes:
> On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe wrote:
>> On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones wrote:
>>> as the postgres user, I get the error
>>> psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres",
>>> database "postgres", SSL off
>> What do all t
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 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
Well, you could strace the postmaster and see what files it reads
in response to the signal.
regards, tom l
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" 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 system.
> You wan
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, Vietna
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
created
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
"ldap://202.18.10.1:389/dc
John R Pierce wrote:
Roderick A. Anderson wrote:
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 method
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 t
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 "ldap:
Tom Lane wrote:
"Joshua D. Drake" 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 system.
On Tue, Apr 14, 2009 at 8:28 AM, sandiphw 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
> ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
> h
On Tue, Apr 14, 2009 at 12:22 PM, Tom Lane wrote:
> Kynn Jones writes:
> > On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe >wrote:
> >> On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones wrote:
> >>> as the postgres user, I get the error
> >>> psql: FATAL: no pg_hba.conf entry for host "[local]", use
On Tue, Apr 14, 2009 at 1:28 PM, sandiphw 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
> ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
> ho
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 :
Hi
I need to make a change to a table that many stored proced
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 records?
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 for
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
On Tue, Apr 14, 2009 at 2:53 PM, Alvaro Herrera
wrote:
> 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 than
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 wou
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 Hiberna
On Tue, Apr 14, 2009 at 11:56 AM, vj 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
features to solve this
On Tue, 14 Apr 2009 13:26:24 -0700
Steve Crawford 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 was
> > wondering if an
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 t
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
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:
http://www.postgresql.org/docs/current/static/pgstandby.h
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
whe
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 wrote:
>
> On Apr 14, 2009, at 3:47 PM, Dan Hayes wrote:
>
>
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 ho
Hi,
When logged in as administrator, i start the postgres server with
the following command:
runas /user:postgres "D:\postgres_new\pgsql\bin\pg_ctl.exe start -D
D:\postgres_new\pgsql\data"
The problem is "runas" cmd is not script friendly as i can not
pass the password as a c
Will,
William Temperley wrote:
Hi All
I'm wondering if anyone can share any insights or experience with
temporary versions of databases, allowing "disconnected editing"
during Internet downtime.
What do your users use for updating data? Software that you developed
for them? Do they use a w
CM J wrote:
Hi,
When logged in as administrator, i start the postgres server
with the following command:
runas /user:postgres "D:\postgres_new\pgsql\bin\pg_ctl.exe start -D
D:\postgres_new\pgsql\data"
The problem is "runas" cmd is not script friendly as i can
not pass
Well, if you don't delete the recovery.conf and you *do* delete
pg_standby's stop file (or it gets deleted, for example if you set it
to go under /tmp and the server is restarted for whatever reason) the
server will attempt to go back into recovery mode using your
configured recovery comman
48 matches
Mail list logo
