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/
Hi Adarsh,
There are very good tools out for migration from Mysql to PostgreSQL.
EnterpriseDB has the migration studio which will help to migrate Mysql to
PostgreSQL.
http://www.enterprisedb.com/solutions/mysql-vs-postgresql/how-to-move-from-mysql-to-postgresql
Best Regards,
Raghavendra
Hi Kenneth,
You can retrieve the sequence information from the pg_catalog
"pg_statio_all_sequences"
or
select * from pg_class where relkind='S'
Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Postgres Company
On Fri, Mar 4, 2011 at 7:32 PM, Kenneth Buckler
Thank you.
Please do add 'pgsql-general@postgresql.org' while replying.
Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Postgres Company
On Fri, Mar 4, 2011 at 8:04 PM, Kenneth Buckler
wrote:
> Perfect! Thanks a bunch!
>
> Ken
>
> On Fri, Mar 4, 201
Hi Mike,
I tried this, which will get the list of tables belong to 'XYZ' tablespace.
select relname from pg_class where reltablespace=(select oid from
pg_tablespace where spcname='xyz');
Hope this helps
Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Post
Try out this...
alter table add primary key(column name);
Best Regards,
Raghavendra
EnterpriseDB Corporation
On Fri, Apr 1, 2011 at 9:09 PM, Rich Shepard wrote:
> In -9.0.3 I used ALTER TABLE to replace a varchar() column with a bigint
> column so it can be assigned as the table
'vacc' AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid =
t.oid;
Note: This query for a particular Table 'VACC'
Best Regards,
Raghavendra
EnterpriseDB Corporation
On Fri, Apr 1, 2011 at 8:54 PM, Durumdara wrote:
> Hi!
>
> I want to migrate some database t
;
AFAIK, you can pull that information from 'indexdef' column of pg_indexes.
select * from pg_indexes where tablename='a';
Best Regards,
Raghavendra
EnterpriseDB Corporation
> Thanks:
> dd
>
>
>
>
> 2011.04.01. 18:01 keltezéssel, Raghavendra írta:
>
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/
>
> 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
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/
_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/
) 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
-
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
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/
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
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...
just lost all of my endeavors 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 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
here
table_name='table_name';
---
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
in advance.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
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
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
> postgres=# select version();
> version
>
>
> ---
> PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
> 20080704
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/
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/
p-post please ... :) )
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
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/
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
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
>>
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/
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/
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/
; 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
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/
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/
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/
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/
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
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
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 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
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 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
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 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
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 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
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/
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
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/
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
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 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
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
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
|
Is it a typo in pg_stat_replication view column ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
>
>
> I've seen it, but catalog hacks always make me nervous. Anybody else have
> good / bad experience to share?
>
> --scott
>
>
It is observed, double the space required for this utility.
Eg:-
If the database is 4 gig, there should be 8gigs space.
Best Rega
command of the base
table(which will undergo for partition).
2. Create the partition setup with TRIGGER's
3. Use COPY FROM command for inserting data into partition table.
This approach will fasten the inserts. Increasing the memory will also help.
Note: RULE based approach wont work with C
her than INSERT. Firstly, setup the
partition/child tables with relevant triggers and calling function on it.
Use COPY FROM command pointing to parent table by calling the .csv
file(created on MASSIVE table). Triggers will push the data to the
respective child tables. Faster and efficient
unning on 5432
port) then by default there will be three
databases(postgres,template0,template1), for new you can use CREATE DATABASE
command.
If you want another cluster, you can use INITDB as said by Thomas
Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise P
>
> \i C:\psql\loaddata.sql
>
>
> But it says " C:: Permission denied"
>
>
Give the permission to postgres user on 'loaddata.sql' file. Right click and
in properties give full access to postgres user.
Best Regards,
Raghavendra
EnterpriseDB Corporat
ars now, to reach a wider audience. Seems they don't like me... :(
>
Seems they missed one valid presentation :)
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
Best to start with..
http://bucardo.org/wiki/Bucardo/Installation
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, May 3, 2011 at 5:34 PM, tushar nehete wrote:
> Thanks you all,
> I started with Bucardo. I installed activeperl 5.12 on my
One more point, Please take into consideration the points mentioned by Simon
Riggs in your testing.
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, May 3, 2011 at 5:41 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> Best to s
gt; the
> > cluster.
> > In Oracle, we can flush the SGA, can we get the same feature here..
> > Thanks in Advance.
>
>
> The CHECKPOINT command will do this for you.
>
This command will empty the PSM...
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
Now try connecting to Server with psql...
---
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, May 19, 2011 at 4:39 PM, Adarsh Sharma wrote:
> Dear all,
>
> Today I need to use crosstab function but Postgresql says that there is no
&
Small change replace all PG path with PPSS paths...
---
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, May 19, 2011 at 4:46 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> Hi Adarsh,
>
> This isssue has fixed in PPSS
ce in(select
oid from pg_tablespace where spcname not in ('pg_default','pg_global'));
---
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Mon, Jun 20, 2011 at 11:40 PM, hyelluas wrote:
> thank you Greg,
>
> here is what I
let me correct on this query, it shows only those tables which wont belong
to default_tablespace...
select relname,reltablespace from pg_class where reltablespace
in(select oid from pg_tablespace where spcname not in
('pg_default','pg_global'));
---
Best Regards,
Ragh
hmmmStrange..
What is the output of
select oid,* from pg_tablespace;
and
select relname,reltablespace from pg_class where relname='
application_category';
---
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Jun 21, 2011 a
hasrules | hastrigge
> rs
>
> +--++++--+--
> ---
> public | application_category | postgres || t |
> f| f
> (1 row)
Whats the output of this..
select relname,reltablespace from pg_class where relname='
application_category';
---
Best
Can you give a try updating the catalogs with ANALYZE command and re-check ?
---
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Jun 21, 2011 at 2:22 AM, hyelluas wrote:
> profiler1=# select relname,reltablespace from pg_class where
> r
Actually to say, everything looks ok to me, until unless you say the table *
'**application_category'* on other tablespace ... :)
profiler1=# select relname,reltablespace from pg_class where
>> relname='application_category';
>> relname| reltablespace
>> --+-
lanner?
>
> Thanks
>
>
You are right, depends on the optimizer and query to which index to choose.
EXPLAIN command on the query will give you the optimizer path.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
know that Streaming replication done without this parameter,
could you share the output of the below command in the PRIMARY cluster.
show archive_mode
show archive_command
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
Nope, you need to be in latest version as Andreas said.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Aug 11, 2011 at 4:51 PM, Siva Palanisamy wrote:
> Hi Andreas,
>
> FYI, I am using PostgreSQL 8.1.4.
>
> Thanks and
> SQL state: 42601
>
> Please correct me where I am going wrong. FYI, I am running under the
> administrator accounts of both Windows Login and PostgreSQL.
>
>
Two things,
1. you need to have a proper permissions where the .csv file creating.
2. In windows you need to us
>
>
> You are not using psql. "\copy" is a psql command. I don't think it's
> supported by PgAdmin III, though I could be wrong.
>
>
Right, '\copy' is not supported in PgAdmin III.
--Raghav
on:
Is it a best practice to keep cluster in Archive_mode = on and setup
streaming replication or just leave archive_mode=off?
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Aug 23, 2011 at 10:49 PM, Ray Stell wrote:
> On Tue, Aug 23, 2011 at 08:30:55PM +0530, Raghavendra wrote:
> >
> > Is it a best practice to keep cluster in Archive_mode = on and setup
> > streaming replication or just leave archive_mode=off?
>
> Depends. The re
Now am able to access it. But for sometime I was not able to access it.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Fri, Sep 2, 2011 at 3:34 AM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> Hi All,
>
> Am unable to acces
ache:http://pgfoundry.org/> of
pgfoundry.org
- Search on Google:
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
Hopefully It should be back after sometime :)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Sep 6, 2011 at 3:17 AM, Tomas Vondra wrote:
> On 2 Září 2011, 7:36, Magnus Hagander wrote:
> > Yeah, all hub.org hosted services had a ra
get a Transaction ID, but not the transaction timestamp when it
performed.
Kindly advice me.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
transaction timestamp.
--Raghav
On Sat, Sep 17, 2011 at 7:41 AM, Marti Raudsepp wrote:
> On Fri, Sep 16, 2011 at 21:39, Raghavendra
> wrote:
> > We can get a Transaction ID, but not the transaction timestamp when it
> > performed.
>
> Short answer: You can't. Instead, a
Respected All,
In which case $PGDATA/base/database-oid/PG_VERSION file updates ?
I have observed, PG_VERSION file is created at DB creation time and will
never get
updated. I mean file PG_VERSION TIMESTAMP.
Thanks in advance.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http
file never changes. Because its the file
tells on which version of Binary the Data directory is built upon.
So, my question is, Is there any case, where PG_VERSION file updates with
any of the utility process or
PG_VERSION file never been touched by PG-Instance ?
---
Regards,
Raghavendra
Enterpr
>
> From what I can see, PG_VERSION is written at database creation to document
> the
> major version of the Postgres instance used to create the database. Since
> it
> only holds the major version string (i.e. 9.0) it is not touched during
> minor
> updates, for example 9.0.0 --> 9.0.1. Grepping
To know the page and row information :
Select ctid,* from ;
For more information at page-level, you can take the help of contrib module
"pageinspect". Which is under
pgsql-path/share/postgresql/contrib/pageinspect.sql
---
Regards,
Raghavendra
EnterpriseDB Corporation
Hi Adarsh,
Filip workaround is right approach, since its plain text format you need to
play with SED/AWK to pull those two tables.
Following link will help you:-
http://blog.endpoint.com/2010/04/restoring-individual-table-data-from.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog
es-plus-advanced-server
Migration Studio which comes in separate bundle.
http://www.enterprisedb.com/downloads/add-on-components-bundles
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
Dear Yogesh,
To get best answer's from community member's you need to provide complete
information like,PG version, Server /Hardware info etc., So that it help's
member's to assist you in right way.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
---
>
> > We need following information
> >
> > 1. Is there any configuration we do that would pool the connection
> request rather than coming out with connection limit exceed.
>
> Use pgpool or pgbouncer.
>
>
Use pgbouncer, which is a light weighted connection pooling tool, if you are
not optin
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
so compatible to 9.1 ?
---
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
_stat_replication".
Will it be helpful here sending SIGINT instead of killing ?
---
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
1 - 100 of 205 matches
Mail list logo
