Hi,
I need to store a lot of large files (thousands of 10-100 MB files)
uploaded through my web application and I find that storing them in
database as bytea field is not practical for backup purposes.
My database has full backup performed every 12 hours and backup is
encrypted and copied to serv
s.
On Fri, Jan 29, 2010 at 10:50 PM, hubert depesz lubaczewski
wrote:
> On Fri, Jan 29, 2010 at 07:20:33PM +1100, Joe Kramer wrote:
>> I need to generate unique id which is not guessable unlike
>> serial(integer) type. I need an id in format like md5 hash of random
>> numbe
mare.
Any suggestions?
Thanks.
On Fri, Jan 29, 2010 at 10:20 PM, Adrian von Bidder
wrote:
> On Friday 29 January 2010 11.21:00 Joe Kramer wrote:
>> We have bunch of servers running the app and rebuilding postgres with
>> support for ossp_uuid on all servers is time consuming.
>>
all uuid_generate_v4() does is
simply generate md5 of random number.
Thanks.
On Fri, Jan 29, 2010 at 8:31 PM, Adrian von Bidder wrote:
>
> Hi,
>
> On Friday 29 January 2010 09.20:33 Joe Kramer wrote:
>> I need to generate unique id which is not guessable unlike
>> serial(
Hello,
I need to generate unique id which is not guessable unlike
serial(integer) type. I need an id in format like md5 hash of random
number.
On top of that I need this id to be unique across multiple tables.
Anyone had to solve this problem before? Can you post any recipes or
best practices ple
On Thu, Sep 24, 2009 at 1:33 AM, Tom Lane wrote:
> Joe Kramer writes:
>> On Thu, Sep 24, 2009 at 12:53 AM, Tom Lane wrote:
>>> You sure they weren't disabled in the source database?
>
>> Yes, I'm absolutely sure they are not disabled. And in the SQL dump
>
On Thu, Sep 24, 2009 at 12:53 AM, Tom Lane wrote:
> Joe Kramer writes:
>> I have database backup schema+data in text (non-compressed) format.
>> Backup is created using "pg_dump -i -h ... -U ... -f dump.sql".
>> I run it with "psql
> You sure they
On Thu, Sep 24, 2009 at 12:02 AM, Adrian Klaver wrote:
> On Tuesday 22 September 2009 7:28:03 pm Joe Kramer wrote:
>> I have database backup schema+data in text (non-compressed) format.
>> Backup is created using "pg_dump -i -h ... -U ... -f dump.sql".
>> I run
I have database backup schema+data in text (non-compressed) format.
Backup is created using "pg_dump -i -h ... -U ... -f dump.sql".
I run it with "psql http://www.postgresql.org/mailpref/pgsql-general
Don't help either.
Jdbc statement:
SELECT * from "public"."user" ;
Exception:
ERROR: relation "public.user" does not exist
On Tue, May 12, 2009 at 5:55 PM, Scott Marlowe wrote:
> On Tue, May 12, 2009 at 1:26 AM, Joe Kramer wrote:
>> Hi,
>>
Hi,
I have table named user (lower case) in public schema.
I can access it using Pgadmin as
SELECT * from "user"; SELECT * from "public.user"; SELECT * FROM public.user;
I can't find any way to access this table from Jdbc.
Tried to access as public.user, user in single and double quotes, nothing
Hello,
I have table for online chat system that keep messages sent between users.
CREATE TABLE chat_message
(
message_time timestamp without time zone NOT NULL DEFAULT now(),
message_body text,
user_id_from bigint,
user_id_to bigint,
CONSTRAINT chat_message_pkey PRIMARY KEY (message_time)
)
Pgsql 8.1.4.
I want return custom type from function as row, not as values in brackets (1,2).
I have following type and function:
CREATE TYPE new_item_return_type AS
(item_id bigint,
last_update timestamp without time zone);
CREATE OR REPLACE FUNCTION new_item( new_title int8, new_user_id
Thank you for Mac OSX Universal support at last ! Now the last PowerPc
application is gone Universal on my Mac.
Pgadmin now 4 times faster as Universal on Intel!
Thanks for your great work!
On 9/14/06, Dave Page wrote:
I'm pleased to announce the first beta version of pgAdmin III v1.6.0 is
ava
Hello,
I am designing database for a web product with large number of data records.
- Few tables but number of objects is tens-hundreds of thousands.
- less than 100 queries per second.
The application has basically tens thousands of (user) accounts,
every account has associated hundreds of it
If it was commited to HEAD, it will appear in 8.1.5, right?
On 5/30/06, Bruce Momjian wrote:
Patch applied to CVS HEAD and 8.1.X. Thanks.
---
Marko Kreen wrote:
> On 5/9/06, Joe Kramer <[EMAIL PROTECTED]&
What the hell is Rupees?
On 5/29/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote:
Hi there,
Help me by taking this survey. We can both get 1000 Rupees! Click here:
http://rewards.popstarnetworkpanel.com/?r=EVEkOCgmiSJTBGsFDi0O&i=gmail&p=4&z=1&tc=2
---(end of broadcast)--
/20/06, John DeSoi <[EMAIL PROTECTED]> wrote:
You can find some helpful grant scripts here:
http://pgedit.com/tip/postgresql/access_control_functions
On 5/19/06, Joe Kramer <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I need to grant all privileges on all objects in data
Hello,
I need to grant all privileges on all objects in database. Without
using SUPERUSER.
It's strange that GRANT ALL PRIVILEGES ON DATABASE is useless, it
don't grant privileges on tables.
I've found out this "best practice", (more like ugly workaround):
select 'grant all on '||schemaname||'
We've been using EMS PostgreSQL admin.Pros:It has great visual tools for building views. Like in Enterprise manager or MS Access. pgAdmin don't have that.Great import/export abilities. PGAdmin don't have much flexibility.
Cons:Too bad it don't support UNICODE and not known if it will.Problems with
On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:
On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:> On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:> > The fact that Fedora pgcrypto is linked with OpenSSL that does not
> > support SHA256 is not a bug, just a f
On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:
On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:> Thanks, but I need it to work out-of-the-box, with standard installation of> RedHat or Gentoo and standard PostgreSQL rpm.
>> I am developing application with PortgreSQL a
to compile
openSSL 0.9.8."
Pgcrypto depends on OpenSSL 0.9.8. And 0.9.8 is not "Stable" in RedHat
and Gentoo. So you need to recompile pgcrypto/openssl anyway if you
want to use it.
Can I report this in PostgreSQL bug system?
Regards.On 5/9/06, Marko Kreen <[EMAIL PROTECTED]&g
Hello,Pgcrypto SHA 256/384/512 algorithm don't work on RedHat:
db=# SELECT digest('test', 'sha1');
digest
--
\251J\217\345\314\261\233\246\034L\010s\323\221\351\207\230/\273\323
(1 row)
db=# SELECT
24 matches
Mail list logo
