raha sadeghi wrote:
> i had active cube in template1; i mean i run cube.sql and there
> are cube functions in my databases but i don't know how to create
> cube!!!
> please help me and explain me how to do these kind of things step
> by step!!
Before anyone can make useful suggestions, I thin
On Sat, Dec 5, 2009 at 3:46 PM, Guillaume Lelarge
wrote:
> Le samedi 5 décembre 2009 à 23:08:58, Andy Shellam (Mailing Lists) a écrit :
>> Hi Scott,
>>
>> >> 7. we can set the privilege of user x for schema y
>> >> ie. database aaa contains schema a1, a2 and a3. user xx can query from
>> >> sche
Le samedi 5 décembre 2009 à 23:08:58, Andy Shellam (Mailing Lists) a écrit :
> Hi Scott,
>
> >> 7. we can set the privilege of user x for schema y
> >> ie. database aaa contains schema a1, a2 and a3. user xx can query from
> >> schema a1 only, user yy can query from schema a2 only?
> >
> > No, p
Hi Scott,
>> 7. we can set the privilege of user x for schema y
>> ie. database aaa contains schema a1, a2 and a3. user xx can query from
>> schema a1 only, user yy can query from schema a2 only?
> No, perms on schemas control schema actions like create. perms on
> tables control user access.
On Mon, Nov 30, 2009 at 5:19 PM, Kiswono Prayogo wrote:
> hi, i've used postgresql for few months now, but i still don't understand
> about the schema/database part and it's security consideration..
> was there any better documentation (with pictures ^^) than
> this: http://www.postgresql.org/docs
On Tue, Jul 03, 2007 at 08:15:35AM +0800, Yuan HOng wrote:
> sites shall update these tables, and the link is over a WAN, it seems
> the most appropriate replication solution would be a multi-master,
> asynchronous solution.
Yes, that would be best.
> be to use a separate table for order on web s
[EMAIL PROTECTED] ("Yuan HOng") writes:
> It seems Slony-II would be quite promising, but I can't wait that
> long. What is the best choice for me now?
Worth noting: Slony-II would never have been suitable, as it would
have required that all the "master" servers be in the same data
centre.
I don'
Assuming the ERP software uses MD5 hashes to protect the password:
Since MD5 is a ONE-WAY encryption algorithm, then you *might* be able to
use a reverse lookup hash table such as the one found here:
http://gdataonline.com/seekhash.php
There may be similar hash tables around for other encryption
sufian khan wrote:
> How I decrypt any password that is store in our database table
> app_users.
That would seem to strongly depend on how you encrypted it in the first
place.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)--
On Wed, Dec 21, 2005 at 02:11:18PM -0600, Scott Marlowe wrote:
> On Wed, 2005-12-21 at 14:02, Jim C. Nasby wrote:
> > On Tue, Dec 20, 2005 at 05:44:44PM +0800, zhuge xiao wrote:
> > > Is the server running locally and accepting connections on Unix domain
> > > socket "/tmp/.s.PGSQL.5432"?
> >
> >
On Wed, 2005-12-21 at 14:02, Jim C. Nasby wrote:
> On Tue, Dec 20, 2005 at 05:44:44PM +0800, zhuge xiao wrote:
> > Is the server running locally and accepting connections on Unix domain
> > socket "/tmp/.s.PGSQL.5432"?
>
> So what are the permissions on /tmp/.s.PGSQL.5432? Can apache write to
> i
On Tue, Dec 20, 2005 at 05:44:44PM +0800, zhuge xiao wrote:
> Is the server running locally and accepting connections on Unix domain
> socket "/tmp/.s.PGSQL.5432"?
So what are the permissions on /tmp/.s.PGSQL.5432? Can apache write to
it?
Actually, I think apache normally chroot's to ServerRoot
Ivan <[EMAIL PROTECTED]> writes:
> As you can see, disk usage stop grows for several hours
> (3-5) after vacuum, then start again.
You don't have max_fsm_pages set large enough. Note the output at the
end of the VACUUM printout:
> INFO: free space map: 67 relations, 20713 pages stored; 29872 to
> ПОДРОБНО: 414193 dead row versions cannot be removed yet.
Increase max_fsm_pages in postgresql.conf.
Ivan wrote:
Hello,
OS: Windows 2003 Server SP1
DB: Postgresql-8.0.3
I have a database for caching html pages. Main table consists of
fields for URL (varchar(8192)), page body (text) and a f
> after login into pgsql through a user, when i try to connect some other
> database it always says that permission denied.
> what do i do?
Read this about pg_hba.conf:
http://www.postgresql.org/docs/7.3/static/client-authentication.html
And this about DB users:
http://www.postgresql.org/docs/7
Maybe you should set environment variable:
LD_LIBRARYPATH=/usr/local/pgsql/lib
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
At 13:59 13.5.2002, Tom Lane wrote the following message:
>Tao Wan <[EMAIL PROTECTED]> writes:
> > I am installing postgresql-7.1.2 on Linux 2.4.12.
>
>Just out of curiosity, why aren't you installing 7.2.1?
is there a way to enable/disable bug compatibility with previous versions?
namely, opti
Tao Wan <[EMAIL PROTECTED]> writes:
> I am installing postgresql-7.1.2 on Linux 2.4.12.
Just out of curiosity, why aren't you installing 7.2.1?
Even if you have some reason to want to use a 7.1.* release, 7.1.3
would be the preferred choice.
Dunno about the _fxstat problem. Looking at /usr/in
On Apr 16, Dieudonne Nanga wrote:
> How do i insert a file in the database?
You mean large objects?
If yes, try
# select lo_import('');
this will return a OID.
and to access the same, try
# select lo_export(, '');
>
> ---(end of broadcast)---
Hello there!
psql# \copy "table_name" from /path/from/file/to_copy
Regards
Sonny
On Tue, 16 Apr 2002, Dieudonne Nanga wrote:
> How do i insert a file in the database?
>
> ---(end of broadcast)---
> TIP 3: if posting/reading through Usenet,
Hi,there,
I hope it helps;
1. postgres by default allows 16 sessiones(if I don't remember wrong)
at same time. You can change the setting according to the doccument.
open too many sessiones at same time will more or less affect the
performance.
2. I believe that using Pg module will be
21 matches
Mail list logo
