My XP is crashed and now I have to take a full backup of my postgresql 8.4
I am used to get backup of ldf/mdf files in case of SQLServer
Please let me know the right way of doing this for postgresql 8.4.
--
Thanks & Best Regards,
Waqar Azeem
On 03/24/11 12:07 AM, Waqar Azeem wrote:
My XP is crashed and now I have to take a full backup of my postgresql
8.4
I am used to get backup of ldf/mdf files in case of SQLServer
Please let me know the right way of doing this for postgresql 8.4.
you need everything in the $PGDATA directory.
On Thu, 24 Mar 2011 10:50:32 +0530, Nick Raj wrote:
If Datum contains only the value (not having type specific info.),
then
Suppose i want to print the Datum V value (already defined in
postgres)
then printf("%??", V);
Because V is assigned by PG_GETARG_POINTER(1);
I dont having the information
Hi,
We're getting a deadlock in our application (a web application with a
PostgreSQL backend) which I've traced to libpq. I've started our
application in gdb, and when it hangs, I've inspected the backtraces.
I've found a couple of threads I can account for (listening for new
connections, backgrou
On Thu, Mar 24, 2011 at 1:33 AM, David Johnston wrote:
> I am not sure how I'd go about testing a parameterized
> query without using JDBC...
>
How about this?
http://www.postgresql.org/docs/9.0/interactive/sql-prepare.html
HTH,
WBL
>
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgs
Hi everybody,
i'm having a very strange Problem:
My JEE Application initially persists Users at startup.
The problem is that the passwords are not stored,
while other data with the same datatype on this table are stored
correctly!?!
If I turn log_statement to 'all' in config I can
Are you sure the password is NULL? Some fields are not shown in pgAdmin if
they are too long, but that seems improbable to me for passwords.
pgAdmin also has an option "Show NULL values as " (in
file|options|query).
If you take the SQL from the log, can you reproduce this in postgres?
If so, pleas
Thanks for your answer.
I'm not sure if the Password is NULL or a empty string,
I will check this in the evening, I have no access no...
If I run the INSERT statement from pgAdmin it works fine!
Here is the statement from the log file (with original personal data,
after this are jus
I copy the whole folder 'Data' to another PC where fresh postgresql
8.4 is installed (same as default config. that previous version have
had)
when i started the server got following ...
The postgresql-8.4 - PostgreSQL Server 8.4 service could not be started.
The service did not report an error
On Thu, Mar 24, 2011 at 04:31:19PM +0500, Waqar Azeem wrote:
> The postgresql-8.4 - PostgreSQL Server 8.4 service could not be started.
>
> The service did not report an error.
>
> More help is available by typing NET HELPMSG 3534.
>
> The start command returned an error (2)
>
> Press to cont
On 24/03/2011 11:31, Waqar Azeem wrote:
I copy the whole folder'Data' to another PC where freshpostgresql8.4
is installed (same as default config. that previous version have
had)
when i started the server got following ...
The postgresql-8.4 - PostgreSQL Server 8.4 service could not be
started
On Thu, Mar 24, 2011 at 12:37:25PM +0100, Karsten Hilbert wrote:
> > More help is available by typing NET HELPMSG 3534.
...
> > any clue?
And the second Google result has this:
http://archives.postgresql.org/pgsql-bugs/2009-05/msg5.php
Karsten
--
GPG key ID E4071346 @ gpg-keyserv
my windows event viewer says:
2011-03-24 11:24:22 GMT FATAL: could not create lock file "postmaster.pid":
Permission denied
is this helpfull?
On Thu, Mar 24, 2011 at 4:31 PM, Waqar Azeem
wrote:
> I copy the whole folder 'Data' to another PC where fresh postgresql 8.4 is
> installed (same as
2011/3/24 Willy-Bas Loos :
> On Thu, Mar 24, 2011 at 1:33 AM, David Johnston wrote:
>>
>> I am not sure how I'd go about testing a parameterized
>> query without using JDBC...
>
> How about this?
> http://www.postgresql.org/docs/9.0/interactive/sql-prepare.html
> HTH,
> WBL
you can't prepare a DO
Thanks Karsten n' Raymond,
Finally, I change the logging in account to Local System account as
suggested in your URL. And then change it back to .\postgres
This magically worked for me.
I think ctrl+alt+del was a compulsory part of XP trouble shootings :)
-- Waqar
On Thu, Mar 24, 2011 at 5:10 P
Hello,
I have a call to setweight function in a PreparedStatement with the following
sql:
update my_table set a_text_data=setweight(to_tsvector(? :: regconfig, ?), ? ::
char)
Later I set the parameters:
stmt.setString(1, language);
stmt.setString(2, textToIndex);
stmt.setString(3, weight);
B
Waqar,
> my windows event viewer says:
> 2011-03-24 11:24:22 GMT FATAL: could not create lock file "postmaster.pid":
> Permission denied
> is this helpfull?
yes. that says that the windows-user your PostgreSQL Service is
running as has no write priv on the data directory. Check your file
systems
Hi,
I'm not quite sure but it probably means that postgresql was not built with
kerberos 5 support.
That would make sense if you are using a binary install (did not compile
from source), because of the notice at
http://www.postgresql.org/docs/9.0/interactive/auth-methods.html#KERBEROS-AUTH
"Note:
BTW, is there a way to find out what particular configure options were used
for any given (binary) installation?
WBL
On Thu, Mar 24, 2011 at 2:11 PM, Willy-Bas Loos wrote:
> Hi,
>
> I'm not quite sure but it probably means that postgresql was not built with
> kerberos 5 support.
> That would ma
On Thu, Mar 24, 2011 at 4:17 AM, Erik Hesselink wrote:
> Hi,
>
> We're getting a deadlock in our application (a web application with a
> PostgreSQL backend) which I've traced to libpq. I've started our
> application in gdb, and when it hangs, I've inspected the backtraces.
> I've found a couple of
On Thursday, March 24, 2011 4:26:30 am Altmann, Sebastian wrote:
> Thanks for your answer.
>
>
>
> I'm not sure if the Password is NULL or a empty string,
>
> I will check this in the evening, I have no access no...
I thought you saw the passwords in the log file which would seem to indicate
On Thu, Mar 24, 2011 at 14:23, Merlin Moncure wrote:
> On Thu, Mar 24, 2011 at 4:17 AM, Erik Hesselink wrote:
>> Hi,
>>
>> We're getting a deadlock in our application (a web application with a
>> PostgreSQL backend) which I've traced to libpq. I've started our
>> application in gdb, and when it h
On Thu, Mar 24, 2011 at 9:07 AM, Erik Hesselink wrote:
> On Thu, Mar 24, 2011 at 14:23, Merlin Moncure wrote:
>> On Thu, Mar 24, 2011 at 4:17 AM, Erik Hesselink wrote:
>>> Hi,
>>>
>>> We're getting a deadlock in our application (a web application with a
>>> PostgreSQL backend) which I've traced
On Thu, Mar 24, 2011 at 15:21, Merlin Moncure wrote:
> On Thu, Mar 24, 2011 at 9:07 AM, Erik Hesselink wrote:
>> On Thu, Mar 24, 2011 at 14:23, Merlin Moncure wrote:
>>> On Thu, Mar 24, 2011 at 4:17 AM, Erik Hesselink wrote:
Hi,
We're getting a deadlock in our application (a web
hyelluas writes:
> You are right to the point, Tom.
> The datex is timestamp with time zone and the constraints were created as
> timestamp without time zone.
> As soon as I fixed that , it all started working.
OK. In case anybody is wondering *why* that fixed it: a comparison
between timestamp
Merlin Moncure writes:
> *something* must be initializing ssl, or you can't make secure
> connections from libpq. you need to find out which pq ssl init
> function is begin called, when it is being called, and with what
> arguments. One of the main things PQInitSSL does is set up a lock
> vector
=?UTF-8?B?VmlsaWFtIMSOdXJpbmE=?= writes:
> I have a call to setweight function in a PreparedStatement with the following
> sql:
> update my_table set a_text_data=setweight(to_tsvector(? :: regconfig, ?), ?
> :: char)
Make that ::"char" not ::char ... the quotes matter here, because char
withou
Willy-Bas Loos writes:
> BTW, is there a way to find out what particular configure options were used
> for any given (binary) installation?
Run pg_config.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
On Thu, Mar 24, 2011 at 6:49 PM, Willy-Bas Loos wrote:
> BTW, is there a way to find out what particular configure options were used
> for any given (binary) installation?
>
>
The *pg_config* utility prints configuration parameters of the currently
installed version of PostgreSQL
*--configure*
On Thu, Mar 24, 2011 at 16:00, Tom Lane wrote:
> Merlin Moncure writes:
>> *something* must be initializing ssl, or you can't make secure
>> connections from libpq. you need to find out which pq ssl init
>> function is begin called, when it is being called, and with what
>> arguments. One of the
On Thu, Mar 24, 2011 at 10:00 AM, Tom Lane wrote:
> Merlin Moncure writes:
>> *something* must be initializing ssl, or you can't make secure
>> connections from libpq. you need to find out which pq ssl init
>> function is begin called, when it is being called, and with what
>> arguments. One of
On Thu, Mar 24, 2011 at 16:43, Merlin Moncure wrote:
> He needs to rule out the most obvious problem first -- PQInitSSL being
> called improperly or at the wrong time. OP: It's a library wide
> setting and must be called before the first connection is established
> and only once. Perhaps the HDB
Hello,
How can I determine the views which are using a certain view.
Thanks in advance
On Thu, Mar 24, 2011 at 10:54 AM, Erik Hesselink wrote:
> On Thu, Mar 24, 2011 at 16:43, Merlin Moncure wrote:
>> He needs to rule out the most obvious problem first -- PQInitSSL being
>> called improperly or at the wrong time. OP: It's a library wide
>> setting and must be called before the fir
On Thu, Mar 24, 2011 at 17:18, Merlin Moncure wrote:
> On Thu, Mar 24, 2011 at 10:54 AM, Erik Hesselink wrote:
>> On Thu, Mar 24, 2011 at 16:43, Merlin Moncure wrote:
>>> He needs to rule out the most obvious problem first -- PQInitSSL being
>>> called improperly or at the wrong time. OP: It's
On Thu, Mar 24, 2011 at 11:27 AM, Erik Hesselink wrote:
> On Thu, Mar 24, 2011 at 17:18, Merlin Moncure wrote:
>> On Thu, Mar 24, 2011 at 10:54 AM, Erik Hesselink wrote:
>>> On Thu, Mar 24, 2011 at 16:43, Merlin Moncure wrote:
He needs to rule out the most obvious problem first -- PQInitSS
On Thu, Mar 24, 2011 at 11:52 AM, Merlin Moncure wrote:
>> As far as connections getting dropped: yes, this sounds reasonable,
>> but given that both the client and the server are running on the same
>> machine, will connections (to 127.0.0.1) really be dropped once every
>> 100.000 or so?
>
> No,
On 24 March 2011 18:06, salah jubeh wrote:
> Hello,
>
> How can I determine the views which are using a certain view.
>
>
Name of the view can be searched on the "view_definition" column of the
"views" view of the information schema.
On 24/03/2011 16:06, salah jubeh wrote:
Hello,
How can I determine the views which are using a certain view.
If you're using pgAdmin, there's a "Dependants" tab which shows you the
objects depending on another object.
Otherwise, I think you can query the pg_catalog.pg_depend table, but I
d
WHAT THE HELL!?!
Just came home from work
and did another testing:
I access my JEE App via EJBs and this is what i'm doing to create my
users at startup: i call the LOCAL BeanInterface
and the result is that my passwords get lost.
By the way this is the same behavior when i rename password to cit
Thanks guys
pg_depend seems Useful, I will check the manual.
Regards
From: Raymond O'Donnell
To: salah jubeh
Cc: pgsql
Sent: Thu, March 24, 2011 6:18:16 PM
Subject: Re: [GENERAL] which view is used another views
On 24/03/2011 16:06, salah jubeh wrote:
On Thu, Mar 24, 2011 at 11:57 AM, Merlin Moncure wrote:
> On Thu, Mar 24, 2011 at 11:52 AM, Merlin Moncure wrote:
>>> As far as connections getting dropped: yes, this sounds reasonable,
>>> but given that both the client and the server are running on the same
>>> machine, will connections (to 127
Any way I can have all newly created schemas/tables be owned by, or
have all permissions granted to, a certain group, without having to
remember to GRANT ALL ON [SCHEMA|TABLE] TO that group? Thanks in
advance.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
* Yang Zhang (yanghates...@gmail.com) wrote:
> Any way I can have all newly created schemas/tables be owned by, or
> have all permissions granted to, a certain group, without having to
> remember to GRANT ALL ON [SCHEMA|TABLE] TO that group? Thanks in
> advance.
ALTER DEFAULT PRIVILEGES FOR ROLE
On Thursday, March 24, 2011 1:52:24 pm Yang Zhang wrote:
> Any way I can have all newly created schemas/tables be owned by, or
> have all permissions granted to, a certain group, without having to
> remember to GRANT ALL ON [SCHEMA|TABLE] TO that group? Thanks in
> advance.
If you are using 9.0:
thanks a lot!
that function does it exactly as wished ;)!
Am 23.03.2011 22:46, schrieb Merlin Moncure:
On Wed, Mar 23, 2011 at 10:29 AM, Sven Haag wrote:
hello pgsql fans out there,
i've already created a function that returns a list of IDs of all sub-samples
based on a given sample ID. th
Keep in mind if you want to alter the GLOBAL privileges (i.e., the defaults)
granted via PUBLIC you MUST NOT specify a schema.
>From what I can tell there is no way to associate a default owner different
that the one executing the CREATE statement (though some inheritance cases
do arise IIRC).
Da
I've been trying to install postgresql9 on my ubuntu Desktop10 machine and it
seems that it is not supported, as the only version that is available in the
software center is Pgsql 8.4?
Having googled this, i cannot find a straight answer. Is Pgsql9 supported on
Ubuntu10LTS?
Thanks
--
View this m
On 25 March 2011 08:42, jcoder wrote:
> I've been trying to install postgresql9 on my ubuntu Desktop10 machine and it
> seems that it is not supported, as the only version that is available in the
> software center is Pgsql 8.4?
>
> Having googled this, i cannot find a straight answer. Is Pgsql9 s
On Thursday, March 24, 2011 4:17:38 pm Andrej wrote:
> On 25 March 2011 08:42, jcoder wrote:
> > I've been trying to install postgresql9 on my ubuntu Desktop10 machine
> > and it seems that it is not supported, as the only version that is
> > available in the software center is Pgsql 8.4?
> >
> >
Any luck if I'm still on 8.4?
On Thu, Mar 24, 2011 at 3:17 PM, David Johnston wrote:
> Keep in mind if you want to alter the GLOBAL privileges (i.e., the defaults)
> granted via PUBLIC you MUST NOT specify a schema.
>
> From what I can tell there is no way to associate a default owner different
>
On Thursday, March 24, 2011 6:10:32 pm Yang Zhang wrote:
> Any luck if I'm still on 8.4?
>
As far as I know, no luck. If you search the list archives there are some
scripts people have posted that will walk through a database or schema and
change permissions.
--
Adrian Klaver
adrian.kla...@g
Hi Willy and Raghu,
I rebuild from source code with kerberos/gssapi support, and changed to use
'gss' authentication method, it works now :)!
Thanks very much for your kindly help.
Regards,
Yandong
From: raghu ram mailto:raghuchenn...@gmail.com>>
Date: Thu, 24 Mar 2011 11:09:33 -0400
To: Will
This AGPLv2 application will be designed to bring the control and data
management capabilities of an RDBMS to the average user in a simple, easy to
use OS independent application. The content will be delivered in an easy to
use and manipulate format within the convenience of a modern browser. The
Hi, all!!
The Npgsql Development Team is proud to announce the Npgsql2 2.0.12
beta1 release!
Npgsql is a .Net Data provider written 100% in C# which allows .net
programs to talk to postgresql backends. Npgsql is licensed under BSD.
More info can be obtained from http://www.npgsql.org
Thsi is the
I've been getting database out of memory failures with some queries which deal
with a reasonable amount of data.
I was wondering what I should be looking at to stop this from happening.
The typical messages I been getting are like this: http://pastebin.com/Jxfu3nYm
The OS is:
Linux TSTLHAPP01
On Thu, Mar 24, 2011 at 9:23 PM, Jeremy Palmer wrote:
> I’ve been getting database out of memory failures with some queries which
> deal with a reasonable amount of data.
>
> I was wondering what I should be looking at to stop this from happening.
>
> The typical messages I been getting are like t
57 matches
Mail list logo
