el dorado wrote:
> Hello.
> I had such an error but rather long ago. Unfortunately I don't remember all
> the details but you could try to do the followig:
> - check if the directory 'data' has read/write rights for your OS account
> (account under which you try to start postgres).
> - check if y
On Wed, Oct 14, 2009 at 2:42 PM, Andale wrote:
>
> Hi
>
> We have an Postgresql 8.2.5 installation on a Windows server 2003 that have
> worked perfectly for our Mediawiki until we tried to update to 8.4. Before
> the update we took a backup, stopped the service and took a copy of the
> entire dat
I've noticed that if I just log in to my server, I don't su to root,
or become the postgres user, I can get straight into the database as
the postgres user merely with "psql -U postgres -h localhost". My
user account isn't a member of the postgres group.
It appears I've not applied my security se
Naoko Reeves wrote:
> Could you tell me how to Export ALL plpgsql
> functions/triggers to file?
I'd do it as follows:
- Perform a pg_dump of the database object definitions:
pg_dump -F c -s -f database.dmp database
- Create a listing, delete everything except triggers and functions:
pg_rest
In response to Thom Brown :
> I've noticed that if I just log in to my server, I don't su to root,
> or become the postgres user, I can get straight into the database as
> the postgres user merely with "psql -U postgres -h localhost". My
> user account isn't a member of the postgres group.
>
> It
> From: Thom Brown
> Subject: [GENERAL] Too easy to log in as the "postgres" user?
> To: "PGSQL Mailing List"
> Date: Thursday, 15 October, 2009, 11:38 AM
> I've noticed that if I just log in to
> my server, I don't su to root,
> or become the postgres user, I can get straight into the
> database
2009/10/15 A. Kretschmer :
>>
>> The pg_hba.conf is probably relevant here, so this is the setup:
>>
>> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>>
>> # "local" is for Unix domain socket connections only
>> local all all trust
>> # IPv4 lo
* Thom Brown (thombr...@gmail.com) wrote:
> 2009/10/15 A. Kretschmer :
> >>
> >> The pg_hba.conf is probably relevant here, so this is the setup:
> >>
> >> # TYPE DATABASE USER CIDR-ADDRESS METHOD
> >>
> >> # "local" is for Unix domain socket connections only
> >> local all
2009/10/15 Stephen Frost :
> * Thom Brown (thombr...@gmail.com) wrote:
>>
>> I've made that change, but now PostgreSQL won't start, and outputs the
>> following error in the log:
>>
>> 2009-10-15 11:52:41 BST [18720]: [2-1] CONTEXT: line 74 of
>> configuration file "/var/lib/postgresql/8.4/data/pg
Hi,
I can't find the documentation of the ~=~ operator anywhere on the
PostgreSQL homepage. I'm quite certain that I saw it there a while ago,
though.
FYI, I use ~=~ for equality checks, so I can use the same index for
equality and regexp pattern matching on a varchar field. The index is
built
Let me clarify bit more so I can do thing in proper manner...
I take base backup(full).
at fixed interval I need to take incremental backup and for that...
I use following commands.
psql -U postgres -c "select pg_switch_xlog()"
psql -U postgres -c "SELECT pg_stop_backup()"
after that the WAL
On 15 Oct 2009, at 24:53, Christophe Pettus wrote:
Hi,
The video from "Statistics and Postgres — How the Planner Sees Your
Data," the September 8, 2009 meeting of the SFPUG, is now available
on Vimeo:
http://vimeo.com/7051082
I watched this with interest. There is reference to s
2009/10/15 Alban Hertroys :
> On 15 Oct 2009, at 24:53, Christophe Pettus wrote:
>
>> Hi,
>>
>> The video from "Statistics and Postgres — How the Planner Sees Your Data,"
>> the September 8, 2009 meeting of the SFPUG, is now available on Vimeo:
>>
>> http://vimeo.com/7051082
>
> I watched th
* Thom Brown (thombr...@gmail.com) wrote:
> Okay, I've just ended up commenting out the host lines and it's
> effective enough as far as logging in is concerned. However, the
> websites which use the database are no longer able to connect. I
> should point out that they are connecting to pgbounce
Thom,
You appear to be trusting all connections what I think you want is the
following:
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
# IPv6 local connections:
host all all ::1/128 ident sameuser
Remember that you need to get postgres to reread t
* Andrew Bailey (hazloreali...@gmail.com) wrote:
> You appear to be trusting all connections what I think you want is the
> following:
>
> local all all ident sameuser
> # IPv4 local connections:
> host all all 127.0.0.1/32 ident sameuser
> # IPv6 local connections:
> host all all ::1/128 ident sa
Viktor Rosenfeld writes:
> I can't find the documentation of the ~=~ operator anywhere on the
> PostgreSQL homepage.
Which version's documentation are you reading? It's gone as of 8.4.
> FYI, I use ~=~ for equality checks, so I can use the same index for
> equality and regexp pattern matching o
>
> There is reference to slides with some
> frequency though, are they available somewhere?
>
Ya.
http://encodestatistics.org/publications/statistics_and_postgres.pdf
Is there a better place for this?
-Nathan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
Nathan Boley escribió:
> >
> > There is reference to slides with some
> > frequency though, are they available somewhere?
> >
>
> Ya.
>
> http://encodestatistics.org/publications/statistics_and_postgres.pdf
>
> Is there a better place for this?
I don't know how they do it but the pgcon 2009 pag
Alvaro Herrera writes:
> Nathan Boley escribió:
>> http://encodestatistics.org/publications/statistics_and_postgres.pdf
>> Is there a better place for this?
> I don't know how they do it but the pgcon 2009 page has links to videos
> of the presentations that have the slides changing in coordinati
On Oct 15, 2009, at 8:20 AM, Nathan Boley wrote:
http://encodestatistics.org/publications/statistics_and_postgres.pdf
Is there a better place for this?
For now, I'll add it to the Vimeo page.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general
Hi,
I have a stored procedure in db that takes a 'timestamp without time zone'
as its parameter.
The application uses c# and npgsql to access database.
When I call the stored procedure from c#, I got an exception says that the
stored procedure with 'timestamp with time zone' is unknown. It seems
Hi
While looking at an error message for iexplore.exe, I noticed, on Task Manager,
that there are 5 or more instances of postgres.exe running. Each instance is
consuming between 7 to 10 megs of resources, for a total of almost 50 megs.
Is this normal behavour?
If so, could someone enlighten me
2009/10/15 Bob Pawley :
> Hi
>
> While looking at an error message for iexplore.exe, I noticed, on Task
> Manager, that there are 5 or more instances of postgres.exe running. Each
> instance is consuming between 7 to 10 megs of resources, for a total of
> almost 50 megs.
>
> Is this normal behavour
Bob Pawley wrote:
Hi
While looking at an error message for iexplore.exe, I noticed, on Task
Manager, that there are 5 or more instances of postgres.exe running.
Each instance is consuming between 7 to 10 megs of resources, for a
total of almost 50 megs.
Is this normal behavour?
If so, co
Bob,
>
>
> While looking at an error message for iexplore.exe, I noticed, on Task
> Manager, that there are 5 or more instances of postgres.exe running. Each
> instance is consuming between 7 to 10 megs of resources, for a total of
> almost 50 megs.
>
> Is this normal behavour?
>
> 5 instances is t
On Thu, Oct 15, 2009 at 12:07 PM, Brian Modra wrote:
> 2009/10/15 Bob Pawley :
> > Hi
> >
> > While looking at an error message for iexplore.exe, I noticed, on Task
> > Manager, that there are 5 or more instances of postgres.exe running. Each
> > instance is consuming between 7 to 10 megs of reso
Hi,
As postgres now has enum type, does npgsql driver support the enum type?
I use c# and npgsql as databse driver. One of the database stored procedure
takes enum as its parameter.
What will be the DbType for postgres enum type?
Thanks /dan
--
View this message in context:
http://www.nabb
On Thu, Oct 15, 2009 at 12:31 PM, danclemson wrote:
>
> Hi,
>
> As postgres now has enum type, does npgsql driver support the enum type?
>
> I use c# and npgsql as databse driver. One of the database stored procedure
> takes enum as its parameter.
>
> What will be the DbType for postgres enum typ
2009/10/15 Merlin Moncure :
> On Thu, Oct 15, 2009 at 12:31 PM, danclemson wrote:
>>
>> Hi,
>>
>> As postgres now has enum type, does npgsql driver support the enum type?
>>
>> I use c# and npgsql as databse driver. One of the database stored procedure
>> takes enum as its parameter.
>>
>> What w
On Thu, Oct 15, 2009 at 2:52 PM, William Temperley > I recently
stopped using enums after reading this:
> http://www.commandprompt.com/blogs/joshua_drake/2009/01/fk_check_enum_or_domain_that_is_the_question/
> Using a foreign key to a single column table is pretty much as fast as
> an enum, is supp
Thanks for the information.
I did try the approach, but it failed due to any other issue with npgsql.
The stored procedure returns a setof refcursor.
If I use "select * from test('e1':testEnum)", the command.ExecuteReader does
not return the datareader properly. The code errored out when I use t
On Thu, Oct 15, 2009 at 4:14 PM, danclemson wrote:
>
> Thanks for the information.
>
> I did try the approach, but it failed due to any other issue with npgsql.
>
> The stored procedure returns a setof refcursor.
> If I use "select * from test('e1':testEnum)", the command.ExecuteReader does
> not
Is there any easy way to create sparse arrays with Postres?
Specifically, when I construct, add or aggregate data to an array, I
want to be able to specify the position within the array where the
data is placed and have any intervening positions that have not yet
been populated just marked as nulls
Peter Hunsberger writes:
> Is there any easy way to create sparse arrays with Postres?
Have you tried it?
regression=# create table foo (bar text[]);
CREATE TABLE
regression=# insert into foo (bar[3],bar[7]) values ( 'a', 'b');
INSERT 0 1
regression=# select * from foo;
bar
Peter Hunsberger writes:
Is there any easy way to create sparse arrays with Postres?
Have you tried it?
regression=# create table foo (bar text[]);
CREATE TABLE
regression=# insert into foo (bar[3],bar[7]) values ( 'a', 'b');
INSERT 0 1
regression=# select * from foo;
bar
On 06/10/2009, at 11:51 PM, Geoffrey wrote:
We are currently using WAL shipping to have a hot spare of our
databases. We want to add another node to this configuration. The
question is, what is the best way to go about this?
Currently, our script checks to see if the WAL file already exis
Hi.
Can anyone tell me, which are the differences between PGCluster and
CyberCluster?
I need a multi-master, synchronous replication solution based on PostgreSQl
and I have founded these tools. But I think they are almost ident and I'd like
to see your opinions about...
Regards,
Y.
--
Hi all
Thanks for all your responses. I have not yet been able to try your
suggestions as I have access to the system only on tuesday and wednesday. I
will come back and report how it goes.
/Anders
--
View this message in context:
http://www.nabble.com/could-not-open-process-token%3A-error-cod
39 matches
Mail list logo
