Hi all -
I am seeing lot of these records in the log file. Not able to
find why I get this in log file. Is there a way to find out info about this
? Thanks for your help
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on clie
Hi all -
I would like to know if there is any other way of moving
objects from one schema to other schema? right now the way I am doing it is
, take the backup and importing whatever the database objects I wanted to
move, I am doing that using pg_restore. But I am finding it difficul
Thanks a lot.
Regards
On Thu, Oct 28, 2010 at 12:23 PM, Pavel Stehule wrote:
> 2010/10/28 akp geek :
> > Hi all -
> > I would like to know if there is any other way of moving
> > objects from one schema to other schema? right now the way I am doing it
>
Hi All -
I need to update one table with the data from multiple
tables.
1. I have created a trigger on a table table
2. Create a view with all the logic
3. created a trigger funtion.
with in the function, I have tried to populate the tabl
Hi All -
Can you please share your thoughts and help me ?
1. I have 4 ( T1, T2 , T3, T4 ) tables where I have the data from
a transactional system
2. I have created one more table D1 to denormalize the data from
the 4 tables ( T1, T2 , T3, T4 )
3. I have
_ts, usr.firstname, usr.lastname, itm.phone, itm.fax,
com.usercomments,
itm.lastupdatedate AS last_update_timestamp, btrim(
FROM t_items itm, t_comments com, t_user usr
WHERE itm.transactionid = com.transactionid AND itm.userid = usr.userid ;
--
On Mon, Nov 8,
Hi all -
I am trying to create an index on character varying field. The
column is just character varying with no limit. I am getting the following
error " index row requires 10040 bytes, maximum size is 8191"
What can I do the postgres.conf to handle this error? Appreciate your help
Thanks for all your valuable thoughts . It took me a while to read all your
suggestions , still trying to understand it fully.
What we do with the text that I have mentioned is, we have
search functionality on the text. The user enters some keywords and then the
application should be able to searc
Dear all -
I am having trouble with replace function inside a function.
If I do the same replace function outside it works fine, Following example
clearly explains my problem. Can you please help?
create table str_table
( mystr varchar(1000));
insert into str_table values ( 'Thi
'plpgsql' VOLATILE
COST 100;
ALTER FUNCTION test_repl(character varying) OWNER TO postgres;
On Tue, Nov 23, 2010 at 3:07 PM, Pavel Stehule wrote:
> Hello
>
> please, can you send a source code of your function?
>
> Regards
>
> Pavel Stehule
>
&g
Hi -
This is related to my earlier post. For the function I am passing
a string. But the string some time has a single quote inside the string like
"IT's a String Test" , How can I handle that, can you please help?
CREATE OR REPLACE FUNCTION test_repl(x character varying)
RETURNS c
,a.code,a.codeword);
> RAISE NOTICE 'ret_var after replace: %', ret_var;
> end loop;
> return ret_var;
>
> you can ensure using just buildin "replace" function - use
>
> ret_var := pg_catalog.replace(...)
>
> Regards
>
> Pavel Stehule
> maybe it c
Hi All -
Did any one of you build Postgres 9 and postgis package on
solaris 10? I am planning to do one. Any suggestions?
Regards
Thanks for sharing the info. I will post my experiences
Regards
On Wed, Nov 24, 2010 at 10:59 AM, Sebastian Jaenicke <
sjaen...@cebitec.uni-bielefeld.de> wrote:
> On Wed, Nov 24, 2010 at 10:47:18AM -0500, akp geek wrote:
> [..]
> > Did any one of you build Post
One more question. What version of perl do you have? and do we have to
install perl at all or we can use the one that comes with OS?
Regards
On Wed, Nov 24, 2010 at 11:14 AM, akp geek wrote:
> Thanks for sharing the info. I will post my experiences
>
> Regards
>
>
> On Wed,
Hi All -
I created a schema , I used pg_restore with postgres as user
and restored every thing to the new schema I created. Now I want to change
the owner ship of the schema and all its objects to a different user other
than postgres. Is it possible to do that with one command?
Th
Thanks for the help. it worked
On Wed, Dec 1, 2010 at 11:10 AM, Gary Chambers wrote:
> akp geek,
>
> > I created a schema , I used pg_restore with postgres as user and restored
> every thing to the new schema I
> > created. Now I want to change the owner ship of t
Hi all -
I have added a column to a table is which of datatype text. I am
trying to create an index
CREATE OR REPLACE FUNCTION reverse(varchar) RETURNS varchar AS $$
$reversed = reverse $_[0];
return $reversed;
$$ LANGUAGE plperlu IMMUTABLE;
CREATE INDEX rev_email ON users( (rev
Hi All -
I am trying to install postgis 1.5.2 on solaris10. When I run
the configure I get the following.
*configure: WARNING: could not locate CUnit required for
liblwgeom unit tests*
is there some setting I need to do to make it work?
$./configure --prefix=/opt/postgr
installation was successful. But it did not install the liblwgeom.so
Regards
On Mon, Feb 7, 2011 at 12:29 PM, Paul Ramsey wrote:
> It's just a warning, continue happily onwards. Just means a few unit tests
> won't be run.
>
> P.
>
>
> On 2011-02-07, at 9:27
pgrade for upgrading
Regards
On Mon, Feb 7, 2011 at 12:39 PM, Paul Ramsey wrote:
> It's not a dynlib, it's statically linked at build time, so have no fear.
> Stop thinking so much :)
> P
>
> On 2011-02-07, at 9:38 AM, akp geek wrote:
>
> installation was successful
Hi all -
I ran query this morning, I got a wrong results. I have run the same
query in an other environment with same data and I got the result set I was
expecting.
After that I did a re index and on the table I was getting incorrect
results, the data then came out fine,
D
thanks.. the index I was having is gist on a to_tsvector column . version we
have is 8.3
On Mon, Feb 7, 2011 at 7:23 PM, Alex Hunsaker wrote:
> On Mon, Feb 7, 2011 at 17:12, akp geek wrote:
> > Hi all -
> > I ran query this morning, I got a wrong results. I have
Hi all -
I am trying to write a query to find all the column names in
database that has a underscore in it (_) example souce_id. I know like will
not work , if where column_name like '%_%' Can you please help?
Regards
thanks . It worked
Regards
On Thu, Feb 17, 2011 at 2:05 PM, Radosław Smogura
wrote:
> akp geek Thursday 17 February 2011 19:55:46
> > Hi all -
> >
> > I am trying to write a query to find all the column names in
> > database that has a underscore in it (
that's right. Thanks again all for the help
On Thu, Feb 17, 2011 at 2:09 PM, David Kerr wrote:
> On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
> - Hi all -
> -
> - I am trying to write a query to find all the column names in
> - database that ha
Hi all -
I am trying to find the number of elements in the array. Right
now I am using array_upper and array_lower. Is there any other way of
getting the number of elements?
thanks for the help
Regards
Hi all -
I have recently upgraded from 8.3 to 9.0.2.
when I run the following sql in 9.0.2 "select to_timestamp('02/26/2011
14:50', 'MM/DD/ HH24MI') " I am getting the following error and
the sql runs fine in older version
Is it my installation issue or library missing?
ERROR: i
Unfortunately the our database is still 8.3. that's a limitation for using
array_length
Regards
On Thu, Feb 24, 2011 at 4:08 PM, Dmitriy Igrishin wrote:
> Hey,
>
> 2011/2/24 akp geek
>
> Hi all -
>>
>> I am trying to find the number of elements
Thank you all for the suggestion and it's very clear to me now
Regards
On Fri, Feb 25, 2011 at 10:02 AM, Bruce Momjian wrote:
> Adrian Klaver wrote:
> > test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI');
> > to_timestamp
> >
> > 2011-02-26 14:
Hi all -
wanted to check, if it is possible to recover the database,
if it is deleted using the pgAdmin. I know it is not possible. Just
wondering . We don't have back either :(
Regards
Hi all -
I have 2 tables A,B . Can I write a select statement as follows. My query
is running slow ( 7000 ms). I have created gin index on text_col and also
transactionid is PK on both tables. thanks for your help
B has a transactionid and tsvector columns
A has trasactionid and other columns
I am getting the following error when I try to restore it from a dump. Any
suggestions?
Regards
Hi All -
I am getting the following error message when I was doing the vacuum
ERROR: Failed with error 22007-invalid value "" for "mm"
I am not able to interpret the error. Can you please help?
Thank you
hi all -
I am trying to install the pgagent on solaris. when I do the
ccmake /opt/postgres/apps/pgAgent-3.0.1-Source, I am getting the following
error.
CMake Error at cmake/FindWX.cmake:271 (MESSAGE):
The selected wxWidgets configuration (version: 2.6, debug: no, static:
yes,
thank you for the clues. I am downloading the package and will install and
update you
Regards
On Fri, Mar 18, 2011 at 4:45 PM, Adrian Klaver wrote:
> On Friday, March 18, 2011 12:36:07 pm akp geek wrote:
> > hi all -
> >
> > I am trying to install the pgagent on s
Hi all -
Is it possible to to split the data of a column into
multiple lines. We are have a column which is text. when the query is
excecuted, I wanted to display the text of the column in separate lines. Is
it possible ?
thanks for the help
Thanks a lot , will try this one
Regards
On Tue, Apr 12, 2011 at 1:59 PM, Andreas Kretschmer <
akretsch...@spamfence.net> wrote:
> akp geek wrote:
>
> > Hi all -
> >
> > Is it possible to to split the data of a column into
> multiple
> &g
Hi all -
Recently made change on our primary database
default_text_search_config = 'pg_catalog.simple' . After that
the replication is stopped. Can you please help me ? how to fix the issue.
I am sure I made the change on the slave also.
How can I start the replicati
ere any scripts to monitor the status of
the replciation. so that I can be little proactive
Regards
On Thu, Mar 7, 2013 at 9:25 PM, Scott Marlowe wrote:
> On Thu, Mar 7, 2013 at 5:28 PM, akp geek wrote:
> > Hi all -
> >
> >
wal receiver process streaming"
>
> These have worked very reliably for many months.
>
> -John
>
>
> On Fri, Mar 8, 2013 at 11:53 AM, akp geek wrote:
>
>> I got it fixed.
>>
>> What I did was
>>
>> $ psql -c "SELECT pg_start_backu
the data directory on to the slave
3. stopped the base backup on master
4. started the db on slave
Appreciate your help.
Regards
On Sat, Mar 9, 2013 at 12:52 AM, akp geek wrote:
> Thanks a lot. I started the replication. It became very slow. It is taking
> long time to sync the master
Hi all -
I am in desperate need of your help. The replication/streaming
stopped working on March5th. I followed the following procedure to restart
the streaming. After running it for couple of hours , the database is
crashing on the slave. This is on our production server. Thanks for yo
shows what is really transpiring?
>
> On Sat, Mar 9, 2013 at 6:51 AM, akp geek wrote:
> > Hi all -
> >
> > I am in desperate need of your help. The replication/streaming
> > stopped working on March5th. I followed the following procedure to
> restart
> &g
r 9, 2013 at 1:51 PM, akp geek wrote:
> > thank you. As you mentioned, I understood that I am starting the
> streaming
> > scratch which is not what I wanted to do.
> >
> > Here is what I am planning to .
> >
> > Our replication process was down since March5th
case 03/05 ) . This is where I got confused.
Again thanks a lot. Now we will definitely upgrade
Regards
On Sat, Mar 9, 2013 at 7:11 PM, Lonni J Friedman wrote:
> On Sat, Mar 9, 2013 at 4:05 PM, akp geek wrote:
> > Appreciate your findings. taking your points and doing things now.
Hi All -
I have created a dump of a big table into 5 split files. What is the
procedure to restore them using pg_dump.
I am getting the following error
pg_restore: [custom archiver] could not read from input file: end of file
pg_restore: *** aborted because of error
Appreciate your help.
[mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *akp geek
> *Sent:* Monday, April 22, 2013 3:36 PM
> *To:* pgsql-general
> *Subject:* [GENERAL] pg_restore from split files
>
> ** **
>
> Hi All -
>
> ** **
>
> I have created a dump of a bi
It works ... " combine them again. " Thank you all
Regards
On Mon, Apr 22, 2013 at 3:57 PM, Steven Schlansker wrote:
>
> On Apr 22, 2013, at 12:47 PM, akp geek wrote:
>
> > pg_dump dbname -n schemaname -t table_name -Fc | split -b 500m -t
> table.dump
>
>
Hi All -
We have been running postgres 9.0.2 since October. Streaming also
in place. Working flawless. yesterday suddenly the replication stopped.
When I look at the log file. This is what I have for the last 2 lines and
that's it. I don't see any discrepancies. Can you please help ? T
Hi all -
Currently we have set up one master one slave , which working
fine. Now we need to replicate to an other slave. The problem we have ,
the port that we use on primary can not be reached from the new slave. We
can't the change the primary port also, because many applications usi
it is a firewall issue. they can't open the port that we requested it.
so as you mentioned tunnel to the primary via tunnel. will give that a try
regards
On Mon, Sep 30, 2013 at 11:10 PM, Chris Travers wrote:
>
>
>
> On Mon, Sep 30, 2013 at 7:14 PM, akp geek w
the
files from master ( HOT STAND BY ).. master has trusted connection(ssh )
with slave.
Thanks a lot for the help.
On Tue, Oct 1, 2013 at 10:14 AM, akp geek wrote:
> it is a firewall issue. they can't open the port that we requested it.
>
> so as you mentioned tunnel to t
-line: line 0: Bad configuration option: ExitOnForwardFailure
command-line: line 0: Bad configuration option: ExitOnForwardFailure
Regards
On Tue, Oct 1, 2013 at 6:46 PM, Sergey Konoplev wrote:
> On Tue, Oct 1, 2013 at 2:03 PM, akp geek wrote:
> > One more thing.. pardon me for b
Thanks for all suggestions. based on the constraints I had with network, I
could able to set up the warm stand by. I am seeing the following log file
I don't know to how to handle.
2013-10-03 17:52:00 GMT [27636]: [457-1] user=,db=LOG: restored log file
"000101F60003" from archive
sc
We have 4 applications ( 2 transactional , 2 ( transactional + reporting ))
on postgres 32 bit 9.0.4
Some of the queries are extreemly taking time ( 10 seconds). I can the
explain for that also.
I just want to get your thoughts on the conf file values we have are good.
Really appreciate your help
t
On Fri, Oct 11, 2013 at 7:03 PM, Sergey Konoplev wrote:
> On Fri, Oct 11, 2013 at 10:08 AM, akp geek wrote:
> > We have 4 applications ( 2 transactional , 2 ( transactional + reporting
> ))
> > on postgres 32 bit 9.0.4
> >
> > Some of the queries are extree
, 63G total swap, 63G free swap
Regards
On Sat, Oct 12, 2013 at 7:43 AM, Michael Paquier
wrote:
> On Sat, Oct 12, 2013 at 12:56 AM, akp geek wrote:
> > We have been running 4 of our applications on 9.0.4, which we are
> planning
> > to update the database 9.2.2 by the yea
wrote:
> On 10/13/2013 1:45 PM, Sergey Konoplev wrote:
>
>> On Sun, Oct 13, 2013 at 8:35 AM, akp geek wrote:
>>
>>> >thanks for the advice. One question I have is if I increase the
>>> >shared_buffers to 16GB, then it won't restart because for the
thanks for the advice..
Regards
On Sun, Oct 13, 2013 at 6:10 PM, Sergey Konoplev wrote:
> On Sun, Oct 13, 2013 at 2:40 PM, akp geek wrote:
> > thank you all. We will upgrade to 64bit postgres 9.2.5 and take all your
> > suggestions for that. Mean while will run the pg_reorg
Dear all -
I would like to know if any one has migrated database from MS
access to Postgres . We use postgres 9.0.2 on solaris . Are there any open
source tools that you have used to do this task. Can you please share your
experiences ?
Regards
It's 10 tables. that's all. No reports. I will follow your suggestion.
Thanks for the help
On Wed, May 25, 2011 at 4:25 PM, John R Pierce wrote:
> On 05/25/11 12:42 PM, akp geek wrote:
>
>> Dear all -
>>
>>I would like to know if any one has migr
were mentioning. I
would love to use that to make the data transfer faster
Regards
On Thu, Jun 2, 2011 at 9:32 AM, Thomas Harold wrote:
> On 5/25/2011 3:42 PM, akp geek wrote:
>
>> Dear all -
>>
>> I would like to know if any one has migrated database from
The only problem I am seeing with dates as you mentioned. when I export the
data to csv the date is getting the format of 8/1/1955 0:00:00 , but
postgres not accepting that. Any clues?
Regards
On Thu, Jun 2, 2011 at 11:23 AM, Vick Khera wrote:
> On Thu, Jun 2, 2011 at 10:01 AM, akp geek wr
Hi all -
After making the required changes to the Primary and slave , I have
restarted the slave and I keep seeing the following in the logs.
Operating system is solaris.
on the primary . postgresql.conf has the following changes
listen_addresses = '*'
Both the servers are having 9.0.2
Thanks
On Fri, Jun 10, 2011 at 4:09 PM, Guillaume Lelarge
wrote:
> On Fri, 2011-06-10 at 15:46 -0400, akp geek wrote:
> > Hi all -
> >
> >
> > After making the required changes to the Primary and slave ,
> > I have rest
fw/lib/libcrypto_extra.so.0.9.7*
*libm.so.2 => /lib/libm.so.2*
*/platform/SUNW,SPARC-Enterprise/lib/libc_psr.so.1*
Appreciate your help
Regards
On Sat, Jun 11, 2011 at 12:25 PM, Tom Lane wrote:
> akp geek writes:
> > After making the required changes to the
Dear all -
While setting up streaming I ran into issue with libpq. To
resolve it I need to recompile the source. I am issuing the following
command . I tried this before with 9.0.2 it worked. Now when issued the same
command I was getting the errors.
./configure --prefix=/opt/post
Sorry all -
I am doing the work on Solaris.
Regards
On Mon, Jun 13, 2011 at 5:38 PM, Scott Marlowe wrote:
> On Mon, Jun 13, 2011 at 3:15 PM, akp geek wrote:
> > Dear all -
> >While setting up streaming I ran into issue with libpq. To
> >
pt/postgres/software/include/readline:/opt/postgres/software/flex/bin:/opt/postgres/libxml2/include/libxml2/libxml:/usr/sfw/bin:/usr/local/bin
On Mon, Jun 13, 2011 at 7:32 PM, Craig Ringer
wrote:
> On 06/14/2011 05:15 AM, akp geek wrote:
>
>> Dear all -
>>
>>
-openssl --with-readline --with-ossp-uuid
--with-includes=/opt/postgres/software/include
LDFLAGS=-L/opt/postgres/software/lib
every thing went well from there , gmake and gmake install
Regards
On Tue, Jun 14, 2011 at 9:48 AM, Adrian Klaver wrote:
> On Tuesday, June 14, 2011 5:51:59 am akp g
Hi all -
Are there any open source tools available for migrating from
oracle to postgres. We have 20 tables in oracles that we needed to get to
postgres. Appreciate your help
Regards
Craig Ringer
>
> Subject: Re: [GENERAL] Oracle to Postgres migration open source tool
> To: "akp geek"
> Cc: "pgsql-general"
> Date: Thursday, July 7, 2011, 2:02 PM
>
> On 7/07/2011 9:55 PM, akp geek wrote:
> > Hi all -
> >
> >
Hi all -
We are using 9.0.4 on solaris. We set up the streaming. it is
running fine. The files keep accumulating in archive directory. Do we need
to keep all the files or is there a limit that , how many days worth of
files we need to keep. We do take hot back up of the primary once
Hi all -
I am trying to run the psql command the following way and
it's failing . Can you please help?
psql -d mydb -c 'update tb_user set accountstatus='A'
where userid=123'
*ERROR: column "a" does not exist*
*LINE 1: ...date tb_user accountstatus=A*
*
*
Thank
Thanks a lot .. Got it
On Wed, Sep 21, 2011 at 11:01 AM, patrick keshishian wrote:
> On Wed, Sep 21, 2011 at 7:54 AM, akp geek wrote:
> > Hi all -
> >I am trying to run the psql command the following way and
> > it's failing . Can you please help?
&g
Hi all -
We have postgres 9.0.4 since an year. Replication also set up and
works fine. On the master. The wal files are growing and it's almost gone
to 90% of the disk. How can I handle the situation. Can I delete the old
files. Please advice
Regards
Thanks for the help
WAL archives is growing, not the files in pg_xlog.
Regards
On Wed, Dec 5, 2012 at 3:38 PM, Albe Laurenz wrote:
> akp geek wrote:
> > We have postgres 9.0.4 since an year. Replication also set up and works
> fine.
> > On the master. The wal files are growing and it'
thank you all. There is a mistake I did then. I created a base backup when
I started the DB , that was exactly an year ago. I need to do that again
and then delete the old files.
Regards
On Wed, Dec 5, 2012 at 4:25 PM, Tom Lane wrote:
> akp geek writes:
> > WAL archives is growing
thank you so much for all the inputs.. One final question is , Do we have
to stop the database when we create the base backup?
Regards
On Wed, Dec 5, 2012 at 4:45 PM, Tom Lane wrote:
> akp geek writes:
> > thank you all. There is a mistake I did then. I created a base backup
>
Hi all -
We are using to_tsquery and to_tsvector quite a bit. I have
noticed that it is not searching for "Y". is there some settings I have
to do make sure when search for string that has "Y" to return the correct
results?
Thanks for the help
Regards
Hi all -
Can you please suggest the way to handle the code migration
between environments. We have SVN. Can we first check in and then check out
to different environments? Or we can take back up and restore that function
or database object to other environment? Appreciate your suggest
Hi All -
I have been trying to drop 2000 tables using a script. I am
getting the following error message. I have the value set
for max_locks_per_transaction = 100 . Error message is as follows
WARNING: out of shared memory
ERROR: out of shared memory
HINT: You might need to inc
That's what I did. I did it for every 500 tables . 4 chunks.. It worked
Regards
On Wed, Apr 21, 2010 at 12:30 PM, John R Pierce wrote:
> akp geek wrote:
>
>> Hi All -
>>
>>I have been trying to drop 2000 tables using a script. I am
>> getting
Hi all -
I would request, If any one has document on how to read and
interpret the postgres execution plan, can you please share it?
Regards
thanks a lot. I am going thru it
Regards
On Thu, Apr 22, 2010 at 10:56 AM, Ben Chobot wrote:
> On Apr 22, 2010, at 5:43 AM, akp geek wrote:
>
> > Hi all -
> >
> > I would request, If any one has document on how to read and
> interpret the postgres execution
Hi All -
I have a table bloated with following details
rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960 (3 GB)
*
I did a vacuum on the database and also I did vacuumdb
full on the table. Still there is no change. Can you please suggest if t
.*
*INFO: index "pg_toast_1059337_index" now contains 0 row versions in 1
pages*
*DETAIL: 0 index pages have been deleted, 0 are currently reusable.*
*CPU 0.00s/0.00u sec elapsed 0.00 sec.*
*INFO: analyzing "Orders"*
Regards
On Mon, Apr 26, 2010 at 10:55 AM, Bill Moran wrote:
>
Thank you all for providing me important details. I will certainly follow
them to fix the issue I have
Regards
On Mon, Apr 26, 2010 at 11:53 AM, wrote:
>
>
> pgsql-general-ow...@postgresql.org wrote on 04/26/2010 03:43:03 PM:
>
> > Hi All -
> >
> > I have a table bloated with
Hi all -
I would like to know, if there is a open source BI tool for
creating reports against Postgres database ? appreciate your help
Regards
Business Intelligence tool ( crystal reports for example )
Regards
On Tue, Apr 27, 2010 at 12:38 PM, Raymond O'Donnell wrote:
> On 27/04/2010 17:33, akp geek wrote:
> > Hi all -
> >
> > I would like to know, if there is a open source BI tool for
&g
Thank you all .
regards
On Tue, Apr 27, 2010 at 2:42 PM, Adrian von Bidder wrote:
> On Tuesday 27 April 2010 19.12:31 Steve Atkins wrote:
>
> [...]
> > BIRT
> [...]
>
>
> FWIW, my cow-orkers are quite happy with BIRT (especially with the designer
> environment in Eclipse) after having used Crys
Hi All -
Is there a way to find which functions are being used by table.
Ex :- If there are functions fnc_a, fnc_b, fnc_c and table A is used in
fnc_a and fnc_c, How can we find that ? can you please help?
regards
got it.. Thank you
On Fri, Apr 30, 2010 at 12:17 PM, Tim Landscheidt
wrote:
> (anonymous) wrote:
>
> > Is there a way to find which functions are being used by table.
> > Ex :- If there are functions fnc_a, fnc_b, fnc_c and table A is used
> in
> > fnc_a and fnc_c, How can we find that ? ca
Dear all -
I am writing function to handle the passwords. Currently the
crypt is being used to store the password in the database. what I need to do
is, when the user wants to change the password, I need to check if that
password is not being used before up to 5 times, If not then t
dear all -
I would like to know if there is a way to restrict
individual users not to change the work_mem parameter for their session?
Reason I am asking is if there is 2GB RAM available, if one of the user want
to set the work_mem to 2GB because query is running slow. it might cau
Hi All -
Is there a way to direct the message generated during
pg_restore to a log file?
Regards
ay 2010 17:03, akp geek wrote:
> > Hi All -
> > Is there a way to direct the message generated during
> > pg_restore to a log file?
> > Regards
> >
>
> I think you can use "-f outputfile".
>
> Regards
>
> Thom
>
Thanks a lot
pg_restore -all options >output.txt 2>&1 worked
Regards
On Tue, May 18, 2010 at 12:15 PM, Scott Mead
wrote:
>
> On Tue, May 18, 2010 at 12:11 PM, akp geek wrote:
>
>> pg_restore -h 10.xx.xx.xxx -d dbName -n schemaName -v -U postgres
>> testDB
Deal All -
I would like to know if there is any plug in available to
export the result to excel from pgadmin. if I do that now, all the data gets
exported as csv . Appreciate your help
Regards
1 - 100 of 174 matches
Mail list logo
