Hi,
I am trying to load CSV files into postgresql via pgloader, it returned the
following error, any suggestions to fix it?
I have a line "lc_messages = C" in my pgloader.conf, would this line cause the
problem?
regards
pgloader ERRORpermission denied to set parameter "lc_messages"
p
Dmitriy Igrishin wrote:
While developing a C++ client library for Postgres I felt lack of extra
information in command tags in the CommandComplete (B) message [...]
>>> It seems like bad design to me to keep a list of prepared statements
>>> on the client side when it is already kept on
Hi, where did you put your WAL?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/In-memory-Database-for-postgres-tp1917268p5760845.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgre
Hello:
When I traced the source code of PG more deeply.
I can find the following:
VirtualTransactionId *
GetCurrentVirtualXIDs(TransactionId limitXmin, bool excludeXmin0,
bool allDbs, int excludeVacuum,
int *nvxids)
{
……
for (index =
Hello,
I'm trying to find a description file to build a DVD with all PostgreSQL
software for one architecture.
I would like to carry it, with the Debian set, since I'm always downloading
it from Internet, and sometimes it's boring to wait.
Does someone already build a jigdo file for this? Would
In trying to learn about aggregates, I came across this seemingly odd
behavior:
(postgres@[local]:5435 08:27:42) [postgres]> CREATE AGGREGATE example_max
(TEXT) (SFUNC = greatest, STYPE = TEXT);
ERROR: syntax error at or near "greatest"
LINE 1: CREATE AGGREGATE example_max (TEXT) (SFUNC = greate
Hi All,
Greetings for the day.
Recently, I have installed the PostgreSQL 9.3 on my local ubuntu machine
for testing the new features in PG 9.3. I have created few test tables as
well. Now, I am trying to take the dump from the 9.3 binaries and getting
the below error.
postgres@test-ubuntu:/opt/P
On 06/24/2013 11:36 PM, Frank Broniewski wrote:
However, when I call createdb, it fails:
$ createdb -h 192.168.1.4 -U postgres --no-password
JobSearch
createdb: could not connect to database postgres:
fe_sendauth: no
password supplied
Hi,
On 06/25/2013 12:05 AM, ascot.m...@gmail.com wrote:
Hi,
I am trying to load CSV files into postgresql via pgloader, it returned the
following error, any suggestions to fix it?
I have a line "lc_messages = C" in my pgloader.conf, would this line cause the
problem?
Assuming you are not runnin
Hello
GREATEST and LEAST are SQL functions, but it is not internal functions
listed in pg_proc table due different implementation. It is much more
similar to CASE statement than function although syntax is same.
for your purpose, you should to create SQL function wrapper of this
construct - then
On Sat, Jun 22, 2013 at 12:19 AM, Stephen Rasku wrote:
> I am trying to write a script that will create and populate a
> database. I don't want to enter a password every time so I want to
> use a .pgpass file. It has the correct permissions:
>
> $ ls -l $PGPASSFILE
> -rw--- 1 Stephe
>>But, if you do PITR using the same directory (which I haven't), I
>>think you would need to somehow replace the stats with the ones you
>>want, may be from your backup of the same (that is, of
>>pg_stat/*.stat), though I am not sure if that would be correct. I
>>doubt if WAL replay (as in a consi
On Fri, Jun 21, 2013 at 11:58:27AM -0700, hartrc wrote:
> I was wondering what is the expected release data for the next PostgreSQL
> patch - presumably 9.1.10? Although there is no documentation stating
> release timeframes I'd become accustomed to them being released in the first
> week of the mo
2013/6/25 Albe Laurenz
> Dmitriy Igrishin wrote:
> While developing a C++ client library for Postgres I felt lack of
> extra
> information in command tags in the CommandComplete (B) message [...]
>
> >>> It seems like bad design to me to keep a list of prepared statements
> >>> on the c
On Tue, Jun 25, 2013 at 11:32 PM, Sameer Thakur wrote:
>>>But, if you do PITR using the same directory (which I haven't), I
>>>think you would need to somehow replace the stats with the ones you
>>>want, may be from your backup of the same (that is, of
>>>pg_stat/*.stat), though I am not sure if t
Hello,
I am researching about a Data Minning and analisys tool for Postgres (or
even Mysql).
Do you know any tool for relational data mining?
Regards.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Data-Minning-and-analisys-tool-for-Postgres-tp5760818.html
Sent fr
Hi,
after a server crash the following messages appear in the log file every
minute:
2013-06-25 15:02:15 CEST [::18264:1:] LOG: autovacuum: found orphan
temp table "pg_temp_47"."est_backup_ids_temp" in database "estudis1314"
2013-06-25 15:02:15 CEST [::18264:2:] LOG: autovacuum: found orphan
On Tue, Jun 25, 2013 at 10:46 AM, kathyn wrote:
> Hello,
>
> I am researching about a Data Minning and analisys tool for Postgres (or
> even Mysql).
>
> Do you know any tool for relational data mining?
>
What exactly are your goals here exactly?
If there is a specific goal you are trying to achi
On 06/25/13 06:13, Nicolau Roca wrote:
>
> 2013-06-25 15:02:15 CEST [::18264:1:] LOG: autovacuum: found orphan
> temp table "pg_temp_47"."est_backup_ids_temp" in database "estudis1314"
> 2013-06-25 15:02:15 CEST [::18264:2:] LOG: autovacuum: found orphan
> temp table "pg_temp_47"."est_backup_f
On Tue, Jun 25, 2013 at 6:43 PM, Nicolau Roca wrote:
> Hi,
> after a server crash the following messages appear in the log file every
> minute:
>
> 2013-06-25 15:02:15 CEST [::18264:1:] LOG: autovacuum: found orphan temp
> table "pg_temp_47"."est_backup_ids_temp" in database "estudis1314"
> 2
i need to do clustering, association rules and classification... i tried with
weka and rapidminer but i need "true" relational dm tool
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Data-Minning-and-analisys-tool-for-Postgres-tp5760818p5760963.html
Sent from the Pos
Hello,
I have a win32 application. It uses gtk for GUI and postgres. Recently I
upgraded to newer gtk and postgres 9.2. I'm now getting utf8 errors from
postgres.
The thing I don't understand that the queries, which postgres complains
about, seem to be perfectly valid.
For example
LOG: statemen
On 06/25/2013 12:18 PM, Jiří Pavlovský wrote:
Hello,
I have a win32 application. It uses gtk for GUI and postgres. Recently I
upgraded to newer gtk and postgres 9.2. I'm now getting utf8 errors from
postgres.
The thing I don't understand that the queries, which postgres complains
about, seem to
Hello
in this mailing list is not high traffic,
please try to ask on postgresql general mailing list
http://www.postgresql.org/list/pgsql-general/
or
Czech google groups https://groups.google.com/forum/?hl=cs#!forum/postgresql-cz
2013/6/25 Jiří Pavlovský :
> Hello,
>
> I have a win32 applicat
On 25.6.2013 21:39, Pavel Stehule wrote:
> Hello
>
> in this mailing list is not high traffic,
>
> please try to ask on postgresql general mailing list
>
> http://www.postgresql.org/list/pgsql-general/
>
> or
>
> Czech google groups
> https://groups.google.com/forum/?hl=cs#!forum/postgresql-cz
>
>
2013/6/25 Jiří Pavlovský :
> On 25.6.2013 21:39, Pavel Stehule wrote:
>> Hello
>>
>> in this mailing list is not high traffic,
>>
>> please try to ask on postgresql general mailing list
>>
>> http://www.postgresql.org/list/pgsql-general/
>>
>> or
>>
>> Czech google groups
>> https://groups.google.
Hello All,
Is there a way to disable chasing LDAP referrals in PostgreSQL?
Take the following LDAP config options from pg_hba.conf
ldapserver=server.org.com
ldapbinddn="cn=bindUser,cn=users,dc=core,dc=dir,dc=org,dc=com"
ldapbindpasswd="bindPass" ldapbasedn="dc=core,dc=dir,dc=org,dc=com"
ldapsear
Update: I have successfully used this configuration with a month's worth of
WALs (tens of thousands), run a test restore, and everything appears to
have worked as expected. So at least based on that test, this
configuration seems fine.
-Dan
On Fri, May 24, 2013 at 4:42 PM, Dan Birken wrote:
>
> >
> > I did the following
> > 1. Enabled archiving
> > 2. Executed SQL's 3. Shutdown 4. copied data directory (including the
> > pgstats.stat under global) and archive directory under backup/1
> > repeated 2,3,4 once more
> > So now i have 2 backup directories.
> > Now i created recovery.conf und
Hi ,
Today i m creating a function that includes dynamic concatenation of a
partitioned table name as below :-
test=# CREATE OR REPLACE FUNCTION tmp_trigger_function()
test-# RETURNS TRIGGER AS $$
test$# DECLARE
test$# tbl_name text;
test$# abc varchar;
test$# BEGIN
test$# tbl_name := 'tmp';
test
On Wednesday, June 19, 2013, Sameer Thakur wrote:
> Hello,
> I was trying to figure out how does one recover server statistics to the
> same snapshot to which a database is restored after PITR.
>
Do you think that it is important to do so? Are you experiencing problems
which you believe are due
EXECUTE 'insert into tmp'||abc|| 'values ( NEW.* )';
This works :)
2013/6/26 Adarsh Sharma :
> Hi ,
>
> Today i m creating a function that includes dynamic concatenation of a
> partitioned table name as below :-
>
> test=# CREATE OR REPLACE FUNCTION tmp_trigger_function()
> test-# RETURNS TRIGGER AS $$
> test$# DECLARE
> test$# tbl_name text;
> test$# abc varchar;
Thanks Ian for such a quick response. But my NEW.* will be 10-15 columns
row.
test=# CREATE OR REPLACE FUNCTION tmp_trigger_function()
test-# RETURNS TRIGGER AS $$
test$# DECLARE
test$# stmt text;
test$# abc varchar;
test$# BEGIN
test$# select to_char(NEW.a::timestamp,'mmdd') into abc ;
test$#
On Wed, Jun 26, 2013 at 2:10 PM, Jeff Janes wrote:
> On Wednesday, June 19, 2013, Sameer Thakur wrote:
>>
>> Hello,
>> I was trying to figure out how does one recover server statistics to the
>> same snapshot to which a database is restored after PITR.
>
>
> Do you think that it is important to do
> Thanks
>
>
> On Wed, Jun 26, 2013 at 10:52 AM, Ian Lawrence Barwick
> wrote:
>>
>> 2013/6/26 Adarsh Sharma :
>> > Hi ,
>> >
>> > Today i m creating a function that includes dynamic concatenation of a
>> > partitioned table name as below :-
>> >
>> > test=# CREATE OR REPLACE FUNCTION tmp_trigger_
Passing each column seems not good because if column additon/deletion
happens in future , we also need to change function as well. I think below
will work :-
test=# CREATE OR REPLACE FUNCTION tmp_trigger_function()
test-# RETURNS TRIGGER AS $$
test$# DECLARE
test$# abc varchar;
test$# BEGIN
test$#
Able to fix but still new error :(
test=# CREATE OR REPLACE FUNCTION tmp_trigger_function()
test-# RETURNS TRIGGER AS $$
test$# DECLARE
test$# stmt text;
test$# abc varchar;
test$# BEGIN
test$# select to_char(NEW.a::timestamp,'mmdd') into abc ;
test$# stmt := 'insert into tmp'||abc|| ' values
38 matches
Mail list logo
