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,
isn't your --no-password switch preventing
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
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 the server
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
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 =
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.
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
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 running
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 sra...@gmail.com 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
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 consistent
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 month
2013/6/25 Albe Laurenz laurenz.a...@wien.gv.at
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
On Tue, Jun 25, 2013 at 11:32 PM, Sameer Thakur samthaku...@gmail.com 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
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
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 romi...@gmail.com 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
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_files_temp in
On Tue, Jun 25, 2013 at 6:43 PM, Nicolau Roca nicolau.r...@uib.cat 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
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
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:
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ý j...@pavlovsky.eu:
Hello,
I have a
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
2013/6/25 Jiří Pavlovský j...@pavlovsky.eu:
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
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
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
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 under
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';
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 to
EXECUTE 'insert into tmp'||abc|| 'values ( NEW.* )';
This works :)
2013/6/26 Adarsh Sharma eddy.ada...@gmail.com:
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$#
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 ;
On Wed, Jun 26, 2013 at 2:10 PM, Jeff Janes jeff.ja...@gmail.com 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
Thanks
On Wed, Jun 26, 2013 at 10:52 AM, Ian Lawrence Barwick barw...@gmail.com
wrote:
2013/6/26 Adarsh Sharma eddy.ada...@gmail.com:
Hi ,
Today i m creating a function that includes dynamic concatenation of a
partitioned table name as below :-
test=# CREATE OR REPLACE FUNCTION
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
38 matches
Mail list logo