gt; at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
>
>
Looks like the driver issue.
./runMTK.sh is EnterpriseDB Migrati
to address: Name or service not known
I guess problem with your server name resolution. Its worth checking as
said, using psql -h localhost or ping localhost.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
in pg_stat_replication view column ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
the slave is OK and can be send read stmt.We have
some monitor use this and some udf get the alived slave for client read.Now
I find I'm wrong.
Any comment?
Hot_standby parameter should be turned on at slave postresql.conf, is that
checked ?
---
Regards,
Raghavendra
EnterpriseDB
Thanks
On 27 Jan 2014 22:35, Bhushan Pathak bhushan.patha...@gmail.com wrote:
Hello,
We have recently shifted to postgresql version 9.2.4 from 9.1.3. After
the migration, we observed that some of our delete queries on single table
[which have triggers, which in turn call other functions] have
On Thu, Jan 9, 2014 at 5:04 AM, Tom Lane t...@sss.pgh.pa.us wrote:
CS DBA cs_...@consistentstate.com writes:
1) \d and schema's
- I setup 2 schema's (sch_a and sch_b)
- I added both schema's to my search_path
- I created 2 tables: sch_a.test_tab and sch_b.test_tab
If I do a \d with
On Tue, Dec 31, 2013 at 12:20 AM, AI Rumman rumman...@gmail.com wrote:
Hi,
What does the error message mean?
ERROR: unexpected chunk number 1 (expected 2) for toast value 179638221
in pg_toast_16700
Please let me know.
Thanks.
Well explained here...
='public';)
do
/opt/PostgreSQL/9.3/bin/psql -p 5432 -U postgres -c alter table $i
rename column $OLDCOLUMN to $NEWCOLUMN;
done
Replace the port,user,OLDCOLUMN, NEWCOLUMN and SCHEMA according to your
requirement.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Dec 17, 2013 at 2:23 PM, Raghavendra
raghavendra@enterprisedb.com wrote:
On Tue, Dec 17, 2013 at 1:29 PM, Stefan Schwarzer
stefan.schwar...@unep.org wrote:
Hi there,
I have dozens of tables where I need to rename one column in each of
these. Is there any generic way to do
that by the time checkpoint arrives
there will be left only with f
ew dirty pages, instead of
having
lots of dirty
pages
to carry out by i
tself
alone
and cause I/O loaded
.
---
Regards,
Raghavendra
(user1 can do this). I
don't want to set lo_compat_privileges as then user3 (who can't SELECT
from the services tables) would be able to read the large object.
GRANT SELECT,UPATE ON LARGE OBJECT to user2;
Will this work...
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http
On Tue, Sep 3, 2013 at 11:36 AM, ascot.m...@gmail.com
ascot.m...@gmail.comwrote:
Hi,
Can you please advise how to find out all unused indexes in PG?
regards
Below wiki link should help; under Unused Index section:
http://wiki.postgresql.org/wiki/Index_Maintenance
---
Regards,
Raghavendra
:01.146 IST [14152]: [9-1] db=,user= LOG: parameter
log_min_duration_statement changed to 1s
2013-08-13 03:08:03.297 IST [26559]: [1-1] db=d1,user=postgres LOG:
duration: 2159.281 ms statement: vacuum VERBOSE ANALYZE ;
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http
[]);
CREATE TABLE
postgres=# insert into foo values (array[row(1,2)::abc]);
INSERT 0 1
postgres=# insert into foo values (array[row('1','2')::abc]);
INSERT 0 1
postgres=# select * from foo ;
val
---
{(1,2)}
{(1,2)}
(2 rows)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http
On Wed, Aug 7, 2013 at 3:53 AM, Raghavendra
raghavendra@enterprisedb.com wrote:
postgres=# insert into foo values (array[row(1,2)::abc]);
Also because all array members must be of the same db type, you can:
insert into foo values (array[row(1,2)]::abc[]). This can be helpful
On Tue, Jul 30, 2013 at 9:51 AM, saritha N saritha.0...@gmail.com wrote:
Thanks for your reply Raghavendra,
Thanks for the update.
Request to mark postgresql group email while replying so it will help much
if other's have better idea as well if any correction in my test case.
Whatever you
[]) = '{Infosys}';
UPDATE 1
postgres=# select * from xdata ;
id | xmlcode
+
1 | valuesEnterprisedb/values
1 | valuesWipro/values
1 | valuesInfosys-Bangalore/values
(3 rows)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http
language plpython2u;
ERROR: could not load library
/opt/PostgreSQL/93b2src/lib/postgresql/plpython2.so:
/opt/PostgreSQL/93b2src/lib/postgresql/plpython2.so: undefined symbol:
PyObject_Bytes
Not certain on the error. Retake the test with above steps you should
succeed.
---
Regards,
Raghavendra
On Fri, Jul 19, 2013 at 1:30 PM, John R Pierce pie...@hogranch.com wrote:
On 7/19/2013 12:12 AM, Raghavendra wrote:
... its interesting, why your replies populate as distinct thread rather
than of continuing one
the mailer they are using isn't generating 'In-Reply-To' and/or
'References
On Mon, Jul 15, 2013 at 7:10 PM, guxiaobo1982 guxiaobo1...@qq.com wrote:
It works with ActivePython 3.2.2.3,
Thanks for notifying.
but not ActivePython 2.7.2.5.
No idea... :), I tried AP 3.2 with PG 9.2 PG 9.3B it went fine for me.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog
--
Near to my house there's no any Pizza Hut restuarant
I wont like pizza, but friends are crazy of it
(2 rows)
or
with ILIKE
select * from foo where v ilike '%hut%';
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
/wiki/Return_more_than_one_row_of_data_from_PL/pgSQL_functions
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/function-returning-select-result-to-JDBC-tp5763565.html
Sent from
thoughts to conclude this. Thanks Asif.
Question still in mind, Why plpython depends on Shared Libraries (.so) ?
http://www.postgresql.org/docs/9.3/static/install-requirements.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
synchronous_commit
= off, how can we get in such situation?
Best regards,
depesz
Increasing the wal_keep_segments ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
=/opt/ActivePython-3.2/
export LD_LIBRARY_PATH=/opt/ActivePython-3.2/lib/
Now start the postgresql cluster and try creating the language;
-bash-4.1$ psql
psql.bin (9.2.3)
Type help for help.
postgres=# create language plpython3u;
CREATE LANGUAGE
postgres=#
---
Regards,
Raghavendra
EnterpriseDB
);
acquistolotto
---
(1 row)
or
postgres=# select acquistoLotto(0, 'grossista', 52187073424, 10,
'1-22-2013'::date, 'ciao ciaociao', 10);
acquistolotto
---
(1 row)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
schemas,if you want to get rid of the
messages, just do DROP SCHEMA pg_temp_NNN CASCADE;
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
by Craig on SO with links (code/implementation).
Below link helps you about how to on the updatable views.
http://stackoverflow.com/questions/13151566/cannot-update-view
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
as row header and 4 bytes of integer data.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
... :) )
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
till to the acceptable time for
you from the snapshot.
http://www.postgresql.org/docs/9.2/static/recovery-target-settings.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
with some changes. Sure there will be answer's here
if someone has more insight on this scenario)
Its good to include this parameter in recovery.conf at the recovery start
time.
-- Raghav
2013/5/22 Raghavendra raghavendra@enterprisedb.com
On Wed, May 22, 2013 at 3:38 PM, Fabio Rueda Carrascosa
On Wed, May 22, 2013 at 4:15 PM, Raghavendra
raghavendra@enterprisedb.com wrote:
On Wed, May 22, 2013 at 3:53 PM, Fabio Rueda Carrascosa
avances...@gmail.com wrote:
Can I stop the server and modify recovery.conf with this param and
restart it again without problems?
It should work
,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
topic's are well covered in PostgreSQL documentation, or you can
also refer to PostgreSQL Administration Cookbook.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
postgres=# select version();
version
---
PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red
.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, May 15, 2013 at 3:18 PM, Hari Babu haribabu.ko...@huawei.comwrote:
On Wednesday, May 15, 2013 2:50 PM Raghavendra wrote:
Hi,
** **
While trying new features of Pg 9.3 beta, my eyes caught on
pg_basebackup -R option so I have given a try but somehow I didn't succeed
On Wed, May 15, 2013 at 4:26 PM, Hari Babu haribabu.ko...@huawei.comwrote:
on Wednesday, May 15, 2013 4:04 PM Raghavendra wrote:
In earlier version of primary connection information was enclosed within
one single quote:
primary_conninfo = 'user=postgres host=localhost port=5432
On Mon, May 13, 2013 at 11:17 AM, Amit Langote amitlangot...@gmail.comwrote:
However, PG documentation doesn't highlight about this in psql or PAM
section, because log entries written are slightly confusing.
http://www.postgresql.org/docs/9.2/static/auth-methods.html
='table_name';
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
to
understand the above scenario.
Any help will be highly appreciated.
Thanks in advance.
---
Regards,
Raghavendra
On Wed, May 8, 2013 at 4:55 PM, Amit Langote amitlangot...@gmail.comwrote:
Hello Raghavendra,
I think probably psql is a problem here. WIthout -W (force password
before connect) option psql has no way knowing if this user needs a
password to connect to the given database. So, psql first
On Tue, Feb 5, 2013 at 3:47 PM, Thierry Hauchard gesteam_...@gesteam.frwrote:
Hi,
Using COPY FROM doesn't work if the path of the file has accentuated
characters : command doesn't find the file.
COPY FROM 'C:/import/prénoms/datas.txt' is so impossible.
Is there a turnover ?
PG 8.4,
=(default 200ms, change to 50ms)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
Thanks and Regards
Radha Krishna
--
Date: Mon, 21 Jan 2013 08:15:47 +0100
Subject: Re: [GENERAL] pg_Restore
From: mag...@hagander.net
Alex
Can you try installing again after executing below command as
Adminstrator...
$ cat /etc/sysctl.conf | sudo xargs sysctl -w
Also do share the information requested here...
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
;
Aggregate (cost=1.02..1.03 rows=1 width=0) (actual
time=0.015..0.015 rows=1 loops=1)
Output: count(*)
- Seq Scan on public.cities (cost=0.00..1.02 rows=2 width=0)
(actual time=0.009..0.010 *rows=2* loops=1)
Output: city, location
---
Regards,
Raghavendra
On Sat, Jan 19, 2013 at 12:53 PM, Raghavendra
raghavendra@enterprisedb.com wrote:
On Thu, Jan 17, 2013 at 9:18 AM, classical_89 luongnx...@gmail.comwrote:
When i run a query , i just only want to the affected rows are logged to
log
file,What can i do ? .Is there a parameter
ilike '%pg_read_file%' and
pronamespace=(select oid from pg_namespace where nspname='public');
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
path not allowed
2013-01-08 07:42:02 MSTSTATEMENT: SELECT pg_read_file($1, 0, 1048576)
**
pg_read_file() search's from $PGDATA location.
Can we see how pg_read_file() has been called ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
and
won't start back up.
What message it has written in DB server log file (pg_log) about it not
starting again ?
You can check the last lines of the recent log file under $PG_DATA/pg_log
location, which give very good information about why it has not started.
---
Regards,
Raghavendra
EnterpriseDB
is controlled with temp_buffer(shared by all
backends) in postgresql.conf.
You should check UNLOGGED tables of same family, these tables are visible
to all the backends and data shared across backends.
Since, data is not written to WAL's you should get better performance.
---
Regards,
Raghavendra
On Wed, Oct 31, 2012 at 8:52 PM, Alexander Gataric gata...@usa.net wrote:
What is the data physically stored as for boolean type? I know that it is
one byte but is it char, int, or something else?
False represented by zero bytes and True by 1 byte with value 1.
---
Regards,
Raghavendra
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Oct 16, 2012 at 11:01 AM, Sim Zacks s...@compulab.co.il wrote:
On 10/15/2012 06:11 PM, rektide wrote:
Hi pgsql-general,
I'm interested in writing a supervisory process that can insure worker
processes are
running/spawn new ones if not. These workers will mainly be responsible for
replication).
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
?. Also, Can any one tell, where i need to
look for the errors, when i run a job?
Hope below link help:
http://www.pgadmin.org/docs/dev/pgagent-jobs.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
How about using this way ?
\dt *.*
Or
\dt schemaname.*
--Raghav
Sent from my BlackBerry® smartphone from !DEA
-Original Message-
From: Robert Sosinski rsosin...@ticketevolution.com
Sender: pgsql-general-owner@postgresql.orgDate: Fri, 14 Sep 2012 08:47:54
To:
with above example.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
I tried your code in Postgres 8.2:
8.2 ?, Seems you have tested it in very Old version.
CREATE OR REPLACE FUNCTION _final_mode(anyarray)
RETURNS anyelement AS
$BODY$
SELECT a
FROM unnest($1) a
GROUP BY 1
ORDER BY COUNT(1) DESC, 1
LIMIT 1;
$BODY$
LANGUAGE 'sql' IMMUTABLE;
I think you need to download windows version DD and use it.
http://www.chrysocome.net/dd
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Mon, Jul 16, 2012 at 7:25 PM, raghu ram raghuchenn...@gmail.com wrote:
On Mon, Jul 16, 2012 at 5:44 PM, Olga
\
postgres=# \c oltp_db
FATAL: index pg_attribute_relid_attnum_index contains unexpected zero
page at block 0
HINT: Please REINDEX it.
Previous connection kept
Can anyone please help us.
You have HINT given to REINDEX it. Use reindexdb from OS.
---
Regards,
Raghavendra
EnterpriseDB
On Wed, Jul 4, 2012 at 2:11 PM, Raghavendra
raghavendra@enterprisedb.com wrote:
\
postgres=# \c oltp_db
FATAL: index pg_attribute_relid_attnum_index contains unexpected zero
page at block 0
HINT: Please REINDEX it.
Previous connection kept
Can anyone please help us.
You have
. Should someone here would
have better idea on this.
http://www.postgresql.org/docs/9.0/interactive/runtime-config-developer.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
symblinks as well.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
Thanks too... :)
--Raghav
On Thu, Jun 28, 2012 at 4:52 PM, Ben Carbery ben.carb...@gmail.com wrote:
Too easy, thanks.
On 28 June 2012 18:38, Raghavendra raghavendra@enterprisedb.com
wrote:
On Thu, Jun 28, 2012 at 1:20 PM, Ben Carbery ben.carb...@gmail.com
wrote:
I am building
value of Master time).
Here you get the time how much slave is behind from master.
Note: Special attention required on Timezones.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
2012-06-25 02:22:36 GMT FATAL: the database system is starting up
** **
**
Can you also paste whats there in shared_preload_libraries setting from
$PGDATA/postgresql.conf ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Mon, Jun 25, 2012 at 10:10 AM, Anibal David Acosta a...@devshock.comwrote:
Yes, we must upgrade.
The value of the shared_preload_libraries is
** **
shared_preload_libraries =
'$libdir/plugins/plugin_debugger.dll' #
(change requires restart)
Also try:
https://bitbucket.org/adunstan/json_91
--Raghav
On Sun, Jun 24, 2012 at 3:45 AM, Joe Van Dyk j...@tanga.com wrote:
On Sat, Jun 23, 2012 at 3:03 PM, Joe Van Dyk j...@tanga.com wrote:
How can I use row_to_json for a subset of columns in a row? (without
creating a new view or
for
Postgres User.
Second, you need to give directory name as below.
log_directory = 'C:\\postgresql\\logs\\a_pg_cluster'
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
+ tablename
Second with pg_class.
postgres=# select relname,reloptions from pg_class where relname='foo';
relname | reloptions
-+
foo | {autovacuum_enabled=false}
(1 row)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http
SELECT pg_terminate_backend(procpid)
FROM pg_stat_activity
WHERE datname = 'dropme';
ERROR: must be superuser to signal other server processes
You can try this approach.
http://archives.postgresql.org/pgsql-general/2012-04/msg00100.php
---
Regards,
Raghavendra
EnterpriseDB Corporation
This sounds like one of those what are you trying to achieve questions,
where you need to step back and ask why you're trying to collect that info
and what you want it for.
First, how do you define application? Any client that connects to a
given database? Any client that sets the
in these column.
If am a DBA, how to know exact application or user commits/rollbacks
happened on the database without enabling logs.
Please advice.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
to right probes usage link for Tracing PostgreSQL ?.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Sun, Jun 17, 2012 at 7:54 PM, Magnus Hagander mag...@hagander.netwrote:
Try https://blogs.oracle.com/robertlor/entry/user_level_dtrace_probes_in
Thanks Dickson
Finally, could someone go over the general advice under that section?
It still says that it's bundled with solaris, which I
)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Jun 14, 2012 at 1:47 PM, haman...@t-online.de wrote:
Hi,
I have a column declared as array of text. I can get a single backslash
into one of the array elements by
update ... set mycol[1] = E'blah
On Thu, Jun 14, 2012 at 2:19 PM, Thomas Kellerer spam_ea...@gmx.net wrote:
haman...@t-online.de, 14.06.2012 10:17:
Hi,
I have a column declared as array of text. I can get a single backslash
into one of the array elements by
update ... set mycol[1] = E'blah \\here'
If I try to update the
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
understanding
POSTGRESQL :
CREATE TYPE NUMBER_ARRAY AS (arr int);
Appreciate any help !
Does this helps ?
http://www.postgresql.org/docs/9.1/static/sql-createdomain.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
about synonyms but obviously
they have never been added to the database for some reason or another.
You can also create a updateable VIEW using INSTEAD OF trigger which is a
new feature in PG 9.1.
http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html
---
Regards,
Raghavendra
of killing ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
http://postgres.cz/wiki/Enhanced-psql
Is this also compatible to 9.1 ?
no, this was prepared for 8.4. These features was just experiment and
only smaller subset is in core now.
Oh ok. Thank you for the info.
Multi-Headers, Macros of psql 8.4 were very interesting features,
begin
for tmp_var in (select distinct name from test_table)
loop
raise notice 'Give anything here :) ... !!!';
update test_table set name=tmp_var;
end loop;
end;
$$ language plpgsql;
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http
On Fri, May 4, 2012 at 3:31 PM, Siva Palanisamy siv...@hcl.com wrote:
Hi Raghavendra,
** **
Is it sure that we can copy only the data of Postgresql from one disk to
other seamlessly and then I can reuse the content without any hassle? If
so, tablespace is what I should create first
mean, can I
able to access it? Please help me on this. Thanks!
**
You cannot know the contents in files, unless u are good hacker :)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
number: 201105231
Database system identifier: 5719586032196955957
Database cluster state: in production
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
AFAIK, I dont see any catalog's giving that information.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, Apr 18, 2012 at 7:20 PM, F. BROUARD / SQLpro
sql...@club-internet.fr wrote:
Hi,
is there anyway to have the value of Catalog version number
?
/usr/local/postgresql/pgsql-9.1.3/bin/psql -p 5433 -l
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
---+-++-
adminpack | 1.0 | pg_catalog | administrative functions for PostgreSQL
pgfincore | 1.1.1 | public | examine and manage the os buffer cache
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(3 rows)
---
Regards,
Raghavendra
EnterpriseDB Corporation
code to standard E('\sd')?
Nope. Check out the below link under heading Basic Compatibility Issues
for your reference.
http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.1
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Fri, Apr 13, 2012 at 2
On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula
phoenix.ki...@gmail.comwrote:
On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula
phoenix.ki...@gmail.com wrote:
WARNING: password file /root/.pgpass has group
)
postgres=# select E'Raghav\'s';
?column?
--
Raghav's
(1 row)
or
change the parameter standard_confirming_strings to off; and retry your
example.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql
) but when I try to connect, it tells me
psql: ERROR: No such user: MYSITE_pgbouncer
Where should i create the MYSITE_pgbouncer user?
Add it in pgbouncer.auth file as per your .ini file parameter.
auth_file = /var/lib/pgsql/pgbouncer.txt
---
Regards,
Raghavendra
EnterpriseDB Corporation
pgstatstatements contrib module.
http://www.postgresql.org/docs/9.1/static/pgstatstatements.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/what-happens-when-concurrent-index-create
installed Postgres on a Windows systems.
Sincerely appreciate any help.
set the LD_LIBRARY_PATH environment variable to the PostgreSQL lib location
location and retry.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
Tom Harkaway
--
Sent via pgsql
Need to enable log_line_prefix with timestamp %t.
http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Feb 23, 2012 at 2:15 PM, Madhu S R s_r_ma...@yahoo.co.in wrote:
Hi,
I
You have two options.
- Use contrib module pg_extractor
https://github.com/omniti-labs/pg_extractor
- Use pg_proc catalog to get function definition
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, Feb 15, 2012 at 6:59 PM, Rajan, Pavithra
1 - 100 of 205 matches
Mail list logo