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
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
, 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
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
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
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
-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
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
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
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
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
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
>
>
[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
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.
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.
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
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
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
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
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
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 -
> >
> >
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
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
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
>
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
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'
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
Thanks all. We will stick with CVS then. Thanks again
On Tue, Feb 28, 2012 at 3:36 PM, Greg Williamson wrote:
> akp geek asked:
>
> >
> > Would like to know if any one of you have used CVS or some other
> version controlling tools to version the postgres code?
Hi all -
Would like to know if any one of you have used CVS or some other
version controlling tools to version the postgres code? Any
recommendations? Appreciate your help
Regards
Mon, Jan 9, 2012 at 12:37 PM, akp geek wrote:
> >> I have statement_timeout as commented in the postgresql.conf. I just
> >> checked it..
> >
> > statement timeout, like so many things, can be set per user or per
> > database. Connect as the backup use and
I have the replication set up and I am running the pg_dump against the
master
Thanks
On Mon, Jan 9, 2012 at 2:33 PM, Adrian Klaver wrote:
> On Monday, January 09, 2012 11:16:46 am akp geek wrote:
> > I am using pg_dump to back up each schema in the database and there 6
> >
I have statement_timeout as commented in the postgresql.conf. I just
checked it..
Thanks
On Mon, Jan 9, 2012 at 2:31 PM, Scott Marlowe wrote:
> On Mon, Jan 9, 2012 at 11:05 AM, akp geek wrote:
> > Hi All -
> >
> > During the backup of the database, we ex
I am using pg_dump to back up each schema in the database and there 6
schemas in the database.
thanks
On Mon, Jan 9, 2012 at 1:26 PM, Jerry Sievers wrote:
> akp geek writes:
>
> > Hi All -
> >
> > ? ? ? ? ? ? ? ? During the backup of the database, we experience
> &g
Hi All -
During the backup of the database, we experience timeout on
queries. any one has experienced the same? Is there any parameters in the
postgressql.conf that I have to pay attention to? Can you please help
Regards
e, Dec 20, 2011 at 5:35 PM, Chris Travers wrote:
> On Tue, Dec 20, 2011 at 11:53 AM, akp geek wrote:
> > Hi All -
> >
> >Is there way that we write the logs specific to only one
> user
> > in postgres? What I want to do is, Write the log files that are
Hi All -
Is there way that we write the logs specific to only one
user in postgres? What I want to do is, Write the log files that are coming
from one user or block the log entry for a pariticular user. Can you
please help? We have postgres 9.0.4
Regards
Thanks , it worked
On Wed, Dec 7, 2011 at 12:01 PM, Ben Chobot wrote:
>
> On Dec 7, 2011, at 8:45 AM, akp geek wrote:
>
> > Small Clarification. I have gone through the documentation. I did not
> find any thing related to start ans stop replication after the replication
> i
please comment?
Regards
-- Forwarded message --
From: akp geek
Date: Wed, Dec 7, 2011 at 9:03 AM
Subject: postgres 9.0.4 Streaming relate question ..
To: pgsql-general
Hi All -
Need some help. We have been using postgres 9.0.4 for our
production environment for some time
Hi All -
Need some help. We have been using postgres 9.0.4 for our
production environment for some time. Today we are going to restart the
Solaris servers.
We have streaming on . My question is how to handle the streaming
when we start the database on the servers.
Can yo
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 -
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
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
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 -
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
-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
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 -
>>
>>
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
> >
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
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
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
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 = '*'
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
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
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
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
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 -
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
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 -
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,
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
I am getting the following error when I try to restore it from a dump. Any
suggestions?
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
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
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:
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
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
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
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
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 (
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.. 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 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
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
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
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
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
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 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
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,
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
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
,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 -
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
'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
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
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
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
_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 -
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
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
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 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
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 -
Is there a way I can tell table - sequence dependent information.
which sequences are being used by which table?
thanks for the help
Hi all -
Is there a way I can tell table - sequence dependent information.
which sequences are being used by which table?
thanks for the help
Hi all -
Is there any open source tool available for postgres to compare
data between 2 tables. Appreciate your help
Regards
Dear all -
In the postgres db we have, I see there are many pg_toast_temp and
pg_temp schemas are getting created. Is it ok to drop those schemas ? Is
there a way to prevent them being created? Can you please share you
thoughts?
Regards
Thank you all for the responses. I got a requirement from my boss that I
need to give read only access to only tables , so that users can write some
queries. At that time, he also mentioned that the users should not see the
code. I read the document , but not able to figure out how to do that and
t
It's not for the user postgres.. If I have created a testuser, can I hide
the code for that testuser?
Regards
On Thu, Jun 24, 2010 at 3:42 PM, Pavel Stehule wrote:
> Hello
>
> 2010/6/24 akp geek :
> > Hi all -
> > Is there way in postgres to set the user
Hi all -
Is there way in postgres to set the user privileges so that when
they login , the user can not see functions and views?
Regards
1 - 100 of 174 matches
Mail list logo