ssLoader.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 Migration Studio tool. Can you please reach
out to EnterpriseDB support or Forum.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
ould not translate host name
> "localhost" 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/
>
|
Is it a typo in pg_stat_replication view column ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
when the pg_stat_replication show
> the slave there,it means 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 a
Thanks
On 27 Jan 2014 22:35, "Bhushan Pathak" 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 started
consuming lar
On Thu, Jan 9, 2014 at 5:04 AM, Tom Lane wrote:
> CS DBA 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 no parameters I only see the first
On Tue, Dec 31, 2013 at 12:20 AM, AI Rumman 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...
http://www.databasesoup.com/2013/10/de-cor
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 c
ation_schema.tables where table_schema='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/
t dirty pages to disk so 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
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://raghavt.blogspot.com/
On Tue, Sep 3, 2013 at 11:36 AM, ascot.m...@gmail.com
wrote:
> 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_Maintenan
ll log every statement equal or greater than the values passed to
it. Now in my logs:
2013-08-13 03:07: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.2
> 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 int
e table foo(val abc[]);
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)"}
On Tue, Jul 30, 2013 at 9:51 AM, saritha N 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 h
Infosys}';
UPDATE 1
postgres=# select * from xdata ;
id | xmlcode
+
1 | Enterprisedb
1 | Wipro
1 | Infosys-Bangalore
(3 rows)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Fri, Jul 19, 2013 at 1:30 PM, John R Pierce 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
gt;
Not certain on the error. Retake the test with above steps you should
succeed.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
> with environment variables as
>
> export PGDATA=/opt/PostgreSQL/pgdata/93b2src
> export PYTHONHOME=/opt/ActivePython-2.
On Mon, Jul 15, 2013 at 7:10 PM, guxiaobo1982 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 Cor
wiki.postgresql.org/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-JD
rant
(1 row)
postgres=# select * from foo where v ~* 'pizza';
v
--
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/
dy been removed
>
> Assuming no part of the system is issuing "set 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/
ostgres=# create language plpython3u;
CREATE LANGUAGE
Out of my analysis on the issue, Asif Naeem from our Dev group shared
his valuable 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/
tto(0, 'grossista', 52187073424, 10,
'1-22-2013', 'ciao ciaociao', 10);
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/
; for help.
postgres=# create language plpython3u;
CREATE LANGUAGE
postgres=#
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
> -- 原始邮件 --
> *发件人:* "Jov";
> *发送时间:* 2013年7月5日(星期五) 上午7:59
> *收件人:* "Mi
ce on (relnamespace=
pg_namespace.oid) where pg_is_other_temp_schema(relnamespace);
On finding you can drop those 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/
raig 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/
t limit 1;
pg_column_size
28
(1 row)
Here 24 bytes as row header and 4 bytes of integer data.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
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
>>
ery and restarting 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
>
>> On Wed, May 22, 2013 at 3:38 P
e recovery process with recovery_target_time parameter.
This parameter helps you to recover wals 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/
p-post please ... :) )
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
blet2 | table | postgres | 8192 bytes |
public | mymappingtablet3 | table | postgres | 8192 bytes |
public | mymappingtablet4 | table | postgres | 8192 bytes |
public | mymappingtablet5 | table | postgres | 8192 bytes |
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
e certification.
>
>
Its a basic exam to test your knowledge and skills on the topics.
All above 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
On Wed, May 15, 2013 at 4:26 PM, Hari Babu wrote:
> >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=p
On Wed, May 15, 2013 at 3:18 PM, Hari Babu wrote:
> 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 some
in advance.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Mon, May 13, 2013 at 11:17 AM, Amit Langote wrote:
> > 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
> > http://www.postgresql.org/docs/9.2/st
here
table_name='table_name';
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, May 8, 2013 at 4:55 PM, Amit Langote wrote:
> 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 f
just lost all of my endeavors to
understand the above scenario.
Any help will be highly appreciated.
Thanks in advance.
---
Regards,
Raghavendra
On Tue, Feb 5, 2013 at 3:47 PM, Thierry Hauchard wrote:
> 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, Windows XP
Hmm...
writer_delay=(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_Resto
p?
>
> Thank you in advance
> 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/
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 wrote:
>
>> 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 p
) from cities ;
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
-
_proc where prosrc ilike '%pg_read_file%' and
pronamespace=(select oid from pg_namespace where nspname='public');
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
1048576)
>
> 2013-01-08 07:42:02 MSTERROR: absolute 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/
> 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
ed. Memory management 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
On Wed, Oct 31, 2012 at 8:52 PM, Alexander Gataric 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
Ent
postgresql.org/docs/9.2/static/runtime-config-logging.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Oct 16, 2012 at 11:01 AM, Sim Zacks 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
> LISTENing
prefer Slony-I (trigger based
replication).
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
s to be done?. 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
Sender: pgsql-general-owner@postgresql.orgDate: Fri, 14 Sep 2012 08:47:54
To:
Subject: [GENERAL] Seeing tables with the same name o
| B | C
-+-++
1 | 10 | 20 | 30
2 | 40 | 50 |
3 | 60 | 70 | 80
4 | 100 ||
(4 rows)
Someone, might have better example. Timely you can work 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$
>
> LAN
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 wrote:
>
>
> On Mon, Jul 16, 2012 at 5:44 PM, Olga Vingurt wrote:
em_indexes=true ? And do
dump & restore. Am not sure on this procedure. 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/
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.
>> Prev
>
> \
> 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 r
Thanks too... :)
--Raghav
On Thu, Jun 28, 2012 at 4:52 PM, Ben Carbery wrote:
> Too easy, thanks.
>
> On 28 June 2012 18:38, Raghavendra
> wrote:
> > On Thu, Jun 28, 2012 at 1:20 PM, Ben Carbery
> wrote:
> >>
> >> I am building a new server with a sep
d will take care of creating symblinks as well.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
i.e., SR box).
4. Now on slave calculate the lag by now() - lagcheck.lagtime(column which
has 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/
On Mon, Jun 25, 2012 at 10:10 AM, Anibal David Acosta wrote:
> Yes, we must upgrade.
>
> The value of the shared_preload_libraries is
>
> ** **
>
> shared_preload_libraries =
> '$libdir/plugins/plugin_debugger.dll' #
> (change requires restart)
>
> **
>
F
borting startup due to startup process
> failure
>
> 2012-06-25 02:22:36 GMT FATAL: the database system is starting up
>
> 2012-06-25 02:22:36 GMT LOG: loaded library
> "$libdir/plugins/plugin_debugger.dll"
>
> 2012-06-25 02:22:36 GMT FATAL: the dat
Also try:
https://bitbucket.org/adunstan/json_91
--Raghav
On Sun, Jun 24, 2012 at 3:45 AM, Joe Van Dyk wrote:
> On Sat, Jun 23, 2012 at 3:03 PM, Joe Van Dyk wrote:
> > How can I use row_to_json for a subset of columns in a row? (without
> > creating a new view or using a CTE?)
> >
> > What I
_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
> log_rotation_size = 10MB
> log_min_messages = PANIC
> log_error_verbosity = VERBOSE
>
> except, it doesn't work... and I'm not sure about the levels "PANIC" and
> "VERBOSE".
>
> Can you help?
>
> Here two thing's, One you should have full access on the directory 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/
>
>
> 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
n the docs.
>
>
One way is with
\d+
Second with pg_class.
postgres=# select relname,reloptions from pg_class where relname='foo';
relname | reloptions
-+
foo | {autovacuum_enabled=false}
(1 row)
---
Regards,
Ragha
> 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 a
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/
On Sun, Jun 17, 2012 at 7:54 PM, Magnus Hagander wrote:
>
> > 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 doubt is true?
e point me to right probes usage link for Tracing PostgreSQL ?.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
> http://www.postgresql.org/docs/current/static/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS
>
> Regards,
> Dean
>
Thanks
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Jun 14, 2012 at 2:19 PM, Thomas Kellerer 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 whole
;meet\\ing"}
{"meet\\ing"}
(2 rows)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Jun 14, 2012 at 1:47 PM, wrote:
> Hi,
>
> I have a column declared as array of text. I can get a single backslash
> into one of the array e
in postgresql
>
>
> My 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/
some conversations 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-createtr
_stat_replication".
Will it be helpful here sending SIGINT instead of killing ?
---
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 fe
so compatible to 9.1 ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
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
On Fri, May 4, 2012 at 3:31 PM, Siva Palanisamy 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
t;
> Also, can I able to see the contents by opening its files? I 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/
g/pgsql/pgsql-9.1.3/access.log start
>
> The lock files are in place:
> /tmp/.s.PGSQL.5432
> /tmp/.s.PGSQL.5432.lock
> /tmp/.s.PGSQL.5433
> /tmp/.s.PGSQL.5433.lock
>
>
>
Whats the output of this command ?
/usr/local/postgresql/pgsql-9.1.3/bin/psql -p 5433 -l
---
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 valu
./pg_controldata
pg_control version number:903
Catalog version number: 201105231
Database system identifier: 5719586032196955957
Database cluster state: in production
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
ions
Name| Version | Schema | Description
---+-++-
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
ode 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.blogsp
on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.6
20110731 (Red Hat 4.4.6-3), 64-bit
(1 row)
postgres=# select E'Raghav\'s';
?column?
--
Raghav's
(1 row)
or
change the parameter standard_confirming_strings to off; and retry your
example.
---
Regards,
Raghave
>
> On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula
> wrote:
>
>> On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe
>> wrote:
>> > On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula <
>> phoenix.ki...@gmail.com> wrote:
>> >>
>> >> WARNING: password file "/root/.pgpass" has group or world access;
>> >
ything. Pgbouncer starts
> (service pgbouncer restart) 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 .in
separate file I need to download?
>
> I am fairy new to both Linux and Postgres, however I have successfully
> installed Postgres on a Windows systems.
>
> Sincerely appreciate any help.
>
>
set the LD_LIBRARY_PATH environment variable to the PostgreSQL lib location
location a
n oracle. You
can try 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.nabbl
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 wrote:
> Hi,
>
> I
One more thing you can also get it from pg_get_functiondef() system
function.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, Feb 15, 2012 at 9:32 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> You have two options.
>
1 - 100 of 205 matches
Mail list logo